johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where confirmed = 2974 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1631265 | 1631265 | 2022-12-18 | US | Tennessee | Houston | 47083 | 2974 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-12-19 04:21:03 | Houston, Tennessee, US | |
506644 | 506644 | 2022-12-17 | US | Tennessee | Houston | 47083 | 2974 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-12-18 04:21:03 | Houston, Tennessee, US | |
3327216 | 3327216 | 2022-12-16 | US | Tennessee | Houston | 47083 | 2974 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-12-17 04:21:04 | Houston, Tennessee, US | |
2557930 | 2557930 | 2022-11-29 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-30 04:21:07 | Rice, Kansas, US | |
1241566 | 1241566 | 2022-11-28 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-29 04:21:05 | Douglas, Missouri, US | |
1241004 | 1241004 | 2022-11-28 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-29 04:21:05 | Rice, Kansas, US | |
3553554 | 3553554 | 2022-11-27 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-28 04:21:02 | Douglas, Missouri, US | |
3552992 | 3552992 | 2022-11-27 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-28 04:21:02 | Rice, Kansas, US | |
2102034 | 2102034 | 2022-11-26 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-27 04:21:05 | Douglas, Missouri, US | |
2101472 | 2101472 | 2022-11-26 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-27 04:21:05 | Rice, Kansas, US | |
489525 | 489525 | 2022-11-25 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-26 04:21:11 | Douglas, Missouri, US | |
488963 | 488963 | 2022-11-25 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-26 04:21:11 | Rice, Kansas, US | |
3525354 | 3525354 | 2022-11-24 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-25 04:21:06 | Douglas, Missouri, US | |
3524792 | 3524792 | 2022-11-24 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-25 04:21:06 | Rice, Kansas, US | |
3314137 | 3314137 | 2022-11-23 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-24 04:21:09 | Douglas, Missouri, US | |
3313575 | 3313575 | 2022-11-23 | US | Kansas | Rice | 20159 | 2974 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-11-24 04:21:09 | Rice, Kansas, US | |
1622178 | 1622178 | 2022-11-22 | US | Missouri | Douglas | 29067 | 2974 | 85 | 0 | 36.9325593 | -92.49905109 | 2022-11-23 04:21:06 | Douglas, Missouri, US | |
1758063 | 1758063 | 2022-11-18 | US | Puerto Rico | Maunabo | 72095 | 2974 | 0 | 0 | 18.017889 | -65.922235 | 2022-11-19 04:21:14 | Maunabo, Puerto Rico, US | |
3285575 | 3285575 | 2022-10-31 | US | Connecticut | Unassigned | 90009 | 2974 | 8 | 0 | 41.85853803 | 0.0 | 2022-11-01 04:22:36 | Unassigned, Connecticut, US | |
3251369 | 3251369 | 2022-10-11 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-12 04:22:51 | Lyon, Iowa, US | |
2968628 | 2968628 | 2022-10-10 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-11 04:23:05 | Lyon, Iowa, US | |
3098664 | 3098664 | 2022-10-09 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-10 04:22:32 | Lyon, Iowa, US | |
4003889 | 4003889 | 2022-10-08 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-09 04:21:16 | Lyon, Iowa, US | |
397486 | 397486 | 2022-10-07 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-08 04:22:56 | Lyon, Iowa, US | |
2530603 | 2530603 | 2022-10-06 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-07 04:23:08 | Lyon, Iowa, US | |
1811997 | 1811997 | 2022-10-05 | US | Iowa | Lyon | 19119 | 2974 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-06 04:21:22 | Lyon, Iowa, US | |
3767379 | 3767379 | 2022-09-11 | US | Louisiana | Catahoula | 22025 | 2974 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-09-12 04:20:58 | Catahoula, Louisiana, US | |
3825954 | 3825954 | 2022-09-10 | US | Louisiana | Catahoula | 22025 | 2974 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-09-11 04:20:50 | Catahoula, Louisiana, US | |
964411 | 964411 | 2022-09-09 | US | Louisiana | Catahoula | 22025 | 2974 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-09-10 04:21:10 | Catahoula, Louisiana, US | |
2343898 | 2343898 | 2022-08-31 | US | Arkansas | Chicot | 5017 | 2974 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-09-01 04:21:03 | Chicot, Arkansas, US | |
1100336 | 1100336 | 2022-08-03 | US | New Mexico | Torrance | 35057 | 2974 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-08-04 04:20:58 | Torrance, New Mexico, US | |
1407261 | 1407261 | 2022-08-02 | US | New Mexico | Torrance | 35057 | 2974 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-08-03 04:20:59 | Torrance, New Mexico, US | |
3619299 | 3619299 | 2022-08-01 | US | New Mexico | Torrance | 35057 | 2974 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-08-02 04:20:53 | Torrance, New Mexico, US | |
3213649 | 3213649 | 2022-07-18 | US | Virginia | Lexington | 51678 | 2974 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-07-19 04:20:58 | Lexington, Virginia, US | |
3432101 | 3432101 | 2022-07-14 | US | Texas | Jim Hogg | 48247 | 2974 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-07-15 04:20:53 | Jim Hogg, Texas, US | |
1213104 | 1213104 | 2022-07-11 | US | Louisiana | West Feliciana | 22125 | 2974 | 46 | 0 | 30.87882871 | -91.4148538 | 2022-07-12 04:20:51 | West Feliciana, Louisiana, US | |
3943575 | 3943575 | 2022-06-30 | US | West Virginia | Summers | 54089 | 2974 | 55 | 0 | 37.65390597 | -80.86009693 | 2022-07-01 04:21:10 | Summers, West Virginia, US | |
3940472 | 3940472 | 2022-06-30 | US | Alabama | Wilcox | 1131 | 2974 | 46 | 0 | 31.98773215 | -87.30891118 | 2022-07-01 04:21:10 | Wilcox, Alabama, US | |
3272555 | 3272555 | 2022-06-19 | US | Texas | Callahan | 48059 | 2974 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-06-20 04:21:01 | Callahan, Texas, US | |
3400467 | 3400467 | 2022-06-18 | US | Texas | Callahan | 48059 | 2974 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-06-19 04:20:51 | Callahan, Texas, US | |
3984773 | 3984773 | 2022-06-15 | US | New Hampshire | Unassigned | 90033 | 2974 | 6 | 0 | 44.69063265 | 0.0 | 2022-06-16 04:20:55 | Unassigned, New Hampshire, US | |
3896564 | 3896564 | 2022-05-19 | US | Colorado | Archuleta | 8007 | 2974 | 16 | 0 | 37.19474156 | -107.0476867 | 2022-05-20 04:20:57 | Archuleta, Colorado, US | |
3445206 | 3445206 | 2022-05-11 | US | Alabama | Coosa | 1037 | 2974 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-05-12 04:20:54 | Coosa, Alabama, US | |
3538367 | 3538367 | 2022-05-10 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-11 04:20:48 | Todd, South Dakota, US | |
3536714 | 3536714 | 2022-05-10 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-11 04:20:48 | Winnebago, Iowa, US | |
3535823 | 3535823 | 2022-05-10 | US | Alabama | Coosa | 1037 | 2974 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-05-11 04:20:48 | Coosa, Alabama, US | |
224902 | 224902 | 2022-05-09 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-10 04:20:50 | Todd, South Dakota, US | |
223249 | 223249 | 2022-05-09 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-10 04:20:50 | Winnebago, Iowa, US | |
2334287 | 2334287 | 2022-05-08 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-09 04:20:54 | Todd, South Dakota, US | |
2332634 | 2332634 | 2022-05-08 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-09 04:20:54 | Winnebago, Iowa, US | |
363249 | 363249 | 2022-05-07 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-08 04:20:49 | Todd, South Dakota, US | |
361596 | 361596 | 2022-05-07 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-08 04:20:49 | Winnebago, Iowa, US | |
1400600 | 1400600 | 2022-05-06 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-07 04:21:09 | Todd, South Dakota, US | |
1398947 | 1398947 | 2022-05-06 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-07 04:21:09 | Winnebago, Iowa, US | |
2600955 | 2600955 | 2022-05-05 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-06 04:21:00 | Todd, South Dakota, US | |
2599302 | 2599302 | 2022-05-05 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-06 04:21:00 | Winnebago, Iowa, US | |
3268404 | 3268404 | 2022-05-04 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-05 04:20:55 | Todd, South Dakota, US | |
3266751 | 3266751 | 2022-05-04 | US | Iowa | Winnebago | 19189 | 2974 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-05-05 04:20:55 | Winnebago, Iowa, US | |
1575043 | 1575043 | 2022-05-03 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-04 04:20:59 | Todd, South Dakota, US | |
466303 | 466303 | 2022-05-02 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-03 04:21:00 | Todd, South Dakota, US | |
3918942 | 3918942 | 2022-05-01 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-02 04:21:10 | Todd, South Dakota, US | |
2843746 | 2843746 | 2022-04-30 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-01 04:20:57 | Todd, South Dakota, US | |
1160059 | 1160059 | 2022-04-29 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-04-30 04:21:05 | Todd, South Dakota, US | |
1699241 | 1699241 | 2022-04-28 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-04-29 04:20:59 | Todd, South Dakota, US | |
3854724 | 3854724 | 2022-04-27 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-04-28 04:20:47 | Todd, South Dakota, US | |
1329154 | 1329154 | 2022-04-26 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-27 04:20:52 | Todd, South Dakota, US | |
3725108 | 3725108 | 2022-04-25 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-26 04:20:51 | Todd, South Dakota, US | |
2031676 | 2031676 | 2022-04-24 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-25 04:20:56 | Todd, South Dakota, US | |
749251 | 749251 | 2022-04-23 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-24 04:20:56 | Todd, South Dakota, US | |
3439736 | 3439736 | 2022-04-22 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-23 04:20:50 | Todd, South Dakota, US | |
2895321 | 2895321 | 2022-04-21 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-22 04:20:45 | Todd, South Dakota, US | |
2894801 | 2894801 | 2022-04-21 | US | North Dakota | Barnes | 38003 | 2974 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-04-22 04:20:45 | Barnes, North Dakota, US | |
2310193 | 2310193 | 2022-04-20 | US | South Dakota | Todd | 46121 | 2974 | 53 | 0 | 43.19338568 | -100.71955030000001 | 2022-04-21 04:20:46 | Todd, South Dakota, US | |
2479751 | 2479751 | 2022-03-30 | US | Minnesota | Watonwan | 27165 | 2974 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-03-31 04:20:56 | Watonwan, Minnesota, US | |
3629903 | 3629903 | 2022-03-13 | US | Missouri | Pemiscot | 29155 | 2974 | 73 | 0 | 36.2130572 | -89.78742322 | 2022-03-14 04:20:46 | Pemiscot, Missouri, US | |
952811 | 952811 | 2022-03-12 | US | Missouri | Pemiscot | 29155 | 2974 | 73 | 0 | 36.2130572 | -89.78742322 | 2022-03-13 04:20:49 | Pemiscot, Missouri, US | |
358272 | 358272 | 2022-03-11 | US | Missouri | Pemiscot | 29155 | 2974 | 73 | 0 | 36.2130572 | -89.78742322 | 2022-03-12 04:20:50 | Pemiscot, Missouri, US | |
1867235 | 1867235 | 2022-03-10 | US | Minnesota | Pope | 27121 | 2974 | 17 | 0 | 45.58606667 | -95.44451209 | 2022-03-11 04:20:50 | Pope, Minnesota, US | |
2665834 | 2665834 | 2022-03-04 | Kiribati | 2974 | 11 | 0 | -3.3704 | -168.734 | 2022-03-05 04:21:10 | Kiribati | ||||
2733492 | 2733492 | 2022-02-27 | US | Arkansas | Bradley | 5011 | 2974 | 45 | 0 | 33.46755808 | -92.15980837 | 2022-02-28 04:21:05 | Bradley, Arkansas, US | |
1464781 | 1464781 | 2022-02-10 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-11 04:21:09 | Franklin, Florida, US | |
3074742 | 3074742 | 2022-02-09 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-10 04:21:14 | Franklin, Florida, US | |
1363049 | 1363049 | 2022-02-08 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-09 04:21:04 | Franklin, Florida, US | |
71787 | 71787 | 2022-02-07 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-08 04:21:15 | Franklin, Florida, US | |
2013837 | 2013837 | 2022-02-06 | US | Indiana | Pulaski | 18131 | 2974 | 79 | 0 | 41.04166107 | -86.69890683 | 2022-02-07 04:21:05 | Pulaski, Indiana, US | |
2013403 | 2013403 | 2022-02-06 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-07 04:21:05 | Franklin, Florida, US | |
1295166 | 1295166 | 2022-02-05 | US | Indiana | Pulaski | 18131 | 2974 | 79 | 0 | 41.04166107 | -86.69890683 | 2022-02-06 04:21:00 | Pulaski, Indiana, US | |
1294732 | 1294732 | 2022-02-05 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-06 04:21:00 | Franklin, Florida, US | |
2328494 | 2328494 | 2022-02-04 | US | Indiana | Pulaski | 18131 | 2974 | 79 | 0 | 41.04166107 | -86.69890683 | 2022-02-05 04:21:05 | Pulaski, Indiana, US | |
2328060 | 2328060 | 2022-02-04 | US | Florida | Franklin | 12037 | 2974 | 46 | 0 | 29.83791238 | -84.82731662 | 2022-02-05 04:21:05 | Franklin, Florida, US | |
462644 | 462644 | 2022-02-02 | US | Texas | Zapata | 48505 | 2974 | 47 | 0 | 27.00156391 | -99.16987152 | 2022-02-03 04:21:21 | Zapata, Texas, US | |
2658860 | 2658860 | 2022-01-31 | US | Indiana | Blackford | 18009 | 2974 | 59 | 0 | 40.47388153 | -85.32499702 | 2022-02-01 04:21:11 | Blackford, Indiana, US | |
3062562 | 3062562 | 2022-01-29 | US | California | Mono | 6051 | 2974 | 5 | 0 | 37.93899289 | -118.8872409 | 2022-01-30 04:21:26 | Mono, California, US | |
1143386 | 1143386 | 2022-01-23 | US | Ohio | Harrison | 39067 | 2974 | 69 | 0 | 40.29380509 | -81.09068544 | 2022-01-24 04:21:12 | Harrison, Ohio, US | |
1961995 | 1961995 | 2022-01-20 | US | Kentucky | Magoffin | 21153 | 2974 | 36 | 0 | 37.70820545 | -83.0657714 | 2022-01-21 04:21:09 | Magoffin, Kentucky, US | |
3616538 | 3616538 | 2022-01-12 | US | West Virginia | Braxton | 54007 | 2974 | 32 | 0 | 38.70036159 | -80.72011184 | 2022-01-13 08:00:09 | Braxton, West Virginia, US | |
129745 | 129745 | 2022-01-09 | US | Texas | Andrews | 48003 | 2974 | 67 | 0 | 32.30468633 | -102.63765479999999 | 2022-01-10 04:22:07 | Andrews, Texas, US | |
1703852 | 1703852 | 2022-01-03 | US | West Virginia | Morgan | 54065 | 2974 | 53 | 0 | 39.55439028 | -78.26311676 | 2022-01-04 04:22:17 | Morgan, West Virginia, US | |
1435488 | 1435488 | 2021-12-28 | US | Tennessee | Cannon | 47015 | 2974 | 50 | 0 | 35.80990797 | -86.05738983 | 2021-12-29 03:21:43 | Cannon, Tennessee, US | |
801553 | 801553 | 2021-12-22 | US | Texas | Houston | 48225 | 2974 | 89 | 0 | 31.31925973 | -95.42226208 | 2021-12-23 04:21:21 | Houston, Texas, US |
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]);