johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
237 rows where confirmed = 3314 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557954 | 2557954 | 2022-11-29 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-30 04:21:07 | Wilson, Kansas, US | |
1241028 | 1241028 | 2022-11-28 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-29 04:21:05 | Wilson, Kansas, US | |
3553016 | 3553016 | 2022-11-27 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-28 04:21:02 | Wilson, Kansas, US | |
2101496 | 2101496 | 2022-11-26 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-27 04:21:05 | Wilson, Kansas, US | |
488987 | 488987 | 2022-11-25 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-26 04:21:11 | Wilson, Kansas, US | |
3524816 | 3524816 | 2022-11-24 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-25 04:21:06 | Wilson, Kansas, US | |
3313599 | 3313599 | 2022-11-23 | US | Kansas | Wilson | 20205 | 3314 | 52 | 0 | 37.55937174 | -95.74323255 | 2022-11-24 04:21:09 | Wilson, Kansas, US | |
482461 | 482461 | 2022-11-08 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-09 04:21:22 | Dewey, South Dakota, US | |
2441611 | 2441611 | 2022-11-07 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-08 04:21:21 | Dewey, South Dakota, US | |
1052709 | 1052709 | 2022-11-06 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-07 04:21:26 | Dewey, South Dakota, US | |
620733 | 620733 | 2022-11-05 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-06 04:21:24 | Dewey, South Dakota, US | |
1025237 | 1025237 | 2022-11-04 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-05 04:21:52 | Dewey, South Dakota, US | |
434228 | 434228 | 2022-11-03 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-04 04:22:11 | Dewey, South Dakota, US | |
852470 | 852470 | 2022-11-02 | US | South Dakota | Dewey | 46041 | 3314 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-11-03 04:22:05 | Dewey, South Dakota, US | |
133822 | 133822 | 2022-10-04 | US | Texas | Dawson | 48115 | 3314 | 99 | 0 | 32.74255572 | -101.9477242 | 2022-10-05 04:23:06 | Dawson, Texas, US | |
2688769 | 2688769 | 2022-10-03 | US | Texas | Dawson | 48115 | 3314 | 99 | 0 | 32.74255572 | -101.9477242 | 2022-10-04 04:22:55 | Dawson, Texas, US | |
2686302 | 2686302 | 2022-10-03 | US | Colorado | Archuleta | 8007 | 3314 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-04 04:22:55 | Archuleta, Colorado, US | |
2260369 | 2260369 | 2022-10-02 | US | Colorado | Archuleta | 8007 | 3314 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-03 04:23:11 | Archuleta, Colorado, US | |
2995895 | 2995895 | 2022-10-01 | US | Colorado | Archuleta | 8007 | 3314 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-02 04:21:23 | Archuleta, Colorado, US | |
854221 | 854221 | 2022-09-30 | US | Colorado | Archuleta | 8007 | 3314 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-01 04:23:01 | Archuleta, Colorado, US | |
1890877 | 1890877 | 2022-09-14 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-15 04:21:02 | Koochiching, Minnesota, US | |
373932 | 373932 | 2022-09-13 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-14 04:20:44 | Koochiching, Minnesota, US | |
2396534 | 2396534 | 2022-09-12 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-13 04:20:57 | Koochiching, Minnesota, US | |
3767612 | 3767612 | 2022-09-11 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-12 04:20:58 | Koochiching, Minnesota, US | |
3826187 | 3826187 | 2022-09-10 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-11 04:20:50 | Koochiching, Minnesota, US | |
964644 | 964644 | 2022-09-09 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-10 04:21:10 | Koochiching, Minnesota, US | |
255046 | 255046 | 2022-09-08 | US | Minnesota | Koochiching | 27071 | 3314 | 41 | 0 | 48.24539665 | -93.78352843 | 2022-09-09 04:21:11 | Koochiching, Minnesota, US | |
254255 | 254255 | 2022-09-08 | US | Idaho | Idaho | 16049 | 3314 | 55 | 0 | 45.84721541 | -115.4634436 | 2022-09-09 04:21:11 | Idaho, Idaho, US | |
3746053 | 3746053 | 2022-09-07 | US | Idaho | Idaho | 16049 | 3314 | 55 | 0 | 45.84721541 | -115.4634436 | 2022-09-08 04:21:02 | Idaho, Idaho, US | |
3548154 | 3548154 | 2022-09-01 | US | Colorado | Park | 8093 | 3314 | 22 | 0 | 39.120926 | -105.7182065 | 2022-09-02 04:21:07 | Park, Colorado, US | |
3950856 | 3950856 | 2022-08-17 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-18 04:21:11 | Coosa, Alabama, US | |
991358 | 991358 | 2022-08-16 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-17 04:20:59 | Coosa, Alabama, US | |
2494397 | 2494397 | 2022-08-15 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-16 04:20:58 | Coosa, Alabama, US | |
3647947 | 3647947 | 2022-08-14 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-15 04:20:59 | Coosa, Alabama, US | |
1968953 | 1968953 | 2022-08-13 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-14 04:20:55 | Coosa, Alabama, US | |
2888762 | 2888762 | 2022-08-12 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-13 04:20:52 | Coosa, Alabama, US | |
3908367 | 3908367 | 2022-08-11 | US | Alabama | Coosa | 1037 | 3314 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-12 04:20:54 | Coosa, Alabama, US | |
2595597 | 2595597 | 2022-07-25 | US | Maine | Piscataquis | 23021 | 3314 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-26 04:20:58 | Piscataquis, Maine, US | |
897712 | 897712 | 2022-07-24 | US | Maine | Piscataquis | 23021 | 3314 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-25 04:20:51 | Piscataquis, Maine, US | |
92706 | 92706 | 2022-07-23 | US | Maine | Piscataquis | 23021 | 3314 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-24 04:20:47 | Piscataquis, Maine, US | |
2742818 | 2742818 | 2022-07-07 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-08 04:20:56 | Greene, Mississippi, US | |
1201613 | 1201613 | 2022-07-06 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-07 04:20:55 | Greene, Mississippi, US | |
3968356 | 3968356 | 2022-07-05 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-06 04:20:58 | Greene, Mississippi, US | |
3079867 | 3079867 | 2022-07-04 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-05 04:20:45 | Greene, Mississippi, US | |
1769149 | 1769149 | 2022-07-03 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-04 04:20:54 | Greene, Mississippi, US | |
3367135 | 3367135 | 2022-07-02 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-03 04:20:59 | Greene, Mississippi, US | |
595464 | 595464 | 2022-07-01 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-02 04:21:16 | Greene, Mississippi, US | |
3941865 | 3941865 | 2022-06-30 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-07-01 04:21:10 | Greene, Mississippi, US | |
2491823 | 2491823 | 2022-06-29 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-30 04:21:01 | Greene, Mississippi, US | |
2241205 | 2241205 | 2022-06-28 | US | Mississippi | Greene | 28041 | 3314 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-29 04:20:59 | Greene, Mississippi, US | |
167545 | 167545 | 2022-06-21 | US | Louisiana | Claiborne | 22027 | 3314 | 79 | 0 | 32.82308512 | -92.99526883 | 2022-06-22 04:20:54 | Claiborne, Louisiana, US | |
1765740 | 1765740 | 2022-06-20 | US | North Dakota | McKenzie | 38053 | 3314 | 25 | 0 | 47.7413337 | -103.395905 | 2022-06-21 04:20:56 | McKenzie, North Dakota, US | |
2050644 | 2050644 | 2022-05-25 | US | Puerto Rico | Sabana Grande | 72121 | 3314 | 0 | 0 | 18.08282 | -66.943758 | 2022-05-26 04:20:50 | Sabana Grande, Puerto Rico, US | |
3002771 | 3002771 | 2022-05-24 | US | Washington | Unassigned | 90053 | 3314 | 7 | 0 | 48.82227976 | 0.0 | 2022-05-25 04:20:56 | Unassigned, Washington, US | |
3002302 | 3002302 | 2022-05-24 | US | Tennessee | Stewart | 47161 | 3314 | 62 | 0 | 36.50235092 | -87.83920548 | 2022-05-25 04:20:56 | Stewart, Tennessee, US | |
3596492 | 3596492 | 2022-05-23 | US | Washington | Unassigned | 90053 | 3314 | 7 | 0 | 48.82227976 | 0.0 | 2022-05-24 04:20:57 | Unassigned, Washington, US | |
3596338 | 3596338 | 2022-05-23 | US | Virginia | Brunswick | 51025 | 3314 | 47 | 0 | 36.76366949 | -77.8593436 | 2022-05-24 04:20:57 | Brunswick, Virginia, US | |
3596023 | 3596023 | 2022-05-23 | US | Tennessee | Stewart | 47161 | 3314 | 62 | 0 | 36.50235092 | -87.83920548 | 2022-05-24 04:20:57 | Stewart, Tennessee, US | |
624875 | 624875 | 2022-05-22 | US | Tennessee | Stewart | 47161 | 3314 | 62 | 0 | 36.50235092 | -87.83920548 | 2022-05-26 04:20:50 | Stewart, Tennessee, US | |
624655 | 624655 | 2022-05-22 | US | Puerto Rico | Sabana Grande | 72121 | 3314 | 0 | 0 | 18.08282 | -66.943758 | 2022-05-26 04:20:50 | Sabana Grande, Puerto Rico, US | |
1112571 | 1112571 | 2022-05-21 | US | Tennessee | Stewart | 47161 | 3314 | 62 | 0 | 36.50235092 | -87.83920548 | 2022-05-22 04:20:52 | Stewart, Tennessee, US | |
3586048 | 3586048 | 2022-05-17 | US | Virginia | Rockbridge | 51163 | 3314 | 79 | 0 | 37.81204314 | -79.44605905 | 2022-05-18 04:20:50 | Rockbridge, Virginia, US | |
225325 | 225325 | 2022-05-09 | US | Virginia | Dickenson | 51051 | 3314 | 49 | 0 | 37.12560977 | -82.35124171 | 2022-05-10 04:20:50 | Dickenson, Virginia, US | |
2601378 | 2601378 | 2022-05-05 | US | Virginia | Dickenson | 51051 | 3314 | 49 | 0 | 37.12560977 | -82.35124171 | 2022-05-06 04:21:00 | Dickenson, Virginia, US | |
466924 | 466924 | 2022-05-02 | US | Wisconsin | Ashland | 55003 | 3314 | 36 | 0 | 46.31956891 | -90.67837132 | 2022-05-03 04:21:00 | Ashland, Wisconsin, US | |
1328431 | 1328431 | 2022-04-26 | US | New Jersey | Unassigned | 90034 | 3314 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-27 04:20:52 | Unassigned, New Jersey, US | |
3420249 | 3420249 | 2022-04-17 | US | Virginia | Dickenson | 51051 | 3314 | 47 | 0 | 37.12560977 | -82.35124171 | 2022-04-18 04:21:12 | Dickenson, Virginia, US | |
307198 | 307198 | 2022-04-16 | US | Virginia | Dickenson | 51051 | 3314 | 47 | 0 | 37.12560977 | -82.35124171 | 2022-04-17 04:20:59 | Dickenson, Virginia, US | |
2673143 | 2673143 | 2022-04-15 | US | Virginia | Dickenson | 51051 | 3314 | 47 | 0 | 37.12560977 | -82.35124171 | 2022-04-16 04:20:48 | Dickenson, Virginia, US | |
1226928 | 1226928 | 2022-04-14 | US | Virginia | Dickenson | 51051 | 3314 | 47 | 0 | 37.12560977 | -82.35124171 | 2022-04-15 04:20:57 | Dickenson, Virginia, US | |
2446086 | 2446086 | 2022-04-13 | US | Virginia | Dickenson | 51051 | 3314 | 47 | 0 | 37.12560977 | -82.35124171 | 2022-04-13 23:21:06 | Dickenson, Virginia, US | |
1866793 | 1866793 | 2022-03-10 | US | Kansas | Marion | 20115 | 3314 | 39 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-11 04:20:50 | Marion, Kansas, US | |
2143250 | 2143250 | 2022-03-09 | US | Texas | Duval | 48131 | 3314 | 68 | 0 | 27.68184592 | -98.50864568 | 2022-03-10 04:20:48 | Duval, Texas, US | |
2141488 | 2141488 | 2022-03-09 | US | Kansas | Marion | 20115 | 3314 | 39 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-10 04:20:48 | Marion, Kansas, US | |
2201924 | 2201924 | 2022-03-06 | US | New York | Yates | 36123 | 3314 | 39 | 0 | 42.63505484 | -77.10369919 | 2022-03-07 04:20:47 | Yates, New York, US | |
2666304 | 2666304 | 2022-03-04 | US | Arkansas | Marion | 5089 | 3314 | 85 | 0 | 36.26844485 | -92.68451899 | 2022-03-05 04:21:10 | Marion, Arkansas, US | |
1646798 | 1646798 | 2022-03-03 | US | North Dakota | Walsh | 38099 | 3314 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-03-04 04:21:09 | Walsh, North Dakota, US | |
577550 | 577550 | 2022-02-25 | US | Puerto Rico | Aibonito | 72009 | 3314 | 0 | 0 | 18.131361 | -66.264131 | 2022-02-26 04:21:12 | Aibonito, Puerto Rico, US | |
1514126 | 1514126 | 2022-02-24 | US | Puerto Rico | Aibonito | 72009 | 3314 | 0 | 0 | 18.131361 | -66.264131 | 2022-02-25 04:21:11 | Aibonito, Puerto Rico, US | |
1365592 | 1365592 | 2022-02-08 | US | Texas | Tyler | 48457 | 3314 | 76 | 0 | 30.77031716 | -94.37690895 | 2022-02-09 04:21:04 | Tyler, Texas, US | |
1365327 | 1365327 | 2022-02-08 | US | Tennessee | Meigs | 47121 | 3314 | 51 | 0 | 35.51558739 | -84.81482914 | 2022-02-09 04:21:04 | Meigs, Tennessee, US | |
2477535 | 2477535 | 2022-02-03 | US | Wisconsin | Rusk | 55107 | 3314 | 46 | 0 | 45.47498854 | -91.1333012 | 2022-02-04 04:21:10 | Rusk, Wisconsin, US | |
1782321 | 1782321 | 2022-01-27 | US | Tennessee | Decatur | 47039 | 3314 | 52 | 0 | 35.60048904 | -88.11043779 | 2022-01-28 04:21:09 | Decatur, Tennessee, US | |
1473568 | 1473568 | 2022-01-17 | US | Kentucky | Morgan | 21175 | 3314 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-18 04:21:04 | Morgan, Kentucky, US | |
556242 | 556242 | 2022-01-16 | US | Kentucky | Morgan | 21175 | 3314 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-17 04:21:08 | Morgan, Kentucky, US | |
3841963 | 3841963 | 2022-01-15 | US | Kentucky | Morgan | 21175 | 3314 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-16 04:21:12 | Morgan, Kentucky, US | |
100778 | 100778 | 2022-01-14 | US | Kentucky | Morgan | 21175 | 3314 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-15 04:21:07 | Morgan, Kentucky, US | |
3690311 | 3690311 | 2022-01-13 | US | South Carolina | Lee | 45061 | 3314 | 83 | 0 | 34.16393091 | -80.25690731 | 2022-01-14 04:21:54 | Lee, South Carolina, US | |
3614860 | 3614860 | 2022-01-12 | US | Mississippi | Clarke | 28023 | 3314 | 96 | 0 | 32.04158545 | -88.68896219999998 | 2022-01-13 08:00:09 | Clarke, Mississippi, US | |
1115939 | 1115939 | 2022-01-11 | US | North Carolina | Northampton | 37131 | 3314 | 66 | 0 | 36.41736238 | -77.39769443 | 2022-01-12 04:21:44 | Northampton, North Carolina, US | |
2611464 | 2611464 | 2022-01-06 | US | Kentucky | Henry | 21103 | 3314 | 38 | 0 | 38.44942688 | -85.11587507 | 2022-01-07 04:22:09 | Henry, Kentucky, US | |
1282977 | 1282977 | 2022-01-05 | US | Illinois | Ford | 17053 | 3314 | 59 | 0 | 40.59706922 | -88.22350769 | 2022-01-06 04:22:09 | Ford, Illinois, US | |
1672060 | 1672060 | 2021-12-29 | US | Wyoming | Carbon | 56007 | 3314 | 46 | 0 | 41.69357844 | -106.9326084 | 2021-12-30 04:21:25 | Carbon, Wyoming, US | |
1434242 | 1434242 | 2021-12-28 | US | Michigan | Ogemaw | 26129 | 3314 | 80 | 0 | 44.33481032 | -84.12725175 | 2021-12-29 03:21:43 | Ogemaw, Michigan, US | |
732203 | 732203 | 2021-12-27 | US | Michigan | Ogemaw | 26129 | 3314 | 80 | 0 | 44.33481032 | -84.12725175 | 2021-12-28 04:21:47 | Ogemaw, Michigan, US | |
2112622 | 2112622 | 2021-12-26 | US | Idaho | Blaine | 16013 | 3314 | 27 | 0 | 43.4085812 | -113.9752658 | 2021-12-27 04:21:58 | Blaine, Idaho, US | |
3605994 | 3605994 | 2021-12-25 | US | Idaho | Blaine | 16013 | 3314 | 27 | 0 | 43.4085812 | -113.9752658 | 2021-12-26 04:21:50 | Blaine, Idaho, US | |
2966569 | 2966569 | 2021-12-24 | US | Texas | Montague | 48337 | 3314 | 99 | 0 | 33.67521893 | -97.72500958 | 2021-12-25 04:21:37 | Montague, Texas, US | |
2964312 | 2964312 | 2021-12-24 | US | Idaho | Blaine | 16013 | 3314 | 27 | 0 | 43.4085812 | -113.9752658 | 2021-12-25 04:21:37 | Blaine, Idaho, US | |
3817344 | 3817344 | 2021-12-23 | US | Idaho | Blaine | 16013 | 3314 | 27 | 0 | 43.4085812 | -113.9752658 | 2021-12-24 04:21:34 | Blaine, Idaho, 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]);