johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
where deaths = 531 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328733 | 328733 | 2022-12-27 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-28 04:21:04 | Houston, Georgia, US | |
218806 | 218806 | 2022-12-26 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-27 04:21:07 | Houston, Georgia, US | |
3223263 | 3223263 | 2022-12-25 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-26 04:21:06 | Houston, Georgia, US | |
1019177 | 1019177 | 2022-12-24 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-25 04:21:04 | Houston, Georgia, US | |
691200 | 691200 | 2022-12-23 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-24 04:21:02 | Houston, Georgia, US | |
2180410 | 2180410 | 2022-12-22 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-23 04:21:04 | Houston, Georgia, US | |
452214 | 452214 | 2022-12-21 | US | Georgia | Houston | 13153 | 47829 | 531 | 0 | 32.45802497 | -83.66879087 | 2022-12-22 04:20:56 | Houston, Georgia, US | |
348888 | 348888 | 2022-12-14 | US | California | Sonoma | 6097 | 115765 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-15 04:20:58 | Sonoma, California, US | |
308476 | 308476 | 2022-12-13 | US | California | Sonoma | 6097 | 115765 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-14 04:21:04 | Sonoma, California, US | |
1149537 | 1149537 | 2022-12-12 | US | California | Sonoma | 6097 | 115228 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-13 04:21:01 | Sonoma, California, US | |
869391 | 869391 | 2022-12-11 | US | California | Sonoma | 6097 | 115225 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-12 04:21:01 | Sonoma, California, US | |
868809 | 868809 | 2022-12-11 | Japan | Nagano | 337450 | 531 | 0 | 36.132134 | 138.045528 | 2022-12-12 04:21:01 | Nagano, Japan | |||
257921 | 257921 | 2022-12-10 | US | California | Sonoma | 6097 | 115225 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-11 04:20:50 | Sonoma, California, US | |
257339 | 257339 | 2022-12-10 | Japan | Nagano | 334878 | 531 | 0 | 36.132134 | 138.045528 | 2022-12-11 04:20:50 | Nagano, Japan | |||
3936635 | 3936635 | 2022-12-09 | US | California | Sonoma | 6097 | 115223 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-10 04:21:02 | Sonoma, California, US | |
3377967 | 3377967 | 2022-12-08 | US | California | Sonoma | 6097 | 115217 | 531 | 0 | 38.52746429 | -122.8862506 | 2022-12-09 04:21:05 | Sonoma, California, US | |
1985229 | 1985229 | 2022-12-07 | US | California | San Luis Obispo | 6079 | 71974 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-08 04:21:07 | San Luis Obispo, California, US | |
3717179 | 3717179 | 2022-12-06 | US | Tennessee | Washington | 47179 | 47169 | 531 | 0 | 36.29472368 | -82.4945472 | 2022-12-07 04:20:58 | Washington, Tennessee, US | |
3716861 | 3716861 | 2022-12-06 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-07 04:20:58 | Mercer, Pennsylvania, US | |
3714752 | 3714752 | 2022-12-06 | US | California | San Luis Obispo | 6079 | 71957 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-07 04:20:58 | San Luis Obispo, California, US | |
2417884 | 2417884 | 2022-12-05 | US | Tennessee | Washington | 47179 | 47139 | 531 | 0 | 36.29472368 | -82.4945472 | 2022-12-06 04:21:03 | Washington, Tennessee, US | |
2417566 | 2417566 | 2022-12-05 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-06 04:21:03 | Mercer, Pennsylvania, US | |
2415457 | 2415457 | 2022-12-05 | US | California | San Luis Obispo | 6079 | 71704 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-06 04:21:03 | San Luis Obispo, California, US | |
721492 | 721492 | 2022-12-04 | US | Tennessee | Washington | 47179 | 47113 | 531 | 0 | 36.29472368 | -82.4945472 | 2022-12-05 04:20:58 | Washington, Tennessee, US | |
721174 | 721174 | 2022-12-04 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-05 04:20:58 | Mercer, Pennsylvania, US | |
719065 | 719065 | 2022-12-04 | US | California | San Luis Obispo | 6079 | 71692 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-05 04:20:58 | San Luis Obispo, California, US | |
2819781 | 2819781 | 2022-12-03 | US | Tennessee | Washington | 47179 | 47103 | 531 | 0 | 36.29472368 | -82.4945472 | 2022-12-04 04:20:56 | Washington, Tennessee, US | |
2819463 | 2819463 | 2022-12-03 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-04 04:20:56 | Mercer, Pennsylvania, US | |
2817354 | 2817354 | 2022-12-03 | US | California | San Luis Obispo | 6079 | 71687 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-04 04:20:56 | San Luis Obispo, California, US | |
836637 | 836637 | 2022-12-02 | US | Tennessee | Washington | 47179 | 47090 | 531 | 0 | 36.29472368 | -82.4945472 | 2022-12-03 04:21:02 | Washington, Tennessee, US | |
836319 | 836319 | 2022-12-02 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-03 04:21:02 | Mercer, Pennsylvania, US | |
834210 | 834210 | 2022-12-02 | US | California | San Luis Obispo | 6079 | 71677 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-03 04:21:02 | San Luis Obispo, California, US | |
2138849 | 2138849 | 2022-12-01 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-02 04:21:07 | Mercer, Pennsylvania, US | |
2136740 | 2136740 | 2022-12-01 | US | California | San Luis Obispo | 6079 | 71664 | 531 | 0 | 35.38822029 | -120.4039028 | 2022-12-02 04:21:07 | San Luis Obispo, California, US | |
1967265 | 1967265 | 2022-11-30 | US | Pennsylvania | Mercer | 42085 | 27276 | 531 | 0 | 41.30248872 | -80.25816981 | 2022-12-01 04:21:03 | Mercer, Pennsylvania, US | |
1623840 | 1623840 | 2022-11-22 | US | Wisconsin | Marathon | 55073 | 47169 | 531 | 0 | 44.89792533 | -89.75863384 | 2022-11-23 04:21:06 | Marathon, Wisconsin, US | |
1622769 | 1622769 | 2022-11-22 | US | Ohio | Medina | 39103 | 48023 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-23 04:21:06 | Medina, Ohio, US | |
1622537 | 1622537 | 2022-11-22 | US | New York | Out of NY | 80036 | 0 | 531 | 0 | 44.74530905 | 0.0 | 2022-11-23 04:21:06 | Out of NY, New York, US | |
3463728 | 3463728 | 2022-11-21 | US | Wisconsin | Marathon | 55073 | 47132 | 531 | 0 | 44.89792533 | -89.75863384 | 2022-11-22 04:20:47 | Marathon, Wisconsin, US | |
3462657 | 3462657 | 2022-11-21 | US | Ohio | Medina | 39103 | 48023 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-22 04:20:47 | Medina, Ohio, US | |
1642842 | 1642842 | 2022-11-20 | US | Ohio | Medina | 39103 | 48023 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-21 04:21:05 | Medina, Ohio, US | |
2066399 | 2066399 | 2022-11-19 | US | Ohio | Medina | 39103 | 48023 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-20 04:21:08 | Medina, Ohio, US | |
1757793 | 1757793 | 2022-11-18 | US | Ohio | Medina | 39103 | 48023 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-19 04:21:14 | Medina, Ohio, US | |
3028786 | 3028786 | 2022-11-17 | US | Ohio | Medina | 39103 | 48023 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-18 04:21:15 | Medina, Ohio, US | |
2488497 | 2488497 | 2022-11-16 | US | Ohio | Medina | 39103 | 47814 | 531 | 0 | 41.11770589 | -81.8998621 | 2022-11-17 04:21:11 | Medina, Ohio, US | |
2506053 | 2506053 | 2022-11-10 | Japan | Gunma | 265581 | 531 | 0 | 36.504479 | 138.985605 | 2022-11-11 04:21:22 | Gunma, Japan | |||
482063 | 482063 | 2022-11-08 | US | Ohio | Greene | 39057 | 45363 | 531 | 0 | 39.69116283 | -83.89032084 | 2022-11-09 04:21:22 | Greene, Ohio, US | |
1830951 | 1830951 | 2022-10-25 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-26 04:22:19 | Dougherty, Georgia, US | |
795212 | 795212 | 2022-10-24 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-25 04:21:53 | Dougherty, Georgia, US | |
3277667 | 3277667 | 2022-10-23 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-24 04:22:29 | Dougherty, Georgia, US | |
2268705 | 2268705 | 2022-10-22 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-23 04:22:46 | Dougherty, Georgia, US | |
1593005 | 1593005 | 2022-10-21 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-22 04:22:53 | Dougherty, Georgia, US | |
2272721 | 2272721 | 2022-10-20 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-21 04:22:23 | Dougherty, Georgia, US | |
199056 | 199056 | 2022-10-19 | US | Georgia | Dougherty | 13095 | 22940 | 531 | 0 | 31.53328528 | -84.21722377 | 2022-10-20 04:22:59 | Dougherty, Georgia, US | |
198592 | 198592 | 2022-10-19 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-20 04:22:59 | Vastmanland, Sweden | |||
2757253 | 2757253 | 2022-10-18 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-19 04:22:26 | Vastmanland, Sweden | |||
2025087 | 2025087 | 2022-10-17 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-18 04:22:42 | Vastmanland, Sweden | |||
2159865 | 2159865 | 2022-10-16 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-17 04:20:31 | Vastmanland, Sweden | |||
516062 | 516062 | 2022-10-15 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-16 04:22:39 | Vastmanland, Sweden | |||
2033119 | 2033119 | 2022-10-14 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-15 04:22:00 | Vastmanland, Sweden | |||
3753807 | 3753807 | 2022-10-13 | Sweden | Vastmanland | 78244 | 531 | 0 | 59.6714 | 16.2159 | 2022-10-14 04:22:28 | Vastmanland, Sweden | |||
130761 | 130761 | 2022-10-04 | Japan | Nara | 222035 | 531 | 0 | 34.317451 | 135.871644 | 2022-10-05 04:23:06 | Nara, Japan | |||
2685708 | 2685708 | 2022-10-03 | Japan | Nara | 221722 | 531 | 0 | 34.317451 | 135.871644 | 2022-10-04 04:22:55 | Nara, Japan | |||
2262277 | 2262277 | 2022-10-02 | US | Ohio | Richland | 39139 | 36691 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-10-03 04:23:11 | Richland, Ohio, US | |
2259519 | 2259519 | 2022-10-02 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-10-03 04:23:11 | Nova Scotia, Canada | |||
2997803 | 2997803 | 2022-10-01 | US | Ohio | Richland | 39139 | 36691 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-10-02 04:21:23 | Richland, Ohio, US | |
2995045 | 2995045 | 2022-10-01 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-10-02 04:21:23 | Nova Scotia, Canada | |||
856129 | 856129 | 2022-09-30 | US | Ohio | Richland | 39139 | 36691 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-10-01 04:23:01 | Richland, Ohio, US | |
853371 | 853371 | 2022-09-30 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-10-01 04:23:01 | Nova Scotia, Canada | |||
2378055 | 2378055 | 2022-09-29 | US | Ohio | Richland | 39139 | 36691 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-30 04:23:09 | Richland, Ohio, US | |
2375297 | 2375297 | 2022-09-29 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-30 04:23:09 | Nova Scotia, Canada | |||
1562606 | 1562606 | 2022-09-28 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-29 04:22:34 | Richland, Ohio, US | |
1559848 | 1559848 | 2022-09-28 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-29 04:22:34 | Nova Scotia, Canada | |||
3997149 | 3997149 | 2022-09-27 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-28 04:23:01 | Richland, Ohio, US | |
3994391 | 3994391 | 2022-09-27 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-28 04:23:01 | Nova Scotia, Canada | |||
2771477 | 2771477 | 2022-09-26 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-27 04:23:01 | Richland, Ohio, US | |
2768719 | 2768719 | 2022-09-26 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-27 04:23:01 | Nova Scotia, Canada | |||
1979130 | 1979130 | 2022-09-25 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-26 04:20:52 | Richland, Ohio, US | |
1976618 | 1976618 | 2022-09-25 | Japan | Kagoshima | 296764 | 531 | 0 | 31.009484 | 130.430665 | 2022-09-26 04:20:52 | Kagoshima, Japan | |||
1976372 | 1976372 | 2022-09-25 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-26 04:20:52 | Nova Scotia, Canada | |||
2652297 | 2652297 | 2022-09-24 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-25 04:23:31 | Richland, Ohio, US | |
2649539 | 2649539 | 2022-09-24 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-25 04:23:31 | Nova Scotia, Canada | |||
386737 | 386737 | 2022-09-23 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-24 04:21:40 | Richland, Ohio, US | |
383979 | 383979 | 2022-09-23 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-24 04:21:40 | Nova Scotia, Canada | |||
1626803 | 1626803 | 2022-09-22 | US | Ohio | Richland | 39139 | 36556 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-23 04:23:13 | Richland, Ohio, US | |
1373007 | 1373007 | 2022-09-21 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-22 04:22:56 | Richland, Ohio, US | |
2019237 | 2019237 | 2022-09-20 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-21 04:23:22 | Richland, Ohio, US | |
3573110 | 3573110 | 2022-09-19 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-20 04:22:48 | Richland, Ohio, US | |
421849 | 421849 | 2022-09-18 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-19 04:21:49 | Richland, Ohio, US | |
3375873 | 3375873 | 2022-09-17 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-18 04:22:50 | Richland, Ohio, US | |
2357981 | 2357981 | 2022-09-16 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-17 04:20:19 | Richland, Ohio, US | |
3989138 | 3989138 | 2022-09-15 | US | Ohio | Richland | 39139 | 36378 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-16 04:21:19 | Richland, Ohio, US | |
1891655 | 1891655 | 2022-09-14 | US | Ohio | Richland | 39139 | 36154 | 531 | 0 | 40.77180308 | -82.5379961 | 2022-09-15 04:21:02 | Richland, Ohio, US | |
3777309 | 3777309 | 2022-08-30 | US | Virginia | Richmond City | 51760 | 55360 | 531 | 0 | 37.53255773 | -77.47966921 | 2022-08-31 04:20:57 | Richmond City, Virginia, US | |
1253441 | 1253441 | 2022-08-23 | US | Pennsylvania | Lebanon | 42075 | 40435 | 531 | 0 | 40.36680311 | -76.45651841 | 2022-08-24 04:20:46 | Lebanon, Pennsylvania, US | |
2855545 | 2855545 | 2022-08-22 | US | Pennsylvania | Lebanon | 42075 | 40435 | 531 | 0 | 40.36680311 | -76.45651841 | 2022-08-23 04:20:56 | Lebanon, Pennsylvania, US | |
2405517 | 2405517 | 2022-08-21 | US | Pennsylvania | Lebanon | 42075 | 40435 | 531 | 0 | 40.36680311 | -76.45651841 | 2022-08-22 04:20:38 | Lebanon, Pennsylvania, US | |
3800595 | 3800595 | 2022-08-20 | US | Pennsylvania | Lebanon | 42075 | 40435 | 531 | 0 | 40.36680311 | -76.45651841 | 2022-08-21 04:20:44 | Lebanon, Pennsylvania, US | |
2366181 | 2366181 | 2022-08-19 | US | Pennsylvania | Lebanon | 42075 | 40435 | 531 | 0 | 40.36680311 | -76.45651841 | 2022-08-20 04:21:01 | Lebanon, Pennsylvania, US | |
1163852 | 1163852 | 2022-08-18 | US | Pennsylvania | Lebanon | 42075 | 40435 | 531 | 0 | 40.36680311 | -76.45651841 | 2022-08-19 04:20:54 | Lebanon, Pennsylvania, 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]);