covid-testing-all-observations

Data license: ODbL · Data source: our world in data github owid/covid-19-data repository

24,892 rows sorted by Source label

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Date (date)

Link rowid Entity Date ISO code Source URL Source label ▼ Notes Cumulative total Daily change in cumulative total Cumulative total per thousand Daily change in cumulative total per thousand 7-day smoothed daily change 7-day smoothed daily change per thousand Short-term tests per case Short-term positive rate
2 2 Australia - tests performed 2020-03-23 AUS                      
3 3 Australia - tests performed 2020-03-24 AUS                      
4 4 Australia - tests performed 2020-03-25 AUS                      
5 5 Australia - tests performed 2020-03-26 AUS                      
6 6 Australia - tests performed 2020-03-27 AUS                      
7 7 Australia - tests performed 2020-03-28 AUS                      
9 9 Australia - tests performed 2020-03-30 AUS               10105 0.396 29.671 0.034
10 10 Australia - tests performed 2020-03-31 AUS               10466 0.41 26.796999999999997 0.037000000000000005
11 11 Australia - tests performed 2020-04-01 AUS               10827 0.425 33.183 0.03
12 12 Australia - tests performed 2020-04-02 AUS               11187 0.439 35.971 0.027999999999999997
13 13 Australia - tests performed 2020-04-03 AUS               11548 0.45299999999999996 39.279 0.025
14 14 Australia - tests performed 2020-04-04 AUS               11909 0.467 38.416 0.026000000000000002
129 129 Australia - tests performed 2020-07-28 AUS               64562 2.532 157.688 0.006
132 132 Australia - tests performed 2020-07-31 AUS               62917 2.467 146.953 0.006999999999999999
153 153 Australia - tests performed 2020-08-21 AUS               56334 2.209 209.97799999999998 0.005
154 154 Australia - tests performed 2020-08-22 AUS               56698 2.2230000000000003 238.513 0.004
160 160 Australia - tests performed 2020-08-28 AUS               66159 2.594 426.439 0.002
161 161 Australia - tests performed 2020-08-29 AUS               66054 2.59 444.167 0.002
167 167 Australia - tests performed 2020-09-04 AUS               63110 2.475 607.6619999999999 0.002
168 168 Australia - tests performed 2020-09-05 AUS               66492 2.608 676.5169999999999 0.001
174 174 Australia - tests performed 2020-09-11 AUS               60764 2.383 916.698 0.001
175 175 Australia - tests performed 2020-09-12 AUS               56007 2.1959999999999997 913.867 0.001
181 181 Australia - tests performed 2020-09-18 AUS               44704 1.7530000000000001 1043.093 0.001
182 182 Australia - tests performed 2020-09-19 AUS               42364 1.661 1001.8510000000001 0.001
188 188 Australia - tests performed 2020-09-25 AUS               36912 1.4480000000000002 1519.906 0.001
189 189 Australia - tests performed 2020-09-26 AUS               36311 1.4240000000000002 1828.612 0.001
195 195 Australia - tests performed 2020-10-02 AUS               33046 1.296 2047.0970000000002 0.0
196 196 Australia - tests performed 2020-10-03 AUS               32046 1.2570000000000001 1985.15 0.001
197 197 Australia - tests performed 2020-10-04 AUS               31046 1.217 2069.7329999999997 0.0
198 198 Australia - tests performed 2020-10-05 AUS               32598 1.278 2376.938 0.0
202 202 Australia - tests performed 2020-10-09 AUS               32163 1.261 2046.736 0.0
203 203 Australia - tests performed 2020-10-10 AUS               33551 1.3159999999999998 2024.629 0.0
209 209 Australia - tests performed 2020-10-16 AUS               37333 1.464 1675.1989999999998 0.001
210 210 Australia - tests performed 2020-10-17 AUS               37804 1.483 1863.5770000000002 0.001
216 216 Australia - tests performed 2020-10-23 AUS               38153 1.496 2567.99 0.0
217 217 Australia - tests performed 2020-10-24 AUS               37634 1.476 2331.31 0.0
226 226 Austria - tests performed 2020-03-01 AUT                      
227 227 Austria - tests performed 2020-03-02 AUT                      
307 307 Austria - tests performed 2020-05-21 AUT               5776 0.6409999999999999 130.006 0.008
329 329 Austria - tests performed 2020-06-12 AUT               5327 0.591 167.215 0.006
361 361 Austria - tests performed 2020-07-14 AUT               6901 0.7659999999999999 90.632 0.011000000000000001
383 383 Austria - tests performed 2020-08-05 AUT               7222 0.802 63.992 0.016
426 426 Austria - tests performed 2020-09-17 AUT               13410 1.489 20.888 0.048
434 434 Austria - tests performed 2020-09-25 AUT               16106 1.788 23.122 0.043
442 442 Austria - tests performed 2020-10-03 AUT               18108 2.011 26.017 0.038
463 463 Austria - tests performed 2020-10-24 AUT               20089 2.231 9.816 0.102
468 468 Bahrain - units unclear 2020-03-06 BHR                      
470 470 Bahrain - units unclear 2020-03-08 BHR                      
475 475 Bahrain - units unclear 2020-03-13 BHR               562 0.33 35.764 0.027999999999999997
476 476 Bahrain - units unclear 2020-03-14 BHR               595 0.35 27.045 0.037000000000000005
477 477 Bahrain - units unclear 2020-03-15 BHR               605 0.35600000000000004 28.615 0.035
480 480 Bahrain - units unclear 2020-03-18 BHR               942 0.5539999999999999 51.92100000000001 0.019
481 481 Bahrain - units unclear 2020-03-19 BHR               1173 0.6890000000000001 87.351 0.011000000000000001
483 483 Bahrain - units unclear 2020-03-21 BHR               1505 0.884 140.467 0.006999999999999999
484 484 Bahrain - units unclear 2020-03-22 BHR               1684 0.99 124.084 0.008
486 486 Bahrain - units unclear 2020-03-24 BHR               1867 1.097 110.75399999999999 0.009000000000000001
487 487 Bahrain - units unclear 2020-03-25 BHR               1811 1.064 82.85600000000001 0.012
489 489 Bahrain - units unclear 2020-03-27 BHR               1603 0.9420000000000001 59.37 0.017
490 490 Bahrain - units unclear 2020-03-28 BHR               1427 0.8390000000000001 55.188 0.018000000000000002
493 493 Bahrain - units unclear 2020-03-31 BHR               1046 0.615 41.602 0.024
494 494 Bahrain - units unclear 2020-04-01 BHR               1031 0.606 40.774 0.025
495 495 Bahrain - units unclear 2020-04-02 BHR               1016 0.597 47.413000000000004 0.021
544 544 Bahrain - units unclear 2020-05-21 BHR               7326 4.305 24.75 0.04
571 571 Bahrain - units unclear 2020-06-17 BHR               8584 5.045 17.921 0.055999999999999994
573 573 Bahrain - units unclear 2020-06-19 BHR               8479 4.9830000000000005 15.773 0.063
575 575 Bahrain - units unclear 2020-06-21 BHR               8521 5.008 19.215999999999998 0.052000000000000005
577 577 Bahrain - units unclear 2020-06-23 BHR               7399 4.348 15.26 0.066
591 591 Bahrain - units unclear 2020-07-07 BHR               10900 6.406000000000001 21.301 0.047
593 593 Bahrain - units unclear 2020-07-09 BHR               10160 5.971 20.222 0.049
606 606 Bahrain - units unclear 2020-07-22 BHR               9628 5.6579999999999995 20.814 0.048
608 608 Bahrain - units unclear 2020-07-24 BHR               9629 5.659 23.147 0.043
610 610 Bahrain - units unclear 2020-07-26 BHR               10245 6.021 26.145 0.038
620 620 Bahrain - units unclear 2020-08-05 BHR               6469 3.802 20.480999999999998 0.049
628 628 Bahrain - units unclear 2020-08-13 BHR               10249 6.023 26.088 0.038
635 635 Bahrain - units unclear 2020-08-20 BHR               9574 5.627000000000001 34.887 0.028999999999999998
642 642 Bahrain - units unclear 2020-08-27 BHR               9577 5.627999999999999 20.897 0.048
646 646 Bahrain - units unclear 2020-08-31 BHR               9262 5.443 25.565 0.039
653 653 Bahrain - units unclear 2020-09-07 BHR               11351 6.671 24.854 0.04
656 656 Bahrain - units unclear 2020-09-10 BHR               12845 7.5489999999999995 20.726999999999997 0.048
659 659 Bahrain - units unclear 2020-09-13 BHR               10535 6.191 15.545 0.064
663 663 Bahrain - units unclear 2020-09-17 BHR               10861 6.382999999999999 15.627 0.064
666 666 Bahrain - units unclear 2020-09-20 BHR               11727 6.892 16.288 0.061
671 671 Bahrain - units unclear 2020-09-25 BHR               11720 6.888 18.11 0.055
684 684 Bahrain - units unclear 2020-10-08 BHR               10714 6.296 24.445 0.040999999999999995
703 703 Bahrain - units unclear 2020-10-27 BHR               10874 6.391 32.966 0.03
707 707 Bangladesh - tests performed 2020-03-05 BGD                      
768 768 Bangladesh - tests performed 2020-05-05 BGD               5261 0.032 8.706 0.115
945 945 Belarus - tests performed 2020-03-04 BLR                      
946 946 Belarus - tests performed 2020-03-05 BLR                      
947 947 Belarus - tests performed 2020-03-06 BLR                      
948 948 Belarus - tests performed 2020-03-07 BLR                      
949 949 Belarus - tests performed 2020-03-08 BLR                      
950 950 Belarus - tests performed 2020-03-09 BLR                      
951 951 Belarus - tests performed 2020-03-10 BLR               611 0.065 855.4 0.001
952 952 Belarus - tests performed 2020-03-11 BLR               611 0.065 855.4 0.001
954 954 Belarus - tests performed 2020-03-13 BLR               720 0.076 336.0 0.003
955 955 Belarus - tests performed 2020-03-14 BLR               829 0.08800000000000001 386.86699999999996 0.003
956 956 Belarus - tests performed 2020-03-15 BLR               938 0.099 437.733 0.002
958 958 Belarus - tests performed 2020-03-17 BLR               1067 0.113 248.967 0.004
959 959 Belarus - tests performed 2020-03-18 BLR               1087 0.115 281.815 0.004

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "covid-testing-all-observations" (
"Entity" TEXT,
  "Date" TEXT,
  "ISO code" TEXT,
  "Source URL" TEXT,
  "Source label" TEXT,
  "Notes" TEXT,
  "Cumulative total" INTEGER,
  "Daily change in cumulative total" INTEGER,
  "Cumulative total per thousand" REAL,
  "Daily change in cumulative total per thousand" REAL,
  "7-day smoothed daily change" INTEGER,
  "7-day smoothed daily change per thousand" REAL,
  "Short-term tests per case" REAL,
  "Short-term positive rate" REAL
);