johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
155 rows where deaths = 1046 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753296 | 2753296 | 2022-12-29 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-30 04:21:04 | Madison, Alabama, US | |
1074302 | 1074302 | 2022-12-28 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-29 04:21:01 | Madison, Alabama, US | |
328299 | 328299 | 2022-12-27 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-28 04:21:04 | Madison, Alabama, US | |
218372 | 218372 | 2022-12-26 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-27 04:21:07 | Madison, Alabama, US | |
3222829 | 3222829 | 2022-12-25 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-26 04:21:06 | Madison, Alabama, US | |
1018743 | 1018743 | 2022-12-24 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-25 04:21:04 | Madison, Alabama, US | |
690766 | 690766 | 2022-12-23 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-24 04:21:02 | Madison, Alabama, US | |
2179976 | 2179976 | 2022-12-22 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-23 04:21:04 | Madison, Alabama, US | |
451780 | 451780 | 2022-12-21 | US | Alabama | Madison | 1089 | 111206 | 1046 | 0 | 34.76327133 | -86.55069633 | 2022-12-22 04:20:56 | Madison, Alabama, US | |
711232 | 711232 | 2022-11-01 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-11-02 04:22:09 | Clayton, Georgia, US | |
3285681 | 3285681 | 2022-10-31 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-11-01 04:22:36 | Clayton, Georgia, US | |
320714 | 320714 | 2022-10-30 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-10-31 04:21:36 | Clayton, Georgia, US | |
912990 | 912990 | 2022-10-29 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-10-30 04:22:14 | Clayton, Georgia, US | |
1367259 | 1367259 | 2022-10-28 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-10-29 04:21:13 | Clayton, Georgia, US | |
3039114 | 3039114 | 2022-10-27 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-10-28 04:22:31 | Clayton, Georgia, US | |
539534 | 539534 | 2022-10-26 | US | Georgia | Clayton | 13063 | 74375 | 1046 | 0 | 33.54187245 | -84.35594188 | 2022-10-27 04:22:01 | Clayton, Georgia, US | |
2757188 | 2757188 | 2022-10-18 | Russia | Yamalo-Nenets Autonomous Okrug | 148019 | 1046 | 0 | 67.1471631 | 74.3415488 | 2022-10-19 04:22:26 | Yamalo-Nenets Autonomous Okrug, Russia | |||
2033022 | 2033022 | 2022-10-14 | Russia | Novgorod Oblast | 115281 | 1046 | 0 | 58.2843833 | 32.5169757 | 2022-10-15 04:22:00 | Novgorod Oblast, Russia | |||
3753710 | 3753710 | 2022-10-13 | Russia | Novgorod Oblast | 115242 | 1046 | 0 | 58.2843833 | 32.5169757 | 2022-10-14 04:22:28 | Novgorod Oblast, Russia | |||
3214535 | 3214535 | 2022-10-12 | Russia | Novgorod Oblast | 115199 | 1046 | 0 | 58.2843833 | 32.5169757 | 2022-10-13 04:22:39 | Novgorod Oblast, Russia | |||
3250384 | 3250384 | 2022-10-11 | Russia | Novgorod Oblast | 115155 | 1046 | 0 | 58.2843833 | 32.5169757 | 2022-10-12 04:22:51 | Novgorod Oblast, Russia | |||
2967643 | 2967643 | 2022-10-10 | Russia | Novgorod Oblast | 115114 | 1046 | 0 | 58.2843833 | 32.5169757 | 2022-10-11 04:23:05 | Novgorod Oblast, Russia | |||
3097679 | 3097679 | 2022-10-09 | Russia | Novgorod Oblast | 115064 | 1046 | 0 | 58.2843833 | 32.5169757 | 2022-10-10 04:22:32 | Novgorod Oblast, Russia | |||
1625035 | 1625035 | 2022-09-22 | US | Florida | Unassigned | 90012 | 2962 | 1046 | 0 | 30.86747479 | 0.0 | 2022-09-23 04:23:13 | Unassigned, Florida, US | |
1349573 | 1349573 | 2022-08-10 | US | Texas | Webb | 48479 | 103244 | 1046 | 0 | 27.7610369 | -99.33237355 | 2022-08-11 04:20:49 | Webb, Texas, US | |
938955 | 938955 | 2022-06-25 | New Zealand | 1308387 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-26 04:21:02 | New Zealand | ||||
3346775 | 3346775 | 2022-06-24 | New Zealand | 1303779 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-25 04:20:57 | New Zealand | ||||
1648516 | 1648516 | 2022-06-23 | New Zealand | 1294657 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-24 04:20:58 | New Zealand | ||||
2187751 | 2187751 | 2022-06-22 | New Zealand | 1294657 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-23 04:20:55 | New Zealand | ||||
166182 | 166182 | 2022-06-21 | New Zealand | 1289128 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-22 04:20:54 | New Zealand | ||||
1763465 | 1763465 | 2022-06-20 | New Zealand | 1283444 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-21 04:20:56 | New Zealand | ||||
3269651 | 3269651 | 2022-06-19 | New Zealand | 1277568 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-20 04:21:01 | New Zealand | ||||
3186208 | 3186208 | 2022-05-30 | Russia | Kirov Oblast | 151749 | 1046 | 0 | 57.9665589 | 49.4074599 | 2022-05-31 04:20:51 | Kirov Oblast, Russia | |||
1654648 | 1654648 | 2022-04-09 | US | New York | Onondaga | 36067 | 114262 | 1046 | 0 | 43.00491923 | -76.19971155 | 2022-04-10 04:20:52 | Onondaga, New York, US | |
2117970 | 2117970 | 2022-04-08 | US | New York | Onondaga | 36067 | 114017 | 1046 | 0 | 43.00491923 | -76.19971155 | 2022-04-09 04:20:42 | Onondaga, New York, US | |
3322494 | 3322494 | 2022-04-07 | US | New York | Onondaga | 36067 | 113728 | 1046 | 0 | 43.00491923 | -76.19971155 | 2022-04-08 04:20:48 | Onondaga, New York, US | |
2803030 | 2803030 | 2022-04-06 | US | New York | Onondaga | 36067 | 113427 | 1046 | 0 | 43.00491923 | -76.19971155 | 2022-04-07 04:20:53 | Onondaga, New York, US | |
3869799 | 3869799 | 2022-04-05 | US | New York | Onondaga | 36067 | 113177 | 1046 | 0 | 43.00491923 | -76.19971155 | 2022-04-06 04:20:49 | Onondaga, New York, US | |
3732610 | 3732610 | 2022-04-03 | US | North Carolina | Wake | 37183 | 290330 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-04-04 04:20:51 | Wake, North Carolina, US | |
502045 | 502045 | 2022-04-02 | US | North Carolina | Wake | 37183 | 290330 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-04-03 04:20:48 | Wake, North Carolina, US | |
3353030 | 3353030 | 2022-04-01 | US | North Carolina | Wake | 37183 | 290330 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-04-02 04:20:47 | Wake, North Carolina, US | |
1542335 | 1542335 | 2022-03-31 | US | North Carolina | Wake | 37183 | 290245 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-04-01 04:20:28 | Wake, North Carolina, US | |
2480348 | 2480348 | 2022-03-30 | US | North Carolina | Wake | 37183 | 290132 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-03-31 04:20:56 | Wake, North Carolina, US | |
160389 | 160389 | 2022-03-29 | US | North Carolina | Wake | 37183 | 290032 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-03-30 04:20:45 | Wake, North Carolina, US | |
1438960 | 1438960 | 2022-03-28 | US | North Carolina | Wake | 37183 | 289966 | 1046 | 0 | 35.78879266 | -78.65249174 | 2022-03-29 04:20:46 | Wake, North Carolina, US | |
357898 | 357898 | 2022-03-11 | US | Maryland | Anne Arundel | 24003 | 88588 | 1046 | 0 | 39.00670238 | -76.60329337 | 2022-03-12 04:20:50 | Anne Arundel, Maryland, US | |
2644078 | 2644078 | 2022-02-14 | US | North Carolina | Guilford | 37081 | 112159 | 1046 | 0 | 36.07959451 | -79.78824948 | 2022-02-15 04:21:09 | Guilford, North Carolina, US | |
3076871 | 3076871 | 2022-02-09 | US | South Carolina | Horry | 45051 | 93537 | 1046 | 0 | 33.9212828 | -78.99555293 | 2022-02-10 04:21:14 | Horry, South Carolina, US | |
3810394 | 3810394 | 2022-01-28 | US | Arizona | Yuma | 4027 | 57792 | 1046 | 0 | 32.76895712 | -113.90666740000002 | 2022-01-29 04:21:10 | Yuma, Arizona, US | |
3810153 | 3810153 | 2022-01-28 | Russia | Kurgan Oblast | 53387 | 1046 | 0 | 55.7655302 | 64.5632681 | 2022-01-29 04:21:10 | Kurgan Oblast, Russia | |||
1780453 | 1780453 | 2022-01-27 | US | Indiana | Allen | 18003 | 98149 | 1046 | 0 | 41.09194313 | -85.06800636 | 2022-01-28 04:21:09 | Allen, Indiana, US | |
1230062 | 1230062 | 2022-01-24 | US | Ohio | Butler | 39017 | 83907 | 1046 | 0 | 39.44012838 | -84.57388716 | 2022-01-25 04:21:05 | Butler, Ohio, US | |
1474282 | 1474282 | 2022-01-17 | US | New Jersey | Burlington | 34005 | 91123 | 1046 | 0 | 39.87681124 | -74.66927768 | 2022-01-18 04:21:04 | Burlington, New Jersey, US | |
2777594 | 2777594 | 2021-12-31 | US | Colorado | Arapahoe | 8005 | 112287 | 1046 | 0 | 39.64977461 | -104.3353617 | 2022-01-01 04:22:14 | Arapahoe, Colorado, US | |
2966350 | 2966350 | 2021-12-24 | US | Tennessee | Knox | 47093 | 83559 | 1046 | 0 | 35.99508821 | -83.94635435 | 2021-12-25 04:21:37 | Knox, Tennessee, US | |
3819382 | 3819382 | 2021-12-23 | US | Tennessee | Knox | 47093 | 83384 | 1046 | 0 | 35.99508821 | -83.94635435 | 2021-12-24 04:21:34 | Knox, Tennessee, US | |
801114 | 801114 | 2021-12-22 | US | Pennsylvania | Luzerne | 42079 | 50717 | 1046 | 0 | 41.17823008 | -75.98447579 | 2021-12-23 04:21:21 | Luzerne, Pennsylvania, US | |
3498317 | 3498317 | 2021-12-15 | US | Nebraska | Unassigned | 90031 | 2519 | 1046 | 0 | 42.8997274 | 0.0 | 2021-12-16 04:22:11 | Unassigned, Nebraska, US | |
1146686 | 1146686 | 2021-12-01 | US | Minnesota | Ramsey | 27123 | 73971 | 1046 | 0 | 45.01625271 | -93.09872295 | 2021-12-02 04:22:37 | Ramsey, Minnesota, US | |
1145473 | 1145473 | 2021-12-01 | US | California | Contra Costa | 6013 | 103951 | 1046 | 0 | 37.91923498 | -121.9289527 | 2021-12-02 04:22:37 | Contra Costa, California, US | |
1145382 | 1145382 | 2021-12-01 | US | Arizona | Mohave | 4015 | 36153 | 1046 | 0 | 35.70471703 | -113.7577902 | 2021-12-02 04:22:37 | Mohave, Arizona, US | |
3401985 | 3401985 | 2021-11-30 | US | California | Contra Costa | 6013 | 103831 | 1046 | 0 | 37.91923498 | -121.9289527 | 2021-12-01 04:22:29 | Contra Costa, California, US | |
3401894 | 3401894 | 2021-11-30 | US | Arizona | Mohave | 4015 | 36025 | 1046 | 0 | 35.70471703 | -113.7577902 | 2021-12-01 04:22:29 | Mohave, Arizona, US | |
150528 | 150528 | 2021-11-29 | US | California | Contra Costa | 6013 | 103726 | 1046 | 0 | 37.91923498 | -121.9289527 | 2021-11-30 04:22:53 | Contra Costa, California, US | |
1232258 | 1232258 | 2021-11-28 | US | Colorado | Jefferson | 8059 | 74120 | 1046 | 0 | 39.58635604 | -105.2517692 | 2021-11-29 04:22:30 | Jefferson, Colorado, US | |
1358790 | 1358790 | 2021-11-27 | US | Arizona | Mohave | 4015 | 35841 | 1046 | 0 | 35.70471703 | -113.7577902 | 2021-11-28 04:22:43 | Mohave, Arizona, US | |
3073101 | 3073101 | 2021-11-23 | US | Texas | Denton | 48121 | 106951 | 1046 | 0 | 33.20521901 | -97.11691153 | 2021-11-24 04:22:14 | Denton, Texas, US | |
722708 | 722708 | 2021-11-20 | Russia | Karelia Republic | 80557 | 1046 | 0 | 62.61940309999999 | 33.4920267 | 2021-11-21 04:22:13 | Karelia Republic, Russia | |||
447142 | 447142 | 2021-11-17 | Chile | Coquimbo | 51493 | 1046 | 0 | -29.959 | -71.3389 | 2021-11-18 04:21:33 | Coquimbo, Chile | |||
3342392 | 3342392 | 2021-11-16 | Chile | Coquimbo | 51406 | 1046 | 0 | -29.959 | -71.3389 | 2021-11-17 04:21:48 | Coquimbo, Chile | |||
2287228 | 2287228 | 2021-11-15 | Chile | Coquimbo | 51330 | 1046 | 0 | -29.959 | -71.3389 | 2021-11-16 04:21:10 | Coquimbo, Chile | |||
698424 | 698424 | 2021-11-04 | Japan | Saitama | 115629 | 1046 | 0 | 35.997101 | 139.347635 | 2021-11-05 04:21:54 | Saitama, Japan | |||
276202 | 276202 | 2021-11-03 | Japan | Saitama | 115623 | 1046 | 0 | 35.997101 | 139.347635 | 2021-11-04 04:22:20 | Saitama, Japan | |||
43727 | 43727 | 2021-11-02 | Japan | Saitama | 115616 | 1046 | 0 | 35.997101 | 139.347635 | 2021-11-03 06:22:09 | Saitama, Japan | |||
597846 | 597846 | 2021-10-19 | Peru | Pasco | 15816 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-20 04:21:00 | Pasco, Peru | |||
2044023 | 2044023 | 2021-10-18 | Peru | Pasco | 15816 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-19 04:20:54 | Pasco, Peru | |||
1909384 | 1909384 | 2021-10-17 | Peru | Pasco | 15816 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-18 04:21:10 | Pasco, Peru | |||
934973 | 934973 | 2021-10-16 | Peru | Pasco | 15809 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-17 04:21:29 | Pasco, Peru | |||
2943528 | 2943528 | 2021-10-15 | Peru | Pasco | 15809 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-16 04:21:15 | Pasco, Peru | |||
3007507 | 3007507 | 2021-10-11 | Peru | Pasco | 15790 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-12 04:21:09 | Pasco, Peru | |||
423523 | 423523 | 2021-10-10 | Peru | Pasco | 15790 | 1046 | 0 | -10.39655 | -75.307635 | 2021-10-11 04:21:31 | Pasco, Peru | |||
2461844 | 2461844 | 2021-10-06 | US | Texas | Collin | 48085 | 122489 | 1046 | 0 | 33.18820114 | -96.57264368 | 2021-10-07 04:21:36 | Collin, Texas, US | |
2078460 | 2078460 | 2021-09-26 | US | Ohio | Stark | 39151 | 42350 | 1046 | 0 | 40.81482476 | -81.36437305 | 2021-09-27 04:21:16 | Stark, Ohio, US | |
3011253 | 3011253 | 2021-09-22 | Germany | Saarland | 46783 | 1046 | 0 | 49.3964 | 7.023 | 2021-09-23 04:21:43 | Saarland, Germany | |||
3758088 | 3758088 | 2021-09-21 | US | Colorado | El Paso | 8041 | 90599 | 1046 | 0 | 38.83240149 | -104.5251411 | 2021-09-22 04:21:45 | El Paso, Colorado, US | |
3757391 | 3757391 | 2021-09-21 | Germany | Saarland | 46636 | 1046 | 0 | 49.3964 | 7.023 | 2021-09-22 04:21:45 | Saarland, Germany | |||
809687 | 809687 | 2021-09-20 | Mongolia | 307878 | 1046 | 0 | 46.8625 | 103.8467 | 2021-09-21 04:21:26 | Mongolia | ||||
809494 | 809494 | 2021-09-20 | Germany | Saarland | 46613 | 1046 | 0 | 49.3964 | 7.023 | 2021-09-21 04:21:26 | Saarland, Germany | |||
1815017 | 1815017 | 2021-09-19 | Russia | Ryazan Oblast | 40894 | 1046 | 0 | 54.42267320000001 | 40.57052460000001 | 2021-09-20 04:21:22 | Ryazan Oblast, Russia | |||
1814693 | 1814693 | 2021-09-19 | Germany | Saarland | 46413 | 1046 | 0 | 49.3964 | 7.023 | 2021-09-20 04:21:22 | Saarland, Germany | |||
16273 | 16273 | 2021-09-18 | Germany | Saarland | 46413 | 1046 | 0 | 49.3964 | 7.023 | 2021-09-19 04:21:34 | Saarland, Germany | |||
2617958 | 2617958 | 2021-09-17 | Germany | Saarland | 46413 | 1046 | 0 | 49.3964 | 7.023 | 2021-09-18 04:21:24 | Saarland, Germany | |||
642944 | 642944 | 2021-09-07 | US | Illinois | Lake | 17097 | 74910 | 1046 | 0 | 42.3224907 | -88.00367925 | 2021-09-08 04:21:31 | Lake, Illinois, US | |
3197678 | 3197678 | 2021-09-06 | Malaysia | Negeri Sembilan | 93043 | 1046 | 88560 | 3437 | 2.7258 | 101.9424 | 2021-09-07 04:21:35 | Negeri Sembilan, Malaysia | ||
67061 | 67061 | 2021-09-01 | Japan | Aichi | 85594 | 1046 | 0 | 35.035551 | 137.211621 | 2021-09-02 04:21:15 | Aichi, Japan | |||
1596098 | 1596098 | 2021-08-26 | Finland | 125014 | 1046 | 0 | 61.92411 | 25.748151 | 2021-08-27 04:21:37 | Finland | ||||
2352494 | 2352494 | 2021-08-10 | US | Illinois | Will | 17197 | 79892 | 1046 | 0 | 41.44619267 | -87.97862712 | 2021-08-11 04:21:58 | Will, Illinois, US | |
651023 | 651023 | 2021-08-09 | US | Illinois | Will | 17197 | 79723 | 1046 | 0 | 41.44619267 | -87.97862712 | 2021-08-10 04:21:27 | Will, Illinois, US | |
334724 | 334724 | 2021-08-04 | US | South Carolina | Greenville | 45045 | 77954 | 1046 | 0 | 34.89502264 | -82.37295012 | 2021-08-05 04:21:51 | Greenville, South Carolina, US | |
3468768 | 3468768 | 2021-08-03 | US | California | Ventura | 6111 | 87799 | 1046 | 0 | 34.44465746 | -119.0910613 | 2021-08-04 04:21:25 | Ventura, California, 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]);