johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,198 rows where confirmed = 163 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 25
- US 1,068
- Spain 40
- United Kingdom 31
- Japan 14
- India 13
- Colombia 4
- Tuvalu 4
- China 3
- France 3
- Antigua and Barbuda 2
- Mainland China 2
- Belarus 1
- Bulgaria 1
- Canada 1
- Chile 1
- Comoros 1
- Eswatini 1
- Jamaica 1
- Lebanon 1
- Malaysia 1
- Netherlands 1
- Papua New Guinea 1
- Russia 1
- Ukraine 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
479938 | 479938 | 2022-11-08 | Tuvalu | 163 | 0 | 0 | -7.1095 | 177.6493 | 2022-11-09 04:21:22 | Tuvalu | ||||
2439088 | 2439088 | 2022-11-07 | Tuvalu | 163 | 0 | 0 | -7.1095 | 177.6493 | 2022-11-08 04:21:21 | Tuvalu | ||||
1050186 | 1050186 | 2022-11-06 | Tuvalu | 163 | 0 | 0 | -7.1095 | 177.6493 | 2022-11-07 04:21:26 | Tuvalu | ||||
618210 | 618210 | 2022-11-05 | Tuvalu | 163 | 0 | 0 | -7.1095 | 177.6493 | 2022-11-06 04:21:24 | Tuvalu | ||||
433364 | 433364 | 2022-11-03 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-11-04 04:22:11 | Golden Valley, Montana, US | |
851606 | 851606 | 2022-11-02 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-11-03 04:22:05 | Golden Valley, Montana, US | |
712457 | 712457 | 2022-11-01 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-11-02 04:22:09 | Golden Valley, Montana, US | |
3286906 | 3286906 | 2022-10-31 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-11-01 04:22:36 | Golden Valley, Montana, US | |
321939 | 321939 | 2022-10-30 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-31 04:21:36 | Golden Valley, Montana, US | |
914215 | 914215 | 2022-10-29 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-30 04:22:14 | Golden Valley, Montana, US | |
1368484 | 1368484 | 2022-10-28 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-29 04:21:13 | Golden Valley, Montana, US | |
3040339 | 3040339 | 2022-10-27 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-28 04:22:31 | Golden Valley, Montana, US | |
540759 | 540759 | 2022-10-26 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-27 04:22:01 | Golden Valley, Montana, US | |
1832160 | 1832160 | 2022-10-25 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-26 04:22:19 | Golden Valley, Montana, US | |
796421 | 796421 | 2022-10-24 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-25 04:21:53 | Golden Valley, Montana, US | |
3278876 | 3278876 | 2022-10-23 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-24 04:22:29 | Golden Valley, Montana, US | |
2269914 | 2269914 | 2022-10-22 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-23 04:22:46 | Golden Valley, Montana, US | |
1594214 | 1594214 | 2022-10-21 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-22 04:22:53 | Golden Valley, Montana, US | |
2273930 | 2273930 | 2022-10-20 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-21 04:22:23 | Golden Valley, Montana, US | |
200265 | 200265 | 2022-10-19 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-20 04:22:59 | Golden Valley, Montana, US | |
2758926 | 2758926 | 2022-10-18 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-19 04:22:26 | Golden Valley, Montana, US | |
2026760 | 2026760 | 2022-10-17 | US | Montana | Golden Valley | 30037 | 163 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-18 04:22:42 | Golden Valley, Montana, US | |
115413 | 115413 | 2022-09-06 | US | Colorado | Unassigned | 90008 | 163 | 1 | 0 | 40.87595412 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Colorado, US | |
2634385 | 2634385 | 2022-09-05 | US | Colorado | Unassigned | 90008 | 163 | 1 | 0 | 40.87595412 | 0.0 | 2022-09-06 04:21:02 | Unassigned, Colorado, US | |
993384 | 993384 | 2022-08-16 | US | North Dakota | Billings | 38007 | 163 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-17 04:20:59 | Billings, North Dakota, US | |
2496423 | 2496423 | 2022-08-15 | US | North Dakota | Billings | 38007 | 163 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-16 04:20:58 | Billings, North Dakota, US | |
2741942 | 2741942 | 2022-07-07 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-08 04:20:56 | Camas, Idaho, US | |
1200737 | 1200737 | 2022-07-06 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-07 04:20:55 | Camas, Idaho, US | |
3967480 | 3967480 | 2022-07-05 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-06 04:20:58 | Camas, Idaho, US | |
3078991 | 3078991 | 2022-07-04 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-05 04:20:45 | Camas, Idaho, US | |
1768273 | 1768273 | 2022-07-03 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-04 04:20:54 | Camas, Idaho, US | |
3366259 | 3366259 | 2022-07-02 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-03 04:20:59 | Camas, Idaho, US | |
594588 | 594588 | 2022-07-01 | US | Idaho | Camas | 16025 | 163 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-07-02 04:21:16 | Camas, Idaho, US | |
2142030 | 2142030 | 2022-03-09 | US | Mississippi | Unassigned | 90028 | 163 | 22 | 0 | 34.88084463 | 0.0 | 2022-03-10 04:20:48 | Unassigned, Mississippi, US | |
2736688 | 2736688 | 2022-02-27 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-28 04:21:05 | Montserrat, United Kingdom | |||
3049841 | 3049841 | 2022-02-26 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-27 04:21:04 | Montserrat, United Kingdom | |||
578496 | 578496 | 2022-02-25 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-26 04:21:12 | Montserrat, United Kingdom | |||
1515072 | 1515072 | 2022-02-24 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-25 04:21:11 | Montserrat, United Kingdom | |||
1061513 | 1061513 | 2022-02-23 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-24 04:21:14 | Montserrat, United Kingdom | |||
1061011 | 1061011 | 2022-02-23 | US | Texas | Loving | 48301 | 163 | 0 | 0 | 31.84947612 | -103.5818571 | 2022-02-24 04:21:14 | Loving, Texas, US | |
2450436 | 2450436 | 2022-02-22 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-23 04:21:09 | Montserrat, United Kingdom | |||
3721849 | 3721849 | 2022-02-21 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-22 04:21:01 | Montserrat, United Kingdom | |||
3915683 | 3915683 | 2022-02-20 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-21 04:21:05 | Montserrat, United Kingdom | |||
3879241 | 3879241 | 2022-02-19 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-20 04:21:00 | Montserrat, United Kingdom | |||
3859497 | 3859497 | 2022-02-18 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-19 04:21:11 | Montserrat, United Kingdom | |||
1301716 | 1301716 | 2022-02-17 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-18 04:21:04 | Montserrat, United Kingdom | |||
3824102 | 3824102 | 2022-02-16 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-17 04:20:56 | Montserrat, United Kingdom | |||
3675316 | 3675316 | 2022-02-15 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-16 04:21:10 | Montserrat, United Kingdom | |||
3674860 | 3674860 | 2022-02-15 | US | Texas | Roberts | 48393 | 163 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-16 04:21:10 | Roberts, Texas, US | |
2645415 | 2645415 | 2022-02-14 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-15 04:21:09 | Montserrat, United Kingdom | |||
2644961 | 2644961 | 2022-02-14 | US | Texas | Roberts | 48393 | 163 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-15 04:21:09 | Roberts, Texas, US | |
189732 | 189732 | 2022-02-13 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-14 04:20:51 | Montserrat, United Kingdom | |||
189278 | 189278 | 2022-02-13 | US | Texas | Roberts | 48393 | 163 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-14 04:20:51 | Roberts, Texas, US | |
319578 | 319578 | 2022-02-12 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-13 04:21:00 | Montserrat, United Kingdom | |||
319124 | 319124 | 2022-02-12 | US | Texas | Roberts | 48393 | 163 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-13 04:21:00 | Roberts, Texas, US | |
316544 | 316544 | 2022-02-12 | US | Colorado | Jackson | 8057 | 163 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-02-13 04:21:00 | Jackson, Colorado, US | |
236904 | 236904 | 2022-02-11 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-12 04:21:06 | Montserrat, United Kingdom | |||
236450 | 236450 | 2022-02-11 | US | Texas | Roberts | 48393 | 163 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-12 04:21:06 | Roberts, Texas, US | |
236415 | 236415 | 2022-02-11 | US | Texas | McMullen | 48311 | 163 | 8 | 0 | 28.35251708 | -98.56769164 | 2022-02-12 04:21:06 | McMullen, Texas, US | |
233870 | 233870 | 2022-02-11 | US | Colorado | Jackson | 8057 | 163 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-02-12 04:21:06 | Jackson, Colorado, US | |
1467746 | 1467746 | 2022-02-10 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-11 04:21:09 | Montserrat, United Kingdom | |||
1467292 | 1467292 | 2022-02-10 | US | Texas | Roberts | 48393 | 163 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-11 04:21:09 | Roberts, Texas, US | |
3077707 | 3077707 | 2022-02-09 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-10 04:21:14 | Montserrat, United Kingdom | |||
1366014 | 1366014 | 2022-02-08 | United Kingdom | Montserrat | 163 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-02-09 04:21:04 | Montserrat, United Kingdom | |||
74752 | 74752 | 2022-02-07 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-08 04:21:15 | Montserrat, United Kingdom | |||
2016368 | 2016368 | 2022-02-06 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-07 04:21:05 | Montserrat, United Kingdom | |||
1297697 | 1297697 | 2022-02-05 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-06 04:21:00 | Montserrat, United Kingdom | |||
2331025 | 2331025 | 2022-02-04 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-05 04:21:05 | Montserrat, United Kingdom | |||
2477616 | 2477616 | 2022-02-03 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-04 04:21:10 | Montserrat, United Kingdom | |||
463041 | 463041 | 2022-02-02 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-03 04:21:21 | Montserrat, United Kingdom | |||
982610 | 982610 | 2022-02-01 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-02 04:21:09 | Montserrat, United Kingdom | |||
2661452 | 2661452 | 2022-01-31 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-01 04:21:11 | Montserrat, United Kingdom | |||
3303869 | 3303869 | 2022-01-30 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-01-31 04:21:09 | Montserrat, United Kingdom | |||
3065660 | 3065660 | 2022-01-29 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-01-30 04:21:26 | Montserrat, United Kingdom | |||
1143796 | 1143796 | 2022-01-23 | US | South Dakota | Jones | 46075 | 163 | 1 | 0 | 43.96278565 | -100.6940008 | 2022-01-24 04:21:12 | Jones, South Dakota, US | |
1143028 | 1143028 | 2022-01-23 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-24 04:21:12 | Rock, Nebraska, US | |
2835714 | 2835714 | 2022-01-22 | US | South Dakota | Jones | 46075 | 163 | 1 | 0 | 43.96278565 | -100.6940008 | 2022-01-23 04:21:13 | Jones, South Dakota, US | |
2834946 | 2834946 | 2022-01-22 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-23 04:21:13 | Rock, Nebraska, US | |
3427832 | 3427832 | 2022-01-21 | US | South Dakota | Jones | 46075 | 163 | 1 | 0 | 43.96278565 | -100.6940008 | 2022-01-22 04:21:13 | Jones, South Dakota, US | |
3427064 | 3427064 | 2022-01-21 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-22 04:21:13 | Rock, Nebraska, US | |
1962672 | 1962672 | 2022-01-20 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-21 04:21:09 | Rock, Nebraska, US | |
3228567 | 3228567 | 2022-01-19 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-20 04:21:07 | Rock, Nebraska, US | |
3466292 | 3466292 | 2022-01-18 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-19 04:21:23 | Rock, Nebraska, US | |
1474231 | 1474231 | 2022-01-17 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-18 04:21:04 | Rock, Nebraska, US | |
556905 | 556905 | 2022-01-16 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-17 04:21:08 | Rock, Nebraska, US | |
3842626 | 3842626 | 2022-01-15 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-16 04:21:12 | Rock, Nebraska, US | |
101441 | 101441 | 2022-01-14 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-15 04:21:07 | Rock, Nebraska, US | |
3689596 | 3689596 | 2022-01-13 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-14 04:21:54 | Rock, Nebraska, US | |
3615180 | 3615180 | 2022-01-12 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-13 08:00:09 | Rock, Nebraska, US | |
1115705 | 1115705 | 2022-01-11 | US | Nebraska | Rock | 31149 | 163 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-01-12 04:21:44 | Rock, Nebraska, US | |
1392758 | 1392758 | 2022-01-07 | US | Texas | Glasscock | 48173 | 163 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-01-08 04:21:53 | Glasscock, Texas, US | |
2613190 | 2613190 | 2022-01-06 | US | Texas | Kent | 48263 | 163 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-01-07 04:22:09 | Kent, Texas, US | |
2613145 | 2613145 | 2022-01-06 | US | Texas | Glasscock | 48173 | 163 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-01-07 04:22:09 | Glasscock, Texas, US | |
2610686 | 2610686 | 2022-01-06 | US | Colorado | Mineral | 8079 | 163 | 1 | 0 | 37.66954283 | -106.92816979999999 | 2022-01-07 04:22:09 | Mineral, Colorado, US | |
2089980 | 2089980 | 2021-12-14 | US | Montana | Judith Basin | 30045 | 163 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2021-12-15 03:22:16 | Judith Basin, Montana, US | |
785479 | 785479 | 2021-12-13 | US | Texas | Foard | 48155 | 163 | 10 | 0 | 33.97308618 | -99.7767797 | 2021-12-14 04:22:38 | Foard, Texas, US | |
784397 | 784397 | 2021-12-13 | US | Montana | Judith Basin | 30045 | 163 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2021-12-14 04:22:38 | Judith Basin, Montana, US | |
1663514 | 1663514 | 2021-12-12 | US | Texas | Foard | 48155 | 163 | 10 | 0 | 33.97308618 | -99.7767797 | 2021-12-13 04:22:02 | Foard, Texas, US | |
1662432 | 1662432 | 2021-12-12 | US | Montana | Judith Basin | 30045 | 163 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2021-12-13 04:22:02 | Judith Basin, Montana, US | |
1667530 | 1667530 | 2021-12-11 | US | Texas | Foard | 48155 | 163 | 10 | 0 | 33.97308618 | -99.7767797 | 2021-12-12 04:22:12 | Foard, 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]);