johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,137 rows where confirmed = 220 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 1,072
- China 20
- Canada 9
- Mongolia 9
- Japan 5
- Russia 5
- Denmark 2
- Ukraine 2
- United Kingdom 2
- Colombia 1
- Congo (Brazzaville) 1
- Eswatini 1
- Iceland 1
- India 1
- Liechtenstein 1
- Malaysia 1
- Paraguay 1
- Saint Lucia 1
- Sao Tome and Principe 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756050 | 2756050 | 2022-12-29 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-30 04:21:04 | Kent, Texas, US | |
2753568 | 2753568 | 2022-12-29 | US | Colorado | Unassigned | 90008 | 220 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Colorado, US | |
1077056 | 1077056 | 2022-12-28 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-29 04:21:01 | Kent, Texas, US | |
1074574 | 1074574 | 2022-12-28 | US | Colorado | Unassigned | 90008 | 220 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Colorado, US | |
331053 | 331053 | 2022-12-27 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-28 04:21:04 | Kent, Texas, US | |
221126 | 221126 | 2022-12-26 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-27 04:21:07 | Kent, Texas, US | |
3225583 | 3225583 | 2022-12-25 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-26 04:21:06 | Kent, Texas, US | |
1021497 | 1021497 | 2022-12-24 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-25 04:21:04 | Kent, Texas, US | |
693520 | 693520 | 2022-12-23 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-24 04:21:02 | Kent, Texas, US | |
2182730 | 2182730 | 2022-12-22 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-23 04:21:04 | Kent, Texas, US | |
454534 | 454534 | 2022-12-21 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-22 04:20:56 | Kent, Texas, US | |
2954533 | 2954533 | 2022-12-20 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-21 04:21:03 | Kent, Texas, US | |
3176935 | 3176935 | 2022-12-19 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-20 04:21:04 | Kent, Texas, US | |
1631452 | 1631452 | 2022-12-18 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-19 04:21:03 | Kent, Texas, US | |
506831 | 506831 | 2022-12-17 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-18 04:21:03 | Kent, Texas, US | |
3327403 | 3327403 | 2022-12-16 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-17 04:21:04 | Kent, Texas, US | |
545915 | 545915 | 2022-12-15 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-16 04:21:01 | Kent, Texas, US | |
351443 | 351443 | 2022-12-14 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-15 04:20:58 | Kent, Texas, US | |
311031 | 311031 | 2022-12-13 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-14 04:21:04 | Kent, Texas, US | |
1152092 | 1152092 | 2022-12-12 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-13 04:21:01 | Kent, Texas, US | |
871946 | 871946 | 2022-12-11 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-12 04:21:01 | Kent, Texas, US | |
260476 | 260476 | 2022-12-10 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-11 04:20:50 | Kent, Texas, US | |
3939190 | 3939190 | 2022-12-09 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-10 04:21:02 | Kent, Texas, US | |
3380522 | 3380522 | 2022-12-08 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-09 04:21:05 | Kent, Texas, US | |
1987793 | 1987793 | 2022-12-07 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-08 04:21:07 | Kent, Texas, US | |
3717316 | 3717316 | 2022-12-06 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-07 04:20:58 | Kent, Texas, US | |
2418021 | 2418021 | 2022-12-05 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-06 04:21:03 | Kent, Texas, US | |
721629 | 721629 | 2022-12-04 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-05 04:20:58 | Kent, Texas, US | |
2819918 | 2819918 | 2022-12-03 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-04 04:20:56 | Kent, Texas, US | |
836774 | 836774 | 2022-12-02 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-03 04:21:02 | Kent, Texas, US | |
2139304 | 2139304 | 2022-12-01 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-02 04:21:07 | Kent, Texas, US | |
1967720 | 1967720 | 2022-11-30 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-12-01 04:21:03 | Kent, Texas, US | |
2559734 | 2559734 | 2022-11-29 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-30 04:21:07 | Kent, Texas, US | |
1242808 | 1242808 | 2022-11-28 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-29 04:21:05 | Kent, Texas, US | |
3554796 | 3554796 | 2022-11-27 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-28 04:21:02 | Kent, Texas, US | |
2103276 | 2103276 | 2022-11-26 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-27 04:21:05 | Kent, Texas, US | |
490767 | 490767 | 2022-11-25 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-26 04:21:11 | Kent, Texas, US | |
3526596 | 3526596 | 2022-11-24 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-25 04:21:06 | Kent, Texas, US | |
3315379 | 3315379 | 2022-11-23 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-24 04:21:09 | Kent, Texas, US | |
1623420 | 1623420 | 2022-11-22 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-23 04:21:06 | Kent, Texas, US | |
3463308 | 3463308 | 2022-11-21 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-22 04:20:47 | Kent, Texas, US | |
1643493 | 1643493 | 2022-11-20 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-21 04:21:05 | Kent, Texas, US | |
2067050 | 2067050 | 2022-11-19 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-20 04:21:08 | Kent, Texas, US | |
1758444 | 1758444 | 2022-11-18 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-19 04:21:14 | Kent, Texas, US | |
3029437 | 3029437 | 2022-11-17 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-18 04:21:15 | Kent, Texas, US | |
2489148 | 2489148 | 2022-11-16 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-17 04:21:11 | Kent, Texas, US | |
295159 | 295159 | 2022-11-15 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-16 04:21:09 | Kent, Texas, US | |
3600189 | 3600189 | 2022-11-14 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-15 04:21:16 | Kent, Texas, US | |
315047 | 315047 | 2022-11-13 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-14 04:21:09 | Kent, Texas, US | |
66208 | 66208 | 2022-11-12 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-13 04:21:14 | Kent, Texas, US | |
2930370 | 2930370 | 2022-11-11 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-12 04:20:41 | Kent, Texas, US | |
2509206 | 2509206 | 2022-11-10 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-11 04:21:22 | Kent, Texas, US | |
2434081 | 2434081 | 2022-11-09 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-10 04:21:16 | Kent, Texas, US | |
482737 | 482737 | 2022-11-08 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-09 04:21:22 | Kent, Texas, US | |
2441887 | 2441887 | 2022-11-07 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-08 04:21:21 | Kent, Texas, US | |
1052985 | 1052985 | 2022-11-06 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-07 04:21:26 | Kent, Texas, US | |
621009 | 621009 | 2022-11-05 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-06 04:21:24 | Kent, Texas, US | |
1025513 | 1025513 | 2022-11-04 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-05 04:21:52 | Kent, Texas, US | |
434504 | 434504 | 2022-11-03 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-04 04:22:11 | Kent, Texas, US | |
852746 | 852746 | 2022-11-02 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-03 04:22:05 | Kent, Texas, US | |
849403 | 849403 | 2022-11-02 | China | Ningxia | 220 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-03 04:22:05 | Ningxia, China | |||
713597 | 713597 | 2022-11-01 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-02 04:22:09 | Kent, Texas, US | |
3288046 | 3288046 | 2022-10-31 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-11-01 04:22:36 | Kent, Texas, US | |
323079 | 323079 | 2022-10-30 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-31 04:21:36 | Kent, Texas, US | |
915355 | 915355 | 2022-10-29 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-30 04:22:14 | Kent, Texas, US | |
1369624 | 1369624 | 2022-10-28 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-29 04:21:13 | Kent, Texas, US | |
3041479 | 3041479 | 2022-10-27 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-28 04:22:31 | Kent, Texas, US | |
541899 | 541899 | 2022-10-26 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-27 04:22:01 | Kent, Texas, US | |
1833300 | 1833300 | 2022-10-25 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-26 04:22:19 | Kent, Texas, US | |
797561 | 797561 | 2022-10-24 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-25 04:21:53 | Kent, Texas, US | |
3280016 | 3280016 | 2022-10-23 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-24 04:22:29 | Kent, Texas, US | |
2271054 | 2271054 | 2022-10-22 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-23 04:22:46 | Kent, Texas, US | |
1595354 | 1595354 | 2022-10-21 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-22 04:22:53 | Kent, Texas, US | |
2275070 | 2275070 | 2022-10-20 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-21 04:22:23 | Kent, Texas, US | |
201405 | 201405 | 2022-10-19 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-20 04:22:59 | Kent, Texas, US | |
2760066 | 2760066 | 2022-10-18 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-19 04:22:26 | Kent, Texas, US | |
2027900 | 2027900 | 2022-10-17 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-18 04:22:42 | Kent, Texas, US | |
2162678 | 2162678 | 2022-10-16 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-17 04:20:31 | Kent, Texas, US | |
518875 | 518875 | 2022-10-15 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-16 04:22:39 | Kent, Texas, US | |
2035932 | 2035932 | 2022-10-14 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-15 04:22:00 | Kent, Texas, US | |
3756620 | 3756620 | 2022-10-13 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-14 04:22:28 | Kent, Texas, US | |
3217445 | 3217445 | 2022-10-12 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-13 04:22:39 | Kent, Texas, US | |
3253294 | 3253294 | 2022-10-11 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-12 04:22:51 | Kent, Texas, US | |
2970553 | 2970553 | 2022-10-10 | US | Texas | Kent | 48263 | 220 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-11 04:23:05 | Kent, Texas, US | |
3824244 | 3824244 | 2022-09-10 | China | Guizhou | 220 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-11 04:20:50 | Guizhou, China | |||
3744916 | 3744916 | 2022-09-07 | China | Qinghai | 220 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-08 04:21:02 | Qinghai, China | |||
2636822 | 2636822 | 2022-09-05 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-06 04:21:02 | Glasscock, Texas, US | |
2990386 | 2990386 | 2022-09-04 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-05 04:21:01 | Glasscock, Texas, US | |
2716071 | 2716071 | 2022-09-03 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-04 04:21:22 | Glasscock, Texas, US | |
1396776 | 1396776 | 2022-09-02 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-03 04:21:04 | Glasscock, Texas, US | |
3550605 | 3550605 | 2022-09-01 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-02 04:21:07 | Glasscock, Texas, US | |
2346525 | 2346525 | 2022-08-31 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-01 04:21:03 | Glasscock, Texas, US | |
3777005 | 3777005 | 2022-08-30 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-31 04:20:57 | Glasscock, Texas, US | |
1683601 | 1683601 | 2022-08-29 | US | Texas | Glasscock | 48173 | 220 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-30 04:21:03 | Glasscock, Texas, US | |
1214642 | 1214642 | 2022-07-11 | US | Texas | Foard | 48155 | 220 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-12 04:20:51 | Foard, Texas, US | |
2792124 | 2792124 | 2022-07-10 | US | Texas | Foard | 48155 | 220 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-11 04:20:46 | Foard, Texas, US | |
145077 | 145077 | 2022-07-09 | US | Texas | Foard | 48155 | 220 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-10 04:20:54 | Foard, Texas, US | |
1766490 | 1766490 | 2022-06-20 | US | Texas | Loving | 48301 | 220 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-21 04:20:56 | Loving, Texas, US | |
160019 | 160019 | 2022-03-29 | US | Montana | Judith Basin | 30045 | 220 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-30 04:20:45 | Judith Basin, Montana, US | |
1438590 | 1438590 | 2022-03-28 | US | Montana | Judith Basin | 30045 | 220 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-29 04:20:46 | Judith Basin, Montana, 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]);