johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
715 rows where confirmed = 504 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309241 | 309241 | 2022-12-13 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-14 04:21:04 | Stanton, Kansas, US | |
1150302 | 1150302 | 2022-12-12 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-13 04:21:01 | Stanton, Kansas, US | |
870156 | 870156 | 2022-12-11 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-12 04:21:01 | Stanton, Kansas, US | |
258686 | 258686 | 2022-12-10 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-11 04:20:50 | Stanton, Kansas, US | |
3937400 | 3937400 | 2022-12-09 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-10 04:21:02 | Stanton, Kansas, US | |
3379781 | 3379781 | 2022-12-08 | US | North Dakota | Golden Valley | 38033 | 504 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-12-09 04:21:05 | Golden Valley, North Dakota, US | |
3378732 | 3378732 | 2022-12-08 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-09 04:21:05 | Stanton, Kansas, US | |
1987052 | 1987052 | 2022-12-07 | US | North Dakota | Golden Valley | 38033 | 504 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-12-08 04:21:07 | Golden Valley, North Dakota, US | |
1986003 | 1986003 | 2022-12-07 | US | Kansas | Stanton | 20187 | 504 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-08 04:21:07 | Stanton, Kansas, US | |
3716575 | 3716575 | 2022-12-06 | US | North Dakota | Golden Valley | 38033 | 504 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-12-07 04:20:58 | Golden Valley, North Dakota, US | |
1833049 | 1833049 | 2022-10-25 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-26 04:22:19 | McPherson, South Dakota, US | |
797310 | 797310 | 2022-10-24 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-25 04:21:53 | McPherson, South Dakota, US | |
3279765 | 3279765 | 2022-10-23 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-24 04:22:29 | McPherson, South Dakota, US | |
2270803 | 2270803 | 2022-10-22 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-23 04:22:46 | McPherson, South Dakota, US | |
1595103 | 1595103 | 2022-10-21 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-22 04:22:53 | McPherson, South Dakota, US | |
2274819 | 2274819 | 2022-10-20 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-21 04:22:23 | McPherson, South Dakota, US | |
201154 | 201154 | 2022-10-19 | US | South Dakota | McPherson | 46089 | 504 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-20 04:22:59 | McPherson, South Dakota, US | |
3253025 | 3253025 | 2022-10-11 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-12 04:22:51 | Haakon, South Dakota, US | |
2970284 | 2970284 | 2022-10-10 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-11 04:23:05 | Haakon, South Dakota, US | |
3100320 | 3100320 | 2022-10-09 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-10 04:22:32 | Haakon, South Dakota, US | |
4005545 | 4005545 | 2022-10-08 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-09 04:21:16 | Haakon, South Dakota, US | |
399142 | 399142 | 2022-10-07 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-08 04:22:56 | Haakon, South Dakota, US | |
2532259 | 2532259 | 2022-10-06 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-07 04:23:08 | Haakon, South Dakota, US | |
1813653 | 1813653 | 2022-10-05 | US | South Dakota | Haakon | 46055 | 504 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-06 04:21:22 | Haakon, South Dakota, US | |
3748146 | 3748146 | 2022-09-07 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-08 04:21:02 | Briscoe, Texas, US | |
117786 | 117786 | 2022-09-06 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-07 04:20:59 | Briscoe, Texas, US | |
115653 | 115653 | 2022-09-06 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-07 04:20:59 | Webster, Georgia, US | |
2636758 | 2636758 | 2022-09-05 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-06 04:21:02 | Briscoe, Texas, US | |
2634625 | 2634625 | 2022-09-05 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-06 04:21:02 | Webster, Georgia, US | |
2990322 | 2990322 | 2022-09-04 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-05 04:21:01 | Briscoe, Texas, US | |
2988189 | 2988189 | 2022-09-04 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-05 04:21:01 | Webster, Georgia, US | |
2716007 | 2716007 | 2022-09-03 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-04 04:21:22 | Briscoe, Texas, US | |
2713874 | 2713874 | 2022-09-03 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-04 04:21:22 | Webster, Georgia, US | |
1396712 | 1396712 | 2022-09-02 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-03 04:21:04 | Briscoe, Texas, US | |
1394579 | 1394579 | 2022-09-02 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-03 04:21:04 | Webster, Georgia, US | |
3550541 | 3550541 | 2022-09-01 | US | Texas | Briscoe | 48045 | 504 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-09-02 04:21:07 | Briscoe, Texas, US | |
3548408 | 3548408 | 2022-09-01 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-02 04:21:07 | Webster, Georgia, US | |
2344328 | 2344328 | 2022-08-31 | US | Georgia | Webster | 13307 | 504 | 9 | 0 | 32.04066113 | -84.54742852 | 2022-09-01 04:21:03 | Webster, Georgia, US | |
2338477 | 2338477 | 2022-07-27 | US | Texas | Edwards | 48137 | 504 | 11 | 0 | 29.98202582 | -100.304252 | 2022-07-28 04:20:56 | Edwards, Texas, US | |
671228 | 671228 | 2022-07-21 | US | Idaho | Butte | 16023 | 504 | 11 | 0 | 43.72592209 | -113.1735463 | 2022-07-22 04:21:15 | Butte, Idaho, US | |
1609191 | 1609191 | 2022-07-20 | US | Idaho | Butte | 16023 | 504 | 11 | 0 | 43.72592209 | -113.1735463 | 2022-07-21 04:21:10 | Butte, Idaho, US | |
3407855 | 3407855 | 2022-07-17 | US | North Dakota | Divide | 38023 | 504 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-07-18 04:20:59 | Divide, North Dakota, US | |
2154055 | 2154055 | 2022-07-16 | US | North Dakota | Divide | 38023 | 504 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-07-17 04:21:15 | Divide, North Dakota, US | |
2421288 | 2421288 | 2022-07-15 | US | North Dakota | Divide | 38023 | 504 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-07-16 04:21:05 | Divide, North Dakota, US | |
3432188 | 3432188 | 2022-07-14 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-15 04:20:53 | Sherman, Texas, US | |
3112708 | 3112708 | 2022-07-13 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-14 04:20:57 | Sherman, Texas, US | |
633131 | 633131 | 2022-07-12 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-13 04:20:58 | Sherman, Texas, US | |
1214775 | 1214775 | 2022-07-11 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-12 04:20:51 | Sherman, Texas, US | |
2792257 | 2792257 | 2022-07-10 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-11 04:20:46 | Sherman, Texas, US | |
145210 | 145210 | 2022-07-09 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-10 04:20:54 | Sherman, Texas, US | |
1420310 | 1420310 | 2022-07-08 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-09 04:20:59 | Sherman, Texas, US | |
2744235 | 2744235 | 2022-07-07 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-08 04:20:56 | Sherman, Texas, US | |
1203030 | 1203030 | 2022-07-06 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-07 04:20:55 | Sherman, Texas, US | |
3969773 | 3969773 | 2022-07-05 | US | Texas | Sherman | 48421 | 504 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-07-06 04:20:58 | Sherman, Texas, US | |
2240762 | 2240762 | 2022-06-28 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-29 04:20:59 | Wichita, Kansas, US | |
2240058 | 2240058 | 2022-06-28 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-29 04:20:59 | Sedgwick, Colorado, US | |
2149004 | 2149004 | 2022-06-27 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-28 04:20:58 | Wichita, Kansas, US | |
2148300 | 2148300 | 2022-06-27 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-28 04:20:58 | Sedgwick, Colorado, US | |
476805 | 476805 | 2022-06-26 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-27 04:21:00 | Wichita, Kansas, US | |
476101 | 476101 | 2022-06-26 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-27 04:21:00 | Sedgwick, Colorado, US | |
940180 | 940180 | 2022-06-25 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-26 04:21:02 | Wichita, Kansas, US | |
939476 | 939476 | 2022-06-25 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-26 04:21:02 | Sedgwick, Colorado, US | |
3348000 | 3348000 | 2022-06-24 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-25 04:20:57 | Wichita, Kansas, US | |
3347296 | 3347296 | 2022-06-24 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-25 04:20:57 | Sedgwick, Colorado, US | |
1649741 | 1649741 | 2022-06-23 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-24 04:20:58 | Wichita, Kansas, US | |
1649037 | 1649037 | 2022-06-23 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-24 04:20:58 | Sedgwick, Colorado, US | |
2188976 | 2188976 | 2022-06-22 | US | Kansas | Wichita | 20203 | 504 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-23 04:20:55 | Wichita, Kansas, US | |
2188272 | 2188272 | 2022-06-22 | US | Colorado | Sedgwick | 8115 | 504 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-23 04:20:55 | Sedgwick, Colorado, US | |
3727489 | 3727489 | 2022-06-07 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-08 04:20:55 | Clark, Kansas, US | |
3888891 | 3888891 | 2022-06-06 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-07 04:21:08 | Clark, Kansas, US | |
3508660 | 3508660 | 2022-06-05 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-06 04:20:57 | Clark, Kansas, US | |
3528737 | 3528737 | 2022-06-04 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-05 04:20:55 | Clark, Kansas, US | |
3134823 | 3134823 | 2022-06-03 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-04 04:20:58 | Clark, Kansas, US | |
3579898 | 3579898 | 2022-06-02 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-03 04:20:58 | Clark, Kansas, US | |
972191 | 972191 | 2022-06-01 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-02 05:20:39 | Clark, Kansas, US | |
230498 | 230498 | 2022-05-31 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-06-01 04:20:55 | Clark, Kansas, US | |
3187263 | 3187263 | 2022-05-30 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-31 04:20:51 | Clark, Kansas, US | |
3199412 | 3199412 | 2022-05-29 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-30 04:20:50 | Clark, Kansas, US | |
2726290 | 2726290 | 2022-05-28 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-29 04:20:53 | Clark, Kansas, US | |
1315471 | 1315471 | 2022-05-27 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-28 04:21:07 | Clark, Kansas, US | |
1851263 | 1851263 | 2022-05-26 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-27 04:20:56 | Clark, Kansas, US | |
2049139 | 2049139 | 2022-05-25 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-26 04:20:50 | Clark, Kansas, US | |
3000577 | 3000577 | 2022-05-24 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-25 04:20:56 | Clark, Kansas, US | |
3594298 | 3594298 | 2022-05-23 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-24 04:20:57 | Clark, Kansas, US | |
623150 | 623150 | 2022-05-22 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-26 04:20:50 | Clark, Kansas, US | |
1110846 | 1110846 | 2022-05-21 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-22 04:20:52 | Clark, Kansas, US | |
1170470 | 1170470 | 2022-05-20 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-21 04:20:58 | Clark, Kansas, US | |
3897233 | 3897233 | 2022-05-19 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-20 04:20:57 | Clark, Kansas, US | |
1186017 | 1186017 | 2022-05-18 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-19 04:20:54 | Clark, Kansas, US | |
3583914 | 3583914 | 2022-05-17 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-18 04:20:50 | Clark, Kansas, US | |
1504871 | 1504871 | 2022-05-16 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-17 04:20:59 | Clark, Kansas, US | |
2085230 | 2085230 | 2022-05-15 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-16 04:20:47 | Clark, Kansas, US | |
3355940 | 3355940 | 2022-05-14 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-15 04:20:53 | Clark, Kansas, US | |
659585 | 659585 | 2022-05-13 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-14 04:20:48 | Clark, Kansas, US | |
2534668 | 2534668 | 2022-05-12 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-13 04:20:51 | Clark, Kansas, US | |
3446114 | 3446114 | 2022-05-11 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-12 04:20:54 | Clark, Kansas, US | |
3536731 | 3536731 | 2022-05-10 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-11 04:20:48 | Clark, Kansas, US | |
223266 | 223266 | 2022-05-09 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-10 04:20:50 | Clark, Kansas, US | |
2332651 | 2332651 | 2022-05-08 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-09 04:20:54 | Clark, Kansas, US | |
361613 | 361613 | 2022-05-07 | US | Kansas | Clark | 20025 | 504 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-05-08 04:20:49 | Clark, Kansas, 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]);