johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
305 rows where confirmed = 2342 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219893 | 219893 | 2022-12-26 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-27 04:21:07 | Hickory, Missouri, US | |
3224350 | 3224350 | 2022-12-25 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-26 04:21:06 | Hickory, Missouri, US | |
1020264 | 1020264 | 2022-12-24 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-25 04:21:04 | Hickory, Missouri, US | |
692287 | 692287 | 2022-12-23 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-24 04:21:02 | Hickory, Missouri, US | |
2181497 | 2181497 | 2022-12-22 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-23 04:21:04 | Hickory, Missouri, US | |
453301 | 453301 | 2022-12-21 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-22 04:20:56 | Hickory, Missouri, US | |
2953300 | 2953300 | 2022-12-20 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-21 04:21:03 | Hickory, Missouri, US | |
1150602 | 1150602 | 2022-12-12 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-13 04:21:01 | Lake, Michigan, US | |
870456 | 870456 | 2022-12-11 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-12 04:21:01 | Lake, Michigan, US | |
258986 | 258986 | 2022-12-10 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-11 04:20:50 | Lake, Michigan, US | |
3937700 | 3937700 | 2022-12-09 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-10 04:21:02 | Lake, Michigan, US | |
3379032 | 3379032 | 2022-12-08 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-09 04:21:05 | Lake, Michigan, US | |
1986303 | 1986303 | 2022-12-07 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-08 04:21:07 | Lake, Michigan, US | |
3715826 | 3715826 | 2022-12-06 | US | Michigan | Lake | 26085 | 2342 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-07 04:20:58 | Lake, Michigan, US | |
3277919 | 3277919 | 2022-10-23 | US | Illinois | Schuyler | 17169 | 2342 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-24 04:22:29 | Schuyler, Illinois, US | |
2268957 | 2268957 | 2022-10-22 | US | Illinois | Schuyler | 17169 | 2342 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-23 04:22:46 | Schuyler, Illinois, US | |
1593257 | 1593257 | 2022-10-21 | US | Illinois | Schuyler | 17169 | 2342 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-22 04:22:53 | Schuyler, Illinois, US | |
2272973 | 2272973 | 2022-10-20 | US | Illinois | Schuyler | 17169 | 2342 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-21 04:22:23 | Schuyler, Illinois, US | |
2271712 | 2271712 | 2022-10-20 | China | Guangxi | 2342 | 2 | 0 | 23.8298 | 108.7881 | 2022-10-21 04:22:23 | Guangxi, China | |||
2017166 | 2017166 | 2022-09-20 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-21 04:23:22 | Southeast Fairbanks, Alaska, US | |
3571039 | 3571039 | 2022-09-19 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-20 04:22:48 | Southeast Fairbanks, Alaska, US | |
419778 | 419778 | 2022-09-18 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-19 04:21:49 | Southeast Fairbanks, Alaska, US | |
419150 | 419150 | 2022-09-18 | China | Yunnan | 2342 | 2 | 0 | 24.974 | 101.487 | 2022-09-19 04:21:49 | Yunnan, China | |||
3373802 | 3373802 | 2022-09-17 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-18 04:22:50 | Southeast Fairbanks, Alaska, US | |
2355910 | 2355910 | 2022-09-16 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-17 04:20:19 | Southeast Fairbanks, Alaska, US | |
3987067 | 3987067 | 2022-09-15 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-16 04:21:19 | Southeast Fairbanks, Alaska, US | |
1889781 | 1889781 | 2022-09-14 | US | Colorado | Lincoln | 8073 | 2342 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-15 04:21:02 | Lincoln, Colorado, US | |
1889584 | 1889584 | 2022-09-14 | US | Alaska | Southeast Fairbanks | 2240 | 2342 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-15 04:21:02 | Southeast Fairbanks, Alaska, US | |
372836 | 372836 | 2022-09-13 | US | Colorado | Lincoln | 8073 | 2342 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-14 04:20:44 | Lincoln, Colorado, US | |
2395438 | 2395438 | 2022-09-12 | US | Colorado | Lincoln | 8073 | 2342 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-13 04:20:57 | Lincoln, Colorado, US | |
3766516 | 3766516 | 2022-09-11 | US | Colorado | Lincoln | 8073 | 2342 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-12 04:20:58 | Lincoln, Colorado, US | |
3825091 | 3825091 | 2022-09-10 | US | Colorado | Lincoln | 8073 | 2342 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-11 04:20:50 | Lincoln, Colorado, US | |
963548 | 963548 | 2022-09-09 | US | Colorado | Lincoln | 8073 | 2342 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-10 04:21:10 | Lincoln, Colorado, US | |
3797710 | 3797710 | 2022-08-20 | China | Jiangsu | 2342 | 0 | 0 | 32.9711 | 119.455 | 2022-08-21 04:20:44 | Jiangsu, China | |||
2363296 | 2363296 | 2022-08-19 | China | Jiangsu | 2342 | 0 | 0 | 32.9711 | 119.455 | 2022-08-20 04:21:01 | Jiangsu, China | |||
1407716 | 1407716 | 2022-08-02 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-08-03 04:20:59 | Forest, Pennsylvania, US | |
3619754 | 3619754 | 2022-08-01 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-08-02 04:20:53 | Forest, Pennsylvania, US | |
3874234 | 3874234 | 2022-07-31 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-08-01 04:21:03 | Forest, Pennsylvania, US | |
676988 | 676988 | 2022-07-30 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-07-31 04:21:02 | Forest, Pennsylvania, US | |
1786187 | 1786187 | 2022-07-29 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-07-30 04:20:42 | Forest, Pennsylvania, US | |
1068550 | 1068550 | 2022-07-28 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-07-29 04:20:45 | Forest, Pennsylvania, US | |
2338069 | 2338069 | 2022-07-27 | US | Pennsylvania | Forest | 42053 | 2342 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-07-28 04:20:56 | Forest, Pennsylvania, US | |
1611781 | 1611781 | 2022-07-20 | US | West Virginia | Tyler | 54095 | 2342 | 32 | 0 | 39.46811972 | -80.88772676 | 2022-07-21 04:21:10 | Tyler, West Virginia, US | |
3213261 | 3213261 | 2022-07-18 | US | Tennessee | Moore | 47127 | 2342 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-07-19 04:20:58 | Moore, Tennessee, US | |
2421907 | 2421907 | 2022-07-15 | US | Texas | Archer | 48009 | 2342 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-07-16 04:21:05 | Archer, Texas, US | |
3112870 | 3112870 | 2022-07-13 | US | Virginia | Northumberland | 51133 | 2342 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-07-14 04:20:57 | Northumberland, Virginia, US | |
633293 | 633293 | 2022-07-12 | US | Virginia | Northumberland | 51133 | 2342 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-07-13 04:20:58 | Northumberland, Virginia, US | |
631087 | 631087 | 2022-07-12 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-13 04:20:58 | Clarke, Iowa, US | |
1212731 | 1212731 | 2022-07-11 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-12 04:20:51 | Clarke, Iowa, US | |
2790213 | 2790213 | 2022-07-10 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-11 04:20:46 | Clarke, Iowa, US | |
143166 | 143166 | 2022-07-09 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-10 04:20:54 | Clarke, Iowa, US | |
1418266 | 1418266 | 2022-07-08 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-09 04:20:59 | Clarke, Iowa, US | |
2742191 | 2742191 | 2022-07-07 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-08 04:20:56 | Clarke, Iowa, US | |
1200986 | 1200986 | 2022-07-06 | US | Iowa | Clarke | 19039 | 2342 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-07 04:20:55 | Clarke, Iowa, US | |
3081445 | 3081445 | 2022-07-04 | US | Virginia | Northampton | 51131 | 2342 | 66 | 0 | 37.34062933 | -75.87751591 | 2022-07-05 04:20:45 | Northampton, Virginia, US | |
2191136 | 2191136 | 2022-06-22 | US | West Virginia | Webster | 54101 | 2342 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-06-23 04:20:55 | Webster, West Virginia, US | |
2188139 | 2188139 | 2022-06-22 | US | Arkansas | Scott | 5127 | 2342 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-06-23 04:20:55 | Scott, Arkansas, US | |
3160970 | 3160970 | 2022-06-09 | US | Virginia | Essex | 51057 | 2342 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-06-10 04:20:55 | Essex, Virginia, US | |
3729551 | 3729551 | 2022-06-07 | US | Virginia | Essex | 51057 | 2342 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-06-08 04:20:55 | Essex, Virginia, US | |
3727152 | 3727152 | 2022-06-07 | US | Idaho | Clearwater | 16035 | 2342 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-08 04:20:55 | Clearwater, Idaho, US | |
3888554 | 3888554 | 2022-06-06 | US | Idaho | Clearwater | 16035 | 2342 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-07 04:21:08 | Clearwater, Idaho, US | |
1506583 | 1506583 | 2022-05-16 | US | Tennessee | Perry | 47135 | 2342 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-05-17 04:20:59 | Perry, Tennessee, US | |
2086942 | 2086942 | 2022-05-15 | US | Tennessee | Perry | 47135 | 2342 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-05-16 04:20:47 | Perry, Tennessee, US | |
3357652 | 3357652 | 2022-05-14 | US | Tennessee | Perry | 47135 | 2342 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-05-15 04:20:53 | Perry, Tennessee, US | |
1699075 | 1699075 | 2022-04-28 | US | Puerto Rico | Florida | 72054 | 2342 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-29 04:20:59 | Florida, Puerto Rico, US | |
1951295 | 1951295 | 2022-04-12 | US | Puerto Rico | Santa Isabel | 72133 | 2342 | 0 | 0 | 17.994525 | -66.388913 | 2022-04-13 04:21:03 | Santa Isabel, Puerto Rico, US | |
1579544 | 1579544 | 2022-04-10 | US | Virginia | Poquoson | 51735 | 2342 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-04-11 04:21:02 | Poquoson, Virginia, US | |
1655786 | 1655786 | 2022-04-09 | US | Virginia | Poquoson | 51735 | 2342 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-04-10 04:20:52 | Poquoson, Virginia, US | |
2119108 | 2119108 | 2022-04-08 | US | Virginia | Poquoson | 51735 | 2342 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-04-09 04:20:42 | Poquoson, Virginia, US | |
2804168 | 2804168 | 2022-04-06 | US | Virginia | Poquoson | 51735 | 2342 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-04-07 04:20:53 | Poquoson, Virginia, US | |
1542691 | 1542691 | 2022-03-31 | US | Puerto Rico | Ciales | 72039 | 2342 | 0 | 0 | 18.28885 | -66.516475 | 2022-04-01 04:20:28 | Ciales, Puerto Rico, US | |
3241523 | 3241523 | 2022-03-21 | US | Texas | Parmer | 48369 | 2342 | 52 | 0 | 34.52993409 | -102.78446679999999 | 2022-03-22 04:20:54 | Parmer, Texas, US | |
27596 | 27596 | 2022-03-20 | US | Texas | Parmer | 48369 | 2342 | 52 | 0 | 34.52993409 | -102.78446679999999 | 2022-03-21 04:20:50 | Parmer, Texas, US | |
1659606 | 1659606 | 2022-03-19 | US | Texas | Parmer | 48369 | 2342 | 52 | 0 | 34.52993409 | -102.78446679999999 | 2022-03-20 04:20:45 | Parmer, Texas, US | |
339132 | 339132 | 2022-03-18 | US | Texas | Parmer | 48369 | 2342 | 52 | 0 | 34.52993409 | -102.78446679999999 | 2022-03-19 04:20:47 | Parmer, Texas, US | |
262333 | 262333 | 2022-03-15 | US | Georgia | Evans | 13109 | 2342 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-03-16 04:20:50 | Evans, Georgia, US | |
3672891 | 3672891 | 2022-02-15 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-16 04:21:10 | Sac, Iowa, US | |
2642992 | 2642992 | 2022-02-14 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-15 04:21:09 | Sac, Iowa, US | |
187309 | 187309 | 2022-02-13 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-14 04:20:51 | Sac, Iowa, US | |
317155 | 317155 | 2022-02-12 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-13 04:21:00 | Sac, Iowa, US | |
234481 | 234481 | 2022-02-11 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-12 04:21:06 | Sac, Iowa, US | |
1465323 | 1465323 | 2022-02-10 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-11 04:21:09 | Sac, Iowa, US | |
3075284 | 3075284 | 2022-02-09 | US | Iowa | Sac | 19161 | 2342 | 31 | 0 | 42.38624071 | -95.10547892 | 2022-02-10 04:21:14 | Sac, Iowa, US | |
1363763 | 1363763 | 2022-02-08 | US | Kentucky | Hancock | 21091 | 2342 | 20 | 0 | 37.83766422 | -86.78280584 | 2022-02-09 04:21:04 | Hancock, Kentucky, US | |
2477372 | 2477372 | 2022-02-03 | US | Virginia | Sussex | 51183 | 2342 | 32 | 0 | 36.92432914 | -77.25791182 | 2022-02-04 04:21:10 | Sussex, Virginia, US | |
3813447 | 3813447 | 2022-01-28 | US | West Virginia | Summers | 54089 | 2342 | 43 | 0 | 37.65390597 | -80.86009693 | 2022-01-29 04:21:10 | Summers, West Virginia, US | |
1781118 | 1781118 | 2022-01-27 | US | Minnesota | Koochiching | 27071 | 2342 | 34 | 0 | 48.24539665 | -93.78352843 | 2022-01-28 04:21:09 | Koochiching, Minnesota, US | |
1142228 | 1142228 | 2022-01-23 | US | Kansas | Marshall | 20117 | 2342 | 38 | 0 | 39.78359669 | -96.52278974 | 2022-01-24 04:21:12 | Marshall, Kansas, US | |
2834146 | 2834146 | 2022-01-22 | US | Kansas | Marshall | 20117 | 2342 | 38 | 0 | 39.78359669 | -96.52278974 | 2022-01-23 04:21:13 | Marshall, Kansas, US | |
3426264 | 3426264 | 2022-01-21 | US | Kansas | Marshall | 20117 | 2342 | 38 | 0 | 39.78359669 | -96.52278974 | 2022-01-22 04:21:13 | Marshall, Kansas, US | |
3425335 | 3425335 | 2022-01-21 | US | Alabama | Lowndes | 1085 | 2342 | 68 | 0 | 32.1597283 | -86.65158371 | 2022-01-22 04:21:13 | Lowndes, Alabama, US | |
1115976 | 1115976 | 2022-01-11 | US | North Dakota | Barnes | 38003 | 2342 | 41 | 0 | 46.93579637 | -98.06605978 | 2022-01-12 04:21:44 | Barnes, North Dakota, US | |
3519238 | 3519238 | 2022-01-02 | China | Shaanxi | 2342 | 3 | 0 | 35.1917 | 108.8701 | 2022-01-03 02:22:25 | Shaanxi, China | |||
2167368 | 2167368 | 2022-01-01 | China | Shaanxi | 2342 | 3 | 0 | 35.1917 | 108.8701 | 2022-01-02 04:20:52 | Shaanxi, China | |||
733028 | 733028 | 2021-12-27 | US | Ohio | Noble | 39121 | 2342 | 51 | 0 | 39.76818851 | -81.45937183 | 2021-12-28 04:21:47 | Noble, Ohio, US | |
2113196 | 2113196 | 2021-12-26 | US | Louisiana | Caldwell | 22021 | 2342 | 42 | 0 | 32.0902519 | -92.11752148 | 2021-12-27 04:21:58 | Caldwell, Louisiana, US | |
3606568 | 3606568 | 2021-12-25 | US | Louisiana | Caldwell | 22021 | 2342 | 42 | 0 | 32.0902519 | -92.11752148 | 2021-12-26 04:21:50 | Caldwell, Louisiana, US | |
2964886 | 2964886 | 2021-12-24 | US | Louisiana | Caldwell | 22021 | 2342 | 42 | 0 | 32.0902519 | -92.11752148 | 2021-12-25 04:21:37 | Caldwell, Louisiana, US | |
3817918 | 3817918 | 2021-12-23 | US | Louisiana | Caldwell | 22021 | 2342 | 42 | 0 | 32.0902519 | -92.11752148 | 2021-12-24 04:21:34 | Caldwell, Louisiana, US | |
801066 | 801066 | 2021-12-22 | US | Oregon | Tillamook | 41057 | 2342 | 48 | 0 | 45.46248721 | -123.712066 | 2021-12-23 04:21:21 | Tillamook, Oregon, 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]);