johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
787 rows where confirmed = 501 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954464 | 2954464 | 2022-12-20 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-21 04:21:03 | Dickens, Texas, US | |
3176866 | 3176866 | 2022-12-19 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-20 04:21:04 | Dickens, Texas, US | |
1631383 | 1631383 | 2022-12-18 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-19 04:21:03 | Dickens, Texas, US | |
506762 | 506762 | 2022-12-17 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-18 04:21:03 | Dickens, Texas, US | |
3327334 | 3327334 | 2022-12-16 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-17 04:21:04 | Dickens, Texas, US | |
545846 | 545846 | 2022-12-15 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-16 04:21:01 | Dickens, Texas, US | |
351374 | 351374 | 2022-12-14 | US | Texas | Dickens | 48125 | 501 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-12-15 04:20:58 | Dickens, Texas, US | |
310626 | 310626 | 2022-12-13 | US | Puerto Rico | Culebra | 72049 | 501 | 0 | 0 | 18.31586 | -65.28813 | 2022-12-14 04:21:04 | Culebra, Puerto Rico, US | |
1151687 | 1151687 | 2022-12-12 | US | Puerto Rico | Culebra | 72049 | 501 | 0 | 0 | 18.31586 | -65.28813 | 2022-12-13 04:21:01 | Culebra, Puerto Rico, US | |
871541 | 871541 | 2022-12-11 | US | Puerto Rico | Culebra | 72049 | 501 | 0 | 0 | 18.31586 | -65.28813 | 2022-12-12 04:21:01 | Culebra, Puerto Rico, US | |
3314638 | 3314638 | 2022-11-23 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-24 04:21:09 | Golden Valley, North Dakota, US | |
1622679 | 1622679 | 2022-11-22 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-23 04:21:06 | Golden Valley, North Dakota, US | |
3462567 | 3462567 | 2022-11-21 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-22 04:20:47 | Golden Valley, North Dakota, US | |
1642752 | 1642752 | 2022-11-20 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-21 04:21:05 | Golden Valley, North Dakota, US | |
2066309 | 2066309 | 2022-11-19 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-20 04:21:08 | Golden Valley, North Dakota, US | |
1757703 | 1757703 | 2022-11-18 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-19 04:21:14 | Golden Valley, North Dakota, US | |
3028696 | 3028696 | 2022-11-17 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-18 04:21:15 | Golden Valley, North Dakota, US | |
2488407 | 2488407 | 2022-11-16 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-17 04:21:11 | Golden Valley, North Dakota, US | |
294418 | 294418 | 2022-11-15 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-16 04:21:09 | Golden Valley, North Dakota, US | |
3599448 | 3599448 | 2022-11-14 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-15 04:21:16 | Golden Valley, North Dakota, US | |
314306 | 314306 | 2022-11-13 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-14 04:21:09 | Golden Valley, North Dakota, US | |
65467 | 65467 | 2022-11-12 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-13 04:21:14 | Golden Valley, North Dakota, US | |
2929629 | 2929629 | 2022-11-11 | US | North Dakota | Golden Valley | 38033 | 501 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-12 04:20:41 | Golden Valley, North Dakota, US | |
133627 | 133627 | 2022-10-04 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-05 04:23:06 | Haakon, South Dakota, US | |
2688574 | 2688574 | 2022-10-03 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-04 04:22:55 | Haakon, South Dakota, US | |
2262641 | 2262641 | 2022-10-02 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-03 04:23:11 | Haakon, South Dakota, US | |
2998167 | 2998167 | 2022-10-01 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-02 04:21:23 | Haakon, South Dakota, US | |
856493 | 856493 | 2022-09-30 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-10-01 04:23:01 | Haakon, South Dakota, US | |
2378419 | 2378419 | 2022-09-29 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-30 04:23:09 | Haakon, South Dakota, US | |
1562970 | 1562970 | 2022-09-28 | US | South Dakota | Haakon | 46055 | 501 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-29 04:22:34 | Haakon, South Dakota, US | |
1891554 | 1891554 | 2022-09-14 | US | North Dakota | Logan | 38047 | 501 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-09-15 04:21:02 | Logan, North Dakota, US | |
374609 | 374609 | 2022-09-13 | US | North Dakota | Logan | 38047 | 501 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-09-14 04:20:44 | Logan, North Dakota, US | |
1683537 | 1683537 | 2022-08-29 | US | Texas | Briscoe | 48045 | 501 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-30 04:21:03 | Briscoe, Texas, US | |
1682907 | 1682907 | 2022-08-29 | US | North Dakota | Grant | 38037 | 501 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-08-30 04:21:03 | Grant, North Dakota, US | |
1880021 | 1880021 | 2022-08-28 | US | Texas | Briscoe | 48045 | 501 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-29 04:21:06 | Briscoe, Texas, US | |
2099148 | 2099148 | 2022-08-27 | US | Texas | Briscoe | 48045 | 501 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-28 04:21:02 | Briscoe, Texas, US | |
1534963 | 1534963 | 2022-08-26 | US | Texas | Briscoe | 48045 | 501 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-27 04:20:57 | Briscoe, Texas, US | |
2831850 | 2831850 | 2022-08-25 | US | Texas | Briscoe | 48045 | 501 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-26 04:21:02 | Briscoe, Texas, US | |
3213412 | 3213412 | 2022-07-18 | US | Texas | Irion | 48235 | 501 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-19 04:20:58 | Irion, Texas, US | |
3213363 | 3213363 | 2022-07-18 | US | Texas | Edwards | 48137 | 501 | 11 | 0 | 29.98202582 | -100.304252 | 2022-07-19 04:20:58 | Edwards, Texas, US | |
3431363 | 3431363 | 2022-07-14 | US | North Dakota | Divide | 38023 | 501 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-07-15 04:20:53 | Divide, North Dakota, US | |
942040 | 942040 | 2022-06-25 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-26 04:21:02 | Sherman, Texas, US | |
3349860 | 3349860 | 2022-06-24 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-25 04:20:57 | Sherman, Texas, US | |
1651601 | 1651601 | 2022-06-23 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-24 04:20:58 | Sherman, Texas, US | |
2190836 | 2190836 | 2022-06-22 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-23 04:20:55 | Sherman, Texas, US | |
169267 | 169267 | 2022-06-21 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-22 04:20:54 | Sherman, Texas, US | |
1766550 | 1766550 | 2022-06-20 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-21 04:20:56 | Sherman, Texas, US | |
3272736 | 3272736 | 2022-06-19 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-20 04:21:01 | Sherman, Texas, US | |
3400648 | 3400648 | 2022-06-18 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-19 04:20:51 | Sherman, Texas, US | |
2314525 | 2314525 | 2022-06-17 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-18 04:21:10 | Sherman, Texas, US | |
562029 | 562029 | 2022-06-16 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-17 04:20:56 | Sherman, Texas, US | |
3985831 | 3985831 | 2022-06-15 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-16 04:20:55 | Sherman, Texas, US | |
950072 | 950072 | 2022-06-14 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-15 04:20:54 | Sherman, Texas, US | |
948212 | 948212 | 2022-06-14 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-15 04:20:54 | Wichita, Kansas, US | |
947508 | 947508 | 2022-06-14 | US | Colorado | Sedgwick | 8115 | 501 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-15 04:20:54 | Sedgwick, Colorado, US | |
2982480 | 2982480 | 2022-06-13 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-14 04:20:52 | Sherman, Texas, US | |
2980620 | 2980620 | 2022-06-13 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-14 04:20:52 | Wichita, Kansas, US | |
2979916 | 2979916 | 2022-06-13 | US | Colorado | Sedgwick | 8115 | 501 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-14 04:20:52 | Sedgwick, Colorado, US | |
2238606 | 2238606 | 2022-06-12 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-13 04:21:14 | Sherman, Texas, US | |
2236746 | 2236746 | 2022-06-12 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-13 04:21:14 | Wichita, Kansas, US | |
2236042 | 2236042 | 2022-06-12 | US | Colorado | Sedgwick | 8115 | 501 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-13 04:21:14 | Sedgwick, Colorado, US | |
3144804 | 3144804 | 2022-06-11 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-12 04:20:53 | Sherman, Texas, US | |
3142944 | 3142944 | 2022-06-11 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-12 04:20:53 | Wichita, Kansas, US | |
3142240 | 3142240 | 2022-06-11 | US | Colorado | Sedgwick | 8115 | 501 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-12 04:20:53 | Sedgwick, Colorado, US | |
1947720 | 1947720 | 2022-06-10 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-11 04:21:01 | Sherman, Texas, US | |
1945860 | 1945860 | 2022-06-10 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-11 04:21:01 | Wichita, Kansas, US | |
3160859 | 3160859 | 2022-06-09 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-10 04:20:55 | Sherman, Texas, US | |
3158999 | 3158999 | 2022-06-09 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-10 04:20:55 | Wichita, Kansas, US | |
1424326 | 1424326 | 2022-06-08 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-09 04:20:54 | Sherman, Texas, US | |
1422466 | 1422466 | 2022-06-08 | US | Kansas | Wichita | 20203 | 501 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-09 04:20:54 | Wichita, Kansas, US | |
3729440 | 3729440 | 2022-06-07 | US | Texas | Sherman | 48421 | 501 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-06-08 04:20:55 | Sherman, Texas, US | |
3321511 | 3321511 | 2022-04-07 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-08 04:20:48 | Clark, Kansas, US | |
2802047 | 2802047 | 2022-04-06 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-07 04:20:53 | Clark, Kansas, US | |
3868816 | 3868816 | 2022-04-05 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-06 04:20:49 | Clark, Kansas, US | |
2750158 | 2750158 | 2022-04-04 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-05 04:20:48 | Clark, Kansas, US | |
3731504 | 3731504 | 2022-04-03 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-04 04:20:51 | Clark, Kansas, US | |
500939 | 500939 | 2022-04-02 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-03 04:20:48 | Clark, Kansas, US | |
3351924 | 3351924 | 2022-04-01 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-02 04:20:47 | Clark, Kansas, US | |
1541229 | 1541229 | 2022-03-31 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-04-01 04:20:28 | Clark, Kansas, US | |
2479242 | 2479242 | 2022-03-30 | US | Kansas | Clark | 20025 | 501 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-03-31 04:20:56 | Clark, Kansas, US | |
159283 | 159283 | 2022-03-29 | US | Kansas | Clark | 20025 | 501 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-30 04:20:45 | Clark, Kansas, US | |
1437854 | 1437854 | 2022-03-28 | US | Kansas | Clark | 20025 | 501 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-29 04:20:46 | Clark, Kansas, US | |
877535 | 877535 | 2022-03-27 | US | Kansas | Clark | 20025 | 501 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-28 04:20:33 | Clark, Kansas, US | |
2164818 | 2164818 | 2022-03-26 | US | Kansas | Clark | 20025 | 501 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-27 04:20:47 | Clark, Kansas, US | |
1721754 | 1721754 | 2022-03-25 | US | Kansas | Clark | 20025 | 501 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-26 04:20:23 | Clark, Kansas, US | |
338343 | 338343 | 2022-03-18 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-19 04:20:47 | Kidder, North Dakota, US | |
696796 | 696796 | 2022-03-17 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-18 04:20:55 | Kidder, North Dakota, US | |
2321739 | 2321739 | 2022-03-16 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-17 04:20:56 | Kidder, North Dakota, US | |
263939 | 263939 | 2022-03-15 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-16 04:20:50 | Kidder, North Dakota, US | |
2266298 | 2266298 | 2022-03-14 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-15 04:20:47 | Kidder, North Dakota, US | |
3630364 | 3630364 | 2022-03-13 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-14 04:20:46 | Kidder, North Dakota, US | |
953272 | 953272 | 2022-03-12 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-13 04:20:49 | Kidder, North Dakota, US | |
358733 | 358733 | 2022-03-11 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-12 04:20:50 | Kidder, North Dakota, US | |
1867885 | 1867885 | 2022-03-10 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-11 04:20:50 | Kidder, North Dakota, US | |
2142580 | 2142580 | 2022-03-09 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-10 04:20:48 | Kidder, North Dakota, US | |
922091 | 922091 | 2022-03-08 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-09 04:20:59 | Kidder, North Dakota, US | |
1550378 | 1550378 | 2022-03-07 | US | North Dakota | Kidder | 38043 | 501 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-03-08 04:20:54 | Kidder, North Dakota, US | |
2202401 | 2202401 | 2022-03-06 | US | Puerto Rico | Maricao | 72093 | 501 | 0 | 0 | 18.171795 | -66.942126 | 2022-03-07 04:20:47 | Maricao, Puerto Rico, US | |
2094858 | 2094858 | 2022-03-05 | US | Puerto Rico | Maricao | 72093 | 501 | 0 | 0 | 18.171795 | -66.942126 | 2022-03-06 04:20:49 | Maricao, Puerto Rico, US | |
2668558 | 2668558 | 2022-03-04 | US | Puerto Rico | Maricao | 72093 | 501 | 0 | 0 | 18.171795 | -66.942126 | 2022-03-05 04:21:10 | Maricao, Puerto Rico, 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]);