johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: day
province_or_state >30
- Texas 254,491
- Georgia 162,920
- Virginia 135,590
- Kentucky 121,675
- Missouri 117,101
- Kansas 105,758
- Illinois 104,685
- North Carolina 102,044
- Iowa 100,603
- Tennessee 98,183
- Indiana 94,151
- Nebraska 92,863
- Ohio 90,027
- Minnesota 88,465
- Michigan 87,758
- Mississippi 83,968
- Oklahoma 79,376
- Arkansas 76,709
- Wisconsin 73,611
- Puerto Rico 71,726
- Alabama 69,765
- Pennsylvania 68,850
- Florida 68,836
- Louisiana 66,723
- South Dakota 66,362
- Colorado 66,146
- New York 64,046
- California 59,941
- West Virginia 56,193
- Montana 54,982
- …
country_or_region >30
- US 3,284,537
- Russia 78,307
- Japan 46,430
- China 34,865
- India 34,605
- Colombia 32,189
- Mexico 31,389
- Ukraine 26,597
- Brazil 25,862
- Peru 24,679
- Italy 20,264
- Sweden 19,824
- United Kingdom 19,730
- Spain 19,298
- Malaysia 18,241
- Germany 16,427
- Chile 16,296
- Canada 16,227
- Netherlands 15,842
- France 11,972
- Belgium 9,618
- Australia 8,420
- Pakistan 6,636
- New Zealand 3,188
- Denmark 3,077
- Mainland China 1,517
- Antarctica 1,073
- Kiribati 1,073
- Korea, North 1,073
- Nauru 1,073
- …
combined_key >30 ✖
- Abbeville, South Carolina, US 1,013
- Acadia, Louisiana, US 1,013
- Accomack, Virginia, US 1,013
- Ada, Idaho, US 1,013
- Adair, Iowa, US 1,013
- Adair, Missouri, US 1,013
- Adair, Oklahoma, US 1,013
- Adams, Colorado, US 1,013
- Adams, Illinois, US 1,013
- Adams, Indiana, US 1,013
- Adams, Mississippi, US 1,013
- Adams, Nebraska, US 1,013
- Adams, Pennsylvania, US 1,013
- Adams, Washington, US 1,013
- Addison, Vermont, US 1,013
- Afghanistan 1,013
- Aiken, South Carolina, US 1,013
- Alachua, Florida, US 1,013
- Alamance, North Carolina, US 1,013
- Alameda, California, US 1,013
- Alamosa, Colorado, US 1,013
- Albania 1,013
- Albany, New York, US 1,013
- Albany, Wyoming, US 1,013
- Albemarle, Virginia, US 1,013
- Alberta, Canada 1,013
- Alcorn, Mississippi, US 1,013
- Alexandria, Virginia, US 1,013
- Algeria 1,013
- Allamakee, Iowa, US 1,013
- …
Link | rowid | day | country_or_region ▼ | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2021-12-02 | Afghanistan | 157387 | 7310 | 0 | 33.93911 | 67.709953 | 2021-12-03 04:23:05 | Afghanistan | ||||
4017 | 4017 | 2021-10-28 | Afghanistan | 156166 | 7268 | 0 | 33.93911 | 67.709953 | 2021-10-29 04:22:03 | Afghanistan | ||||
8033 | 8033 | 2020-10-25 | Afghanistan | 40768 | 1511 | 34129 | 5128 | 33.93911 | 67.709953 | 2020-10-26 04:25:02 | Afghanistan | |||
12028 | 12028 | 2021-01-26 | Afghanistan | 54750 | 2389 | 47459 | 4902 | 33.93911 | 67.709953 | 2021-01-27 05:23:41 | Afghanistan | |||
16042 | 16042 | 2021-09-18 | Afghanistan | 154487 | 7186 | 0 | 33.93911 | 67.709953 | 2021-09-19 04:21:34 | Afghanistan | ||||
20057 | 20057 | 2021-05-28 | Afghanistan | 69130 | 2881 | 57119 | 9130 | 33.93911 | 67.709953 | 2021-05-29 04:20:41 | Afghanistan | |||
24071 | 24071 | 2022-03-20 | Afghanistan | 177093 | 7654 | 0 | 33.93911 | 67.709953 | 2022-03-21 04:20:50 | Afghanistan | ||||
28087 | 28087 | 2021-11-11 | Afghanistan | 156456 | 7292 | 0 | 33.93911 | 67.709953 | 2021-11-12 04:22:01 | Afghanistan | ||||
32103 | 32103 | 2021-08-25 | Afghanistan | 152722 | 7090 | 0 | 33.93911 | 67.709953 | 2021-08-26 04:21:28 | Afghanistan | ||||
36117 | 36117 | 2021-04-12 | Afghanistan | 57242 | 2529 | 52005 | 2708 | 33.93911 | 67.709953 | 2021-04-13 04:20:37 | Afghanistan | |||
40254 | 40254 | 2020-03-05 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
43162 | 43162 | 2020-04-13 | Afghanistan | 607 | 19 | 32 | 556 | 33.93911 | 67.709953 | 2020-04-13 23:07:34 | Afghanistan | |||
43379 | 43379 | 2021-11-02 | Afghanistan | 156307 | 7281 | 0 | 33.93911 | 67.709953 | 2021-11-03 06:22:09 | Afghanistan | ||||
50261 | 50261 | 2020-04-17 | Afghanistan | 845 | 30 | 99 | 716 | 33.93911 | 67.709953 | 2020-04-17 23:30:32 | Afghanistan | |||
50478 | 50478 | 2021-05-29 | Afghanistan | 70111 | 2899 | 57281 | 9931 | 33.93911 | 67.709953 | 2021-05-30 04:20:55 | Afghanistan | |||
54492 | 54492 | 2021-03-07 | Afghanistan | 55847 | 2449 | 49378 | 4020 | 33.93911 | 67.709953 | 2021-03-08 05:24:48 | Afghanistan | |||
62230 | 62230 | 2020-07-23 | Afghanistan | 36001 | 1215 | 24550 | 10236 | 33.93911 | 67.709953 | 2020-07-24 05:30:40 | Afghanistan | |||
62622 | 62622 | 2020-03-07 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
62732 | 62732 | 2022-11-12 | Afghanistan | 204417 | 7829 | 0 | 33.93911 | 67.709953 | 2022-11-13 04:21:14 | Afghanistan | ||||
66748 | 66748 | 2021-09-01 | Afghanistan | 153260 | 7123 | 0 | 33.93911 | 67.709953 | 2021-09-02 04:21:15 | Afghanistan | ||||
70762 | 70762 | 2022-02-07 | Afghanistan | 166924 | 7442 | 0 | 33.93911 | 67.709953 | 2022-02-08 04:21:15 | Afghanistan | ||||
74778 | 74778 | 2020-12-03 | Afghanistan | 46980 | 1822 | 37260 | 7898 | 33.93911 | 67.709953 | 2020-12-04 05:27:27 | Afghanistan | |||
78789 | 78789 | 2020-10-14 | Afghanistan | 40080 | 1485 | 33354 | 5241 | 33.93911 | 67.709953 | 2020-10-15 04:24:28 | Afghanistan | |||
82782 | 82782 | 2021-05-25 | Afghanistan | 66903 | 2836 | 56518 | 7549 | 33.93911 | 67.709953 | 2021-05-26 04:20:35 | Afghanistan | |||
86796 | 86796 | 2021-11-09 | Afghanistan | 156397 | 7290 | 0 | 33.93911 | 67.709953 | 2021-11-10 04:21:38 | Afghanistan | ||||
90812 | 90812 | 2022-07-23 | Afghanistan | 184473 | 7738 | 0 | 33.93911 | 67.709953 | 2022-07-24 04:20:47 | Afghanistan | ||||
98594 | 98594 | 2020-08-04 | Afghanistan | 36833 | 1292 | 25669 | 9872 | 33.93911 | 67.709953 | 2020-08-05 04:34:43 | Afghanistan | |||
98913 | 98913 | 2020-03-04 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
98997 | 98997 | 2022-01-14 | Afghanistan | 158639 | 7376 | 0 | 33.93911 | 67.709953 | 2022-01-15 04:21:07 | Afghanistan | ||||
103013 | 103013 | 2021-08-15 | Afghanistan | 152033 | 7021 | 0 | 33.93911 | 67.709953 | 2021-08-16 04:21:31 | Afghanistan | ||||
107138 | 107138 | 2021-06-19 | Afghanistan | 100521 | 4030 | 63875 | 32616 | 33.93911 | 67.709953 | 2021-06-20 04:21:48 | Afghanistan | |||
114201 | 114201 | 2020-05-08 | Afghanistan | 3563 | 105 | 472 | 2986 | 33.93911 | 67.709953 | 2020-05-09 02:32:35 | Afghanistan | |||
114422 | 114422 | 2022-09-06 | Afghanistan | 194614 | 7783 | 0 | 33.93911 | 67.709953 | 2022-09-07 04:20:59 | Afghanistan | ||||
122185 | 122185 | 2020-07-19 | Afghanistan | 35561 | 1185 | 23634 | 10742 | 33.93911 | 67.709953 | 2020-07-20 05:34:40 | Afghanistan | |||
122394 | 122394 | 2020-11-18 | Afghanistan | 43628 | 1638 | 35295 | 6695 | 33.93911 | 67.709953 | 2020-11-19 05:25:23 | Afghanistan | |||
126404 | 126404 | 2022-01-09 | Afghanistan | 158381 | 7373 | 0 | 33.93911 | 67.709953 | 2022-01-10 04:22:07 | Afghanistan | ||||
130420 | 130420 | 2022-10-04 | Afghanistan | 199690 | 7803 | 0 | 33.93911 | 67.709953 | 2022-10-05 04:23:06 | Afghanistan | ||||
137425 | 137425 | 2020-04-29 | Afghanistan | 1827 | 60 | 252 | 1515 | 33.93911 | 67.709953 | 2020-04-30 02:32:27 | Afghanistan | |||
137642 | 137642 | 2021-12-04 | Afghanistan | 157431 | 7312 | 0 | 33.93911 | 67.709953 | 2021-12-05 04:22:25 | Afghanistan | ||||
141658 | 141658 | 2022-07-09 | Afghanistan | 183235 | 7728 | 0 | 33.93911 | 67.709953 | 2022-07-10 04:20:54 | Afghanistan | ||||
145674 | 145674 | 2020-08-15 | Afghanistan | 37637 | 1374 | 27166 | 9097 | 33.93911 | 67.709953 | 2020-08-16 04:27:42 | Afghanistan | |||
149655 | 149655 | 2021-11-29 | Afghanistan | 157260 | 7308 | 0 | 33.93911 | 67.709953 | 2021-11-30 04:22:53 | Afghanistan | ||||
153671 | 153671 | 2021-01-08 | Afghanistan | 53332 | 2257 | 43440 | 7635 | 33.93911 | 67.709953 | 2021-01-09 05:22:18 | Afghanistan | |||
157683 | 157683 | 2022-03-29 | Afghanistan | 177658 | 7665 | 0 | 33.93911 | 67.709953 | 2022-03-30 04:20:45 | Afghanistan | ||||
161699 | 161699 | 2021-11-19 | Afghanistan | 156812 | 7299 | 0 | 33.93911 | 67.709953 | 2021-11-20 04:22:17 | Afghanistan | ||||
165715 | 165715 | 2022-06-21 | Afghanistan | 181808 | 7715 | 0 | 33.93911 | 67.709953 | 2022-06-22 04:20:54 | Afghanistan | ||||
169731 | 169731 | 2021-04-16 | Afghanistan | 57612 | 2535 | 52105 | 2972 | 33.93911 | 67.709953 | 2021-04-17 04:20:40 | Afghanistan | |||
177503 | 177503 | 2020-07-27 | Afghanistan | 36349 | 1273 | 25198 | 9878 | 33.93911 | 67.709953 | 2020-07-28 04:58:43 | Afghanistan | |||
177713 | 177713 | 2021-09-02 | Afghanistan | 153306 | 7127 | 0 | 33.93911 | 67.709953 | 2021-09-03 04:21:20 | Afghanistan | ||||
181727 | 181727 | 2021-02-21 | Afghanistan | 55604 | 2432 | 48834 | 4338 | 33.93911 | 67.709953 | 2021-02-22 05:24:21 | Afghanistan | |||
185741 | 185741 | 2022-02-13 | Afghanistan | 170604 | 7494 | 0 | 33.93911 | 67.709953 | 2022-02-14 04:20:51 | Afghanistan | ||||
189757 | 189757 | 2021-01-11 | Afghanistan | 53538 | 2288 | 44137 | 7113 | 33.93911 | 67.709953 | 2021-01-12 05:22:15 | Afghanistan | |||
193769 | 193769 | 2020-08-31 | Afghanistan | 38248 | 1406 | 29089 | 7753 | 33.93911 | 67.709953 | 2020-09-01 04:28:31 | Afghanistan | |||
197929 | 197929 | 2022-10-19 | Afghanistan | 201557 | 7812 | 0 | 33.93911 | 67.709953 | 2022-10-20 04:22:59 | Afghanistan | ||||
201945 | 201945 | 2020-12-25 | Afghanistan | 51595 | 2135 | 40444 | 9016 | 33.93911 | 67.709953 | 2020-12-26 05:22:28 | Afghanistan | |||
205956 | 205956 | 2020-08-19 | Afghanistan | 37685 | 1379 | 27166 | 9140 | 33.93911 | 67.709953 | 2020-08-20 04:27:43 | Afghanistan | |||
209941 | 209941 | 2020-10-29 | Afghanistan | 41145 | 1529 | 34239 | 5377 | 33.93911 | 67.709953 | 2020-10-30 04:24:49 | Afghanistan | |||
217440 | 217440 | 2020-06-08 | Afghanistan | 21003 | 373 | 2171 | 18459 | 33.93911 | 67.709953 | 2020-06-09 03:33:03 | Afghanistan | |||
217650 | 217650 | 2022-12-26 | Afghanistan | 207438 | 7846 | 0 | 33.93911 | 67.709953 | 2022-12-27 04:21:07 | Afghanistan | ||||
221666 | 221666 | 2022-05-09 | Afghanistan | 179010 | 7685 | 0 | 33.93911 | 67.709953 | 2022-05-10 04:20:50 | Afghanistan | ||||
228678 | 228678 | 2020-04-30 | Afghanistan | 1827 | 60 | 260 | 1507 | 33.93911 | 67.709953 | 2020-05-01 02:32:28 | Afghanistan | |||
228897 | 228897 | 2022-05-31 | Afghanistan | 180347 | 7705 | 0 | 33.93911 | 67.709953 | 2022-06-01 04:20:55 | Afghanistan | ||||
232913 | 232913 | 2022-02-11 | Afghanistan | 169940 | 7478 | 0 | 33.93911 | 67.709953 | 2022-02-12 04:21:06 | Afghanistan | ||||
236929 | 236929 | 2021-01-18 | Afghanistan | 54062 | 2343 | 46359 | 5360 | 33.93911 | 67.709953 | 2021-01-19 05:22:15 | Afghanistan | |||
240942 | 240942 | 2021-04-02 | Afghanistan | 56572 | 2495 | 51798 | 2279 | 33.93911 | 67.709953 | 2021-04-03 04:20:44 | Afghanistan | |||
244956 | 244956 | 2021-08-17 | Afghanistan | 152243 | 7031 | 0 | 33.93911 | 67.709953 | 2021-08-18 04:21:35 | Afghanistan | ||||
248970 | 248970 | 2021-09-04 | Afghanistan | 153395 | 7128 | 0 | 33.93911 | 67.709953 | 2021-09-05 04:21:33 | Afghanistan | ||||
252984 | 252984 | 2022-09-08 | Afghanistan | 195298 | 7786 | 0 | 33.93911 | 67.709953 | 2022-09-09 04:21:11 | Afghanistan | ||||
257000 | 257000 | 2022-12-10 | Afghanistan | 206543 | 7839 | 0 | 33.93911 | 67.709953 | 2022-12-11 04:20:50 | Afghanistan | ||||
261120 | 261120 | 2020-03-03 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
261203 | 261203 | 2022-03-15 | Afghanistan | 176571 | 7646 | 0 | 33.93911 | 67.709953 | 2022-03-16 04:20:50 | Afghanistan | ||||
268439 | 268439 | 2020-05-21 | Afghanistan | 8676 | 193 | 938 | 7545 | 33.93911 | 67.709953 | 2020-05-22 02:36:51 | Afghanistan | |||
271639 | 271639 | 2020-04-28 | Afghanistan | 1703 | 60 | 228 | 1415 | 33.93911 | 67.709953 | 2020-04-29 02:32:29 | Afghanistan | |||
271856 | 271856 | 2020-11-10 | Afghanistan | 42297 | 1574 | 34954 | 5769 | 33.93911 | 67.709953 | 2020-11-11 05:25:30 | Afghanistan | |||
275854 | 275854 | 2021-11-03 | Afghanistan | 156323 | 7284 | 0 | 33.93911 | 67.709953 | 2021-11-04 04:22:20 | Afghanistan | ||||
279870 | 279870 | 2021-02-24 | Afghanistan | 55664 | 2436 | 49086 | 4142 | 33.93911 | 67.709953 | 2021-02-25 05:24:57 | Afghanistan | |||
287464 | 287464 | 2020-06-15 | Afghanistan | 25613 | 480 | 5164 | 19969 | 33.93911 | 67.709953 | 2020-06-16 04:33:09 | Afghanistan | |||
287667 | 287667 | 2021-10-31 | Afghanistan | 156250 | 7280 | 0 | 33.93911 | 67.709953 | 2021-11-01 04:22:01 | Afghanistan | ||||
291683 | 291683 | 2022-11-15 | Afghanistan | 204724 | 7829 | 0 | 33.93911 | 67.709953 | 2022-11-16 04:21:09 | Afghanistan | ||||
295699 | 295699 | 2021-07-15 | Afghanistan | 137853 | 5983 | 82586 | 49284 | 33.93911 | 67.709953 | 2021-07-16 04:21:22 | Afghanistan | |||
303336 | 303336 | 2020-07-01 | Afghanistan | 31848 | 778 | 15651 | 15419 | 33.93911 | 67.709953 | 2020-07-02 04:33:46 | Afghanistan | |||
303539 | 303539 | 2022-04-16 | Afghanistan | 178387 | 7676 | 0 | 33.93911 | 67.709953 | 2022-04-17 04:20:59 | Afghanistan | ||||
307555 | 307555 | 2022-12-13 | Afghanistan | 206743 | 7843 | 0 | 33.93911 | 67.709953 | 2022-12-14 04:21:04 | Afghanistan | ||||
311571 | 311571 | 2022-11-13 | Afghanistan | 204510 | 7829 | 0 | 33.93911 | 67.709953 | 2022-11-14 04:21:09 | Afghanistan | ||||
315587 | 315587 | 2022-02-12 | Afghanistan | 170152 | 7488 | 0 | 33.93911 | 67.709953 | 2022-02-13 04:21:00 | Afghanistan | ||||
319603 | 319603 | 2022-10-30 | Afghanistan | 202966 | 7821 | 0 | 33.93911 | 67.709953 | 2022-10-31 04:21:36 | Afghanistan | ||||
327280 | 327280 | 2020-07-20 | Afghanistan | 35595 | 1187 | 23741 | 10667 | 33.93911 | 67.709953 | 2020-07-21 04:38:46 | Afghanistan | |||
327577 | 327577 | 2022-12-27 | Afghanistan | 207460 | 7846 | 0 | 33.93911 | 67.709953 | 2022-12-28 04:21:04 | Afghanistan | ||||
331593 | 331593 | 2021-08-04 | Afghanistan | 148933 | 6836 | 82586 | 59511 | 33.93911 | 67.709953 | 2021-08-05 04:21:51 | Afghanistan | |||
335607 | 335607 | 2022-03-18 | Afghanistan | 176983 | 7651 | 0 | 33.93911 | 67.709953 | 2022-03-19 04:20:47 | Afghanistan | ||||
339811 | 339811 | 2020-03-21 | Afghanistan | 24 | 0 | 1 | 33.9391 | 67.71 | 2020-03-20T14:43:04 | |||||
339963 | 339963 | 2021-02-03 | Afghanistan | 55174 | 2406 | 47982 | 4786 | 33.93911 | 67.709953 | 2021-02-04 05:22:26 | Afghanistan | |||
343977 | 343977 | 2020-09-14 | Afghanistan | 38858 | 1429 | 32073 | 5356 | 33.93911 | 67.709953 | 2020-09-15 03:22:50 | Afghanistan | |||
347967 | 347967 | 2022-12-14 | Afghanistan | 206788 | 7843 | 0 | 33.93911 | 67.709953 | 2022-12-15 04:20:58 | Afghanistan | ||||
351983 | 351983 | 2021-03-11 | Afghanistan | 55917 | 2451 | 49499 | 3967 | 33.93911 | 67.709953 | 2021-03-12 05:26:50 | Afghanistan | |||
355997 | 355997 | 2022-03-11 | Afghanistan | 175974 | 7640 | 0 | 33.93911 | 67.709953 | 2022-03-12 04:20:50 | Afghanistan | ||||
360013 | 360013 | 2022-05-07 | Afghanistan | 178922 | 7684 | 0 | 33.93911 | 67.709953 | 2022-05-08 04:20:49 | Afghanistan | ||||
367684 | 367684 | 2020-07-16 | Afghanistan | 35156 | 1117 | 22824 | 11215 | 33.93911 | 67.709953 | 2020-07-17 04:34:50 | Afghanistan | |||
371659 | 371659 | 2020-08-08 | Afghanistan | 37101 | 1311 | 25960 | 9830 | 33.93911 | 67.709953 | 2020-08-09 04:34:54 | Afghanistan | |||
371867 | 371867 | 2022-09-13 | Afghanistan | 196404 | 7791 | 0 | 33.93911 | 67.709953 | 2022-09-14 04:20:44 | Afghanistan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);