johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
281 rows where confirmed = 2530 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329170 | 329170 | 2022-12-27 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-28 04:21:04 | Anderson, Kansas, US | |
219243 | 219243 | 2022-12-26 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-27 04:21:07 | Anderson, Kansas, US | |
3223700 | 3223700 | 2022-12-25 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-26 04:21:06 | Anderson, Kansas, US | |
1019614 | 1019614 | 2022-12-24 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-25 04:21:04 | Anderson, Kansas, US | |
691637 | 691637 | 2022-12-23 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-24 04:21:02 | Anderson, Kansas, US | |
2180847 | 2180847 | 2022-12-22 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-23 04:21:04 | Anderson, Kansas, US | |
452651 | 452651 | 2022-12-21 | US | Kansas | Anderson | 20003 | 2530 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-12-22 04:20:56 | Anderson, Kansas, US | |
3596853 | 3596853 | 2022-11-14 | China | Tianjin | 2530 | 3 | 0 | 39.3054 | 117.323 | 2022-11-15 04:21:16 | Tianjin, China | |||
314920 | 314920 | 2022-11-13 | US | Texas | Archer | 48009 | 2530 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-11-14 04:21:09 | Archer, Texas, US | |
66081 | 66081 | 2022-11-12 | US | Texas | Archer | 48009 | 2530 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-11-13 04:21:14 | Archer, Texas, US | |
2930243 | 2930243 | 2022-11-11 | US | Texas | Archer | 48009 | 2530 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-11-12 04:20:41 | Archer, Texas, US | |
2509079 | 2509079 | 2022-11-10 | US | Texas | Archer | 48009 | 2530 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-11-11 04:21:22 | Archer, Texas, US | |
2433954 | 2433954 | 2022-11-09 | US | Texas | Archer | 48009 | 2530 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-11-10 04:21:16 | Archer, Texas, US | |
2028123 | 2028123 | 2022-10-17 | US | Virginia | Lexington | 51678 | 2530 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-18 04:22:42 | Lexington, Virginia, US | |
2162901 | 2162901 | 2022-10-16 | US | Virginia | Lexington | 51678 | 2530 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-17 04:20:31 | Lexington, Virginia, US | |
519098 | 519098 | 2022-10-15 | US | Virginia | Lexington | 51678 | 2530 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-16 04:22:39 | Lexington, Virginia, US | |
2036155 | 2036155 | 2022-10-14 | US | Virginia | Lexington | 51678 | 2530 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-15 04:22:00 | Lexington, Virginia, US | |
3756843 | 3756843 | 2022-10-13 | US | Virginia | Lexington | 51678 | 2530 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-14 04:22:28 | Lexington, Virginia, US | |
2970776 | 2970776 | 2022-10-10 | US | Virginia | Lexington | 51678 | 2530 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-11 04:23:05 | Lexington, Virginia, US | |
3098850 | 3098850 | 2022-10-09 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-10 04:22:32 | Gallatin, Kentucky, US | |
4004075 | 4004075 | 2022-10-08 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-09 04:21:16 | Gallatin, Kentucky, US | |
4002482 | 4002482 | 2022-10-08 | China | Yunnan | 2530 | 2 | 0 | 24.974 | 101.487 | 2022-10-09 04:21:16 | Yunnan, China | |||
397672 | 397672 | 2022-10-07 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-08 04:22:56 | Gallatin, Kentucky, US | |
2530789 | 2530789 | 2022-10-06 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-07 04:23:08 | Gallatin, Kentucky, US | |
1812183 | 1812183 | 2022-10-05 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-06 04:21:22 | Gallatin, Kentucky, US | |
132157 | 132157 | 2022-10-04 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-05 04:23:06 | Gallatin, Kentucky, US | |
2687104 | 2687104 | 2022-10-03 | US | Kentucky | Gallatin | 21077 | 2530 | 55 | 0 | 38.75398691 | -84.8558382 | 2022-10-04 04:22:55 | Gallatin, Kentucky, US | |
3373875 | 3373875 | 2022-09-17 | US | Arkansas | Nevada | 5099 | 2530 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-09-18 04:22:50 | Nevada, Arkansas, US | |
3990146 | 3990146 | 2022-09-15 | US | West Virginia | Tyler | 54095 | 2530 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-09-16 04:21:19 | Tyler, West Virginia, US | |
3550840 | 3550840 | 2022-09-01 | US | Virginia | Essex | 51057 | 2530 | 36 | 0 | 37.93357639 | -76.94230311 | 2022-09-02 04:21:07 | Essex, Virginia, US | |
3550485 | 3550485 | 2022-09-01 | US | Tennessee | Moore | 47127 | 2530 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-09-02 04:21:07 | Moore, Tennessee, US | |
2326499 | 2326499 | 2022-08-24 | US | Texas | La Salle | 48283 | 2530 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-08-25 04:21:13 | La Salle, Texas, US | |
3651062 | 3651062 | 2022-08-14 | US | West Virginia | Clay | 54015 | 2530 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-15 04:20:59 | Clay, West Virginia, US | |
3648545 | 3648545 | 2022-08-14 | US | Idaho | Washington | 16087 | 2530 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-08-15 04:20:59 | Washington, Idaho, US | |
1972068 | 1972068 | 2022-08-13 | US | West Virginia | Clay | 54015 | 2530 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-14 04:20:55 | Clay, West Virginia, US | |
1969551 | 1969551 | 2022-08-13 | US | Idaho | Washington | 16087 | 2530 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-08-14 04:20:55 | Washington, Idaho, US | |
2891877 | 2891877 | 2022-08-12 | US | West Virginia | Clay | 54015 | 2530 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-13 04:20:52 | Clay, West Virginia, US | |
2889360 | 2889360 | 2022-08-12 | US | Idaho | Washington | 16087 | 2530 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-08-13 04:20:52 | Washington, Idaho, US | |
630875 | 630875 | 2022-07-12 | US | Illinois | Brown | 17009 | 2530 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-13 04:20:58 | Brown, Illinois, US | |
1212519 | 1212519 | 2022-07-11 | US | Illinois | Brown | 17009 | 2530 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-12 04:20:51 | Brown, Illinois, US | |
2238755 | 2238755 | 2022-06-12 | US | Virginia | Madison | 51113 | 2530 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-13 04:21:14 | Madison, Virginia, US | |
3144953 | 3144953 | 2022-06-11 | US | Virginia | Madison | 51113 | 2530 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-12 04:20:53 | Madison, Virginia, US | |
1947869 | 1947869 | 2022-06-10 | US | Virginia | Madison | 51113 | 2530 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-11 04:21:01 | Madison, Virginia, US | |
3727442 | 3727442 | 2022-06-07 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-08 04:20:55 | Mitchell, Iowa, US | |
3888844 | 3888844 | 2022-06-06 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-07 04:21:08 | Mitchell, Iowa, US | |
3508613 | 3508613 | 2022-06-05 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-06 04:20:57 | Mitchell, Iowa, US | |
3528690 | 3528690 | 2022-06-04 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-05 04:20:55 | Mitchell, Iowa, US | |
3134776 | 3134776 | 2022-06-03 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-04 04:20:58 | Mitchell, Iowa, US | |
3580539 | 3580539 | 2022-06-02 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-06-03 04:20:58 | Howard, Missouri, US | |
3579851 | 3579851 | 2022-06-02 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-03 04:20:58 | Mitchell, Iowa, US | |
3579696 | 3579696 | 2022-06-02 | US | Indiana | Benton | 18007 | 2530 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-06-03 04:20:58 | Benton, Indiana, US | |
972832 | 972832 | 2022-06-01 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-06-02 05:20:39 | Howard, Missouri, US | |
972144 | 972144 | 2022-06-01 | US | Iowa | Mitchell | 19131 | 2530 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-06-02 05:20:39 | Mitchell, Iowa, US | |
971989 | 971989 | 2022-06-01 | US | Indiana | Benton | 18007 | 2530 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-06-02 05:20:39 | Benton, Indiana, US | |
231139 | 231139 | 2022-05-31 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-06-01 04:20:55 | Howard, Missouri, US | |
3187904 | 3187904 | 2022-05-30 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-05-31 04:20:51 | Howard, Missouri, US | |
3200053 | 3200053 | 2022-05-29 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-05-30 04:20:50 | Howard, Missouri, US | |
2726931 | 2726931 | 2022-05-28 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-05-29 04:20:53 | Howard, Missouri, US | |
1316112 | 1316112 | 2022-05-27 | US | Missouri | Howard | 29089 | 2530 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-05-28 04:21:07 | Howard, Missouri, US | |
1172382 | 1172382 | 2022-05-20 | US | Texas | Morris | 48343 | 2530 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-05-21 04:20:58 | Morris, Texas, US | |
3899145 | 3899145 | 2022-05-19 | US | Texas | Morris | 48343 | 2530 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-05-20 04:20:57 | Morris, Texas, US | |
1847453 | 1847453 | 2022-04-18 | US | Kentucky | Unassigned | 90021 | 2530 | 0 | 0 | 38.97065142 | 0.0 | 2022-04-19 04:21:00 | Unassigned, Kentucky, US | |
3208050 | 3208050 | 2022-04-11 | US | Minnesota | Yellow Medicine | 27173 | 2530 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-04-12 04:20:49 | Yellow Medicine, Minnesota, US | |
694730 | 694730 | 2022-03-17 | Tonga | 2530 | 2 | 0 | -21.179000000000002 | -175.1982 | 2022-03-18 04:20:55 | Tonga | ||||
263036 | 263036 | 2022-03-15 | US | Louisiana | East Carroll | 22035 | 2530 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-03-16 04:20:50 | East Carroll, Louisiana, US | |
2265395 | 2265395 | 2022-03-14 | US | Louisiana | East Carroll | 22035 | 2530 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-03-15 04:20:47 | East Carroll, Louisiana, US | |
2142099 | 2142099 | 2022-03-09 | US | Missouri | Linn | 29115 | 2530 | 62 | 0 | 39.87001769 | -93.10704106 | 2022-03-10 04:20:48 | Linn, Missouri, US | |
2200718 | 2200718 | 2022-03-06 | US | Indiana | Crawford | 18025 | 2530 | 35 | 0 | 38.28814402 | -86.44518825 | 2022-03-07 04:20:47 | Crawford, Indiana, US | |
2093175 | 2093175 | 2022-03-05 | US | Indiana | Crawford | 18025 | 2530 | 35 | 0 | 38.28814402 | -86.44518825 | 2022-03-06 04:20:49 | Crawford, Indiana, US | |
2666875 | 2666875 | 2022-03-04 | US | Indiana | Crawford | 18025 | 2530 | 35 | 0 | 38.28814402 | -86.44518825 | 2022-03-05 04:21:10 | Crawford, Indiana, US | |
1646390 | 1646390 | 2022-03-03 | US | Montana | Rosebud | 30087 | 2530 | 59 | 0 | 46.23397237 | -106.72928799999998 | 2022-03-04 04:21:09 | Rosebud, Montana, US | |
2527779 | 2527779 | 2022-03-02 | US | North Dakota | Mercer | 38057 | 2530 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-03-03 04:21:01 | Mercer, North Dakota, US | |
2526255 | 2526255 | 2022-03-02 | US | Georgia | Turner | 13287 | 2530 | 55 | 0 | 31.71612656 | -83.62069378 | 2022-03-03 04:21:01 | Turner, Georgia, US | |
1993855 | 1993855 | 2022-03-01 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-03-02 04:21:07 | Grundy, Iowa, US | |
1993549 | 1993549 | 2022-03-01 | US | Georgia | Turner | 13287 | 2530 | 54 | 0 | 31.71612656 | -83.62069378 | 2022-03-02 04:21:07 | Turner, Georgia, US | |
944029 | 944029 | 2022-02-28 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-03-01 04:21:09 | Grundy, Iowa, US | |
2734220 | 2734220 | 2022-02-27 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-02-28 04:21:05 | Grundy, Iowa, US | |
3047373 | 3047373 | 2022-02-26 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-02-27 04:21:04 | Grundy, Iowa, US | |
576028 | 576028 | 2022-02-25 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-02-26 04:21:12 | Grundy, Iowa, US | |
1512604 | 1512604 | 2022-02-24 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-02-25 04:21:11 | Grundy, Iowa, US | |
1059045 | 1059045 | 2022-02-23 | US | Iowa | Grundy | 19075 | 2530 | 40 | 0 | 42.40183723 | -92.78829551 | 2022-02-24 04:21:14 | Grundy, Iowa, US | |
3673444 | 3673444 | 2022-02-15 | US | Mississippi | Carroll | 28015 | 2530 | 49 | 0 | 33.44834567 | -89.91994479 | 2022-02-16 04:21:10 | Carroll, Mississippi, US | |
1464688 | 1464688 | 2022-02-10 | US | Colorado | Bent | 8011 | 2530 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-02-11 04:21:09 | Bent, Colorado, US | |
3077114 | 3077114 | 2022-02-09 | US | Texas | Dawson | 48115 | 2530 | 92 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-10 04:21:14 | Dawson, Texas, US | |
980189 | 980189 | 2022-02-01 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-02-02 04:21:09 | Shelby, Iowa, US | |
2659031 | 2659031 | 2022-01-31 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-02-01 04:21:11 | Shelby, Iowa, US | |
3301448 | 3301448 | 2022-01-30 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-01-31 04:21:09 | Shelby, Iowa, US | |
3063239 | 3063239 | 2022-01-29 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-01-30 04:21:26 | Shelby, Iowa, US | |
3811173 | 3811173 | 2022-01-28 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-01-29 04:21:10 | Shelby, Iowa, US | |
1780627 | 1780627 | 2022-01-27 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-01-28 04:21:09 | Shelby, Iowa, US | |
1319455 | 1319455 | 2022-01-26 | US | Iowa | Shelby | 19165 | 2530 | 46 | 0 | 41.6850066 | -95.31015553 | 2022-01-27 04:21:19 | Shelby, Iowa, US | |
3227123 | 3227123 | 2022-01-19 | US | Connecticut | Unassigned | 90009 | 2530 | 5 | 0 | 41.85853803 | 0.0 | 2022-01-20 04:21:07 | Unassigned, Connecticut, US | |
3467506 | 3467506 | 2022-01-18 | US | Virginia | Dickenson | 51051 | 2530 | 40 | 0 | 37.12560977 | -82.35124171 | 2022-01-19 04:21:23 | Dickenson, Virginia, US | |
1700155 | 1700155 | 2022-01-03 | China | Shaanxi | 2530 | 3 | 0 | 35.1917 | 108.8701 | 2022-01-04 04:22:17 | Shaanxi, China | |||
2906413 | 2906413 | 2021-12-19 | US | Pennsylvania | Potter | 42105 | 2530 | 73 | 0 | 41.74471626 | -77.89559864 | 2021-12-20 04:21:43 | Potter, Pennsylvania, US | |
1717065 | 1717065 | 2021-12-16 | US | Florida | Jefferson | 12065 | 2530 | 28 | 0 | 30.43669112 | -83.89442308 | 2021-12-17 04:22:14 | Jefferson, Florida, US | |
3496899 | 3496899 | 2021-12-15 | US | Florida | Jefferson | 12065 | 2530 | 28 | 0 | 30.43669112 | -83.89442308 | 2021-12-16 04:22:11 | Jefferson, Florida, US | |
2088684 | 2088684 | 2021-12-14 | US | Florida | Jefferson | 12065 | 2530 | 28 | 0 | 30.43669112 | -83.89442308 | 2021-12-15 03:22:16 | Jefferson, Florida, US | |
785893 | 785893 | 2021-12-13 | US | West Virginia | Morgan | 54065 | 2530 | 51 | 0 | 39.55439028 | -78.26311676 | 2021-12-14 04:22:38 | Morgan, West Virginia, US | |
783101 | 783101 | 2021-12-13 | US | Florida | Jefferson | 12065 | 2530 | 28 | 0 | 30.43669112 | -83.89442308 | 2021-12-14 04:22:38 | Jefferson, Florida, 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]);