johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
652 rows where deaths = 518 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952175 | 2952175 | 2022-12-20 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-21 04:21:03 | Coweta, Georgia, US | |
3174577 | 3174577 | 2022-12-19 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-20 04:21:04 | Coweta, Georgia, US | |
1629094 | 1629094 | 2022-12-18 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-19 04:21:03 | Coweta, Georgia, US | |
504473 | 504473 | 2022-12-17 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-18 04:21:03 | Coweta, Georgia, US | |
3325045 | 3325045 | 2022-12-16 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-17 04:21:04 | Coweta, Georgia, US | |
543557 | 543557 | 2022-12-15 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-16 04:21:01 | Coweta, Georgia, US | |
349085 | 349085 | 2022-12-14 | US | Georgia | Coweta | 13077 | 39579 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-15 04:20:58 | Coweta, Georgia, US | |
308673 | 308673 | 2022-12-13 | US | Georgia | Coweta | 13077 | 39419 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-14 04:21:04 | Coweta, Georgia, US | |
1149734 | 1149734 | 2022-12-12 | US | Georgia | Coweta | 13077 | 39419 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-13 04:21:01 | Coweta, Georgia, US | |
1149617 | 1149617 | 2022-12-12 | US | Connecticut | Middlesex | 9007 | 37208 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-13 04:21:01 | Middlesex, Connecticut, US | |
869588 | 869588 | 2022-12-11 | US | Georgia | Coweta | 13077 | 39419 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-12 04:21:01 | Coweta, Georgia, US | |
869471 | 869471 | 2022-12-11 | US | Connecticut | Middlesex | 9007 | 37184 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-12 04:21:01 | Middlesex, Connecticut, US | |
258118 | 258118 | 2022-12-10 | US | Georgia | Coweta | 13077 | 39419 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-11 04:20:50 | Coweta, Georgia, US | |
258001 | 258001 | 2022-12-10 | US | Connecticut | Middlesex | 9007 | 37184 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-11 04:20:50 | Middlesex, Connecticut, US | |
3936832 | 3936832 | 2022-12-09 | US | Georgia | Coweta | 13077 | 39419 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-10 04:21:02 | Coweta, Georgia, US | |
3936715 | 3936715 | 2022-12-09 | US | Connecticut | Middlesex | 9007 | 37167 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-10 04:21:02 | Middlesex, Connecticut, US | |
3378164 | 3378164 | 2022-12-08 | US | Georgia | Coweta | 13077 | 39419 | 518 | 0 | 33.35334302 | -84.76129976 | 2022-12-09 04:21:05 | Coweta, Georgia, US | |
3378047 | 3378047 | 2022-12-08 | US | Connecticut | Middlesex | 9007 | 37135 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-09 04:21:05 | Middlesex, Connecticut, US | |
1985318 | 1985318 | 2022-12-07 | US | Connecticut | Middlesex | 9007 | 37105 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-08 04:21:07 | Middlesex, Connecticut, US | |
3714841 | 3714841 | 2022-12-06 | US | Connecticut | Middlesex | 9007 | 37078 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-07 04:20:58 | Middlesex, Connecticut, US | |
2415546 | 2415546 | 2022-12-05 | US | Connecticut | Middlesex | 9007 | 37048 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-06 04:21:03 | Middlesex, Connecticut, US | |
719154 | 719154 | 2022-12-04 | US | Connecticut | Middlesex | 9007 | 37027 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-05 04:20:58 | Middlesex, Connecticut, US | |
2817443 | 2817443 | 2022-12-03 | US | Connecticut | Middlesex | 9007 | 37004 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-04 04:20:56 | Middlesex, Connecticut, US | |
834299 | 834299 | 2022-12-02 | US | Connecticut | Middlesex | 9007 | 36989 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-03 04:21:02 | Middlesex, Connecticut, US | |
2136829 | 2136829 | 2022-12-01 | US | Connecticut | Middlesex | 9007 | 36948 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-02 04:21:07 | Middlesex, Connecticut, US | |
1965245 | 1965245 | 2022-11-30 | US | Connecticut | Middlesex | 9007 | 36902 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-12-01 04:21:03 | Middlesex, Connecticut, US | |
1964581 | 1964581 | 2022-11-30 | Japan | Miyagi | 362004 | 518 | 0 | 38.446859 | 140.927086 | 2022-12-01 04:21:03 | Miyagi, Japan | |||
2558966 | 2558966 | 2022-11-29 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-30 04:21:07 | Union, North Carolina, US | |
2557259 | 2557259 | 2022-11-29 | US | Connecticut | Middlesex | 9007 | 36867 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-30 04:21:07 | Middlesex, Connecticut, US | |
1242040 | 1242040 | 2022-11-28 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-29 04:21:05 | Union, North Carolina, US | |
1240333 | 1240333 | 2022-11-28 | US | Connecticut | Middlesex | 9007 | 36841 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-29 04:21:05 | Middlesex, Connecticut, US | |
3554028 | 3554028 | 2022-11-27 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-28 04:21:02 | Union, North Carolina, US | |
3552321 | 3552321 | 2022-11-27 | US | Connecticut | Middlesex | 9007 | 36826 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-28 04:21:02 | Middlesex, Connecticut, US | |
2102508 | 2102508 | 2022-11-26 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-27 04:21:05 | Union, North Carolina, US | |
2100801 | 2100801 | 2022-11-26 | US | Connecticut | Middlesex | 9007 | 36816 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-27 04:21:05 | Middlesex, Connecticut, US | |
489999 | 489999 | 2022-11-25 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-26 04:21:11 | Union, North Carolina, US | |
488292 | 488292 | 2022-11-25 | US | Connecticut | Middlesex | 9007 | 36794 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-26 04:21:11 | Middlesex, Connecticut, US | |
3525828 | 3525828 | 2022-11-24 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-25 04:21:06 | Union, North Carolina, US | |
3524121 | 3524121 | 2022-11-24 | US | Connecticut | Middlesex | 9007 | 36782 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-25 04:21:06 | Middlesex, Connecticut, US | |
3314611 | 3314611 | 2022-11-23 | US | North Carolina | Union | 37179 | 74737 | 518 | 0 | 34.98960527 | -80.52955873 | 2022-11-24 04:21:09 | Union, North Carolina, US | |
3312904 | 3312904 | 2022-11-23 | US | Connecticut | Middlesex | 9007 | 36752 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-24 04:21:09 | Middlesex, Connecticut, US | |
1620945 | 1620945 | 2022-11-22 | US | Connecticut | Middlesex | 9007 | 36724 | 518 | 0 | 41.45949668 | -72.53714864 | 2022-11-23 04:21:06 | Middlesex, Connecticut, US | |
3598891 | 3598891 | 2022-11-14 | US | Mississippi | Rankin | 28121 | 44159 | 518 | 0 | 32.26469147 | -89.94537876 | 2022-11-15 04:21:16 | Rankin, Mississippi, US | |
313749 | 313749 | 2022-11-13 | US | Mississippi | Rankin | 28121 | 44159 | 518 | 0 | 32.26469147 | -89.94537876 | 2022-11-14 04:21:09 | Rankin, Mississippi, US | |
64910 | 64910 | 2022-11-12 | US | Mississippi | Rankin | 28121 | 44159 | 518 | 0 | 32.26469147 | -89.94537876 | 2022-11-13 04:21:14 | Rankin, Mississippi, US | |
2929072 | 2929072 | 2022-11-11 | US | Mississippi | Rankin | 28121 | 44159 | 518 | 0 | 32.26469147 | -89.94537876 | 2022-11-12 04:20:41 | Rankin, Mississippi, US | |
2507908 | 2507908 | 2022-11-10 | US | Mississippi | Rankin | 28121 | 44159 | 518 | 0 | 32.26469147 | -89.94537876 | 2022-11-11 04:21:22 | Rankin, Mississippi, US | |
849918 | 849918 | 2022-11-02 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-11-03 04:22:05 | Halland, Sweden | |||
713465 | 713465 | 2022-11-01 | US | Tennessee | Wilson | 47189 | 48761 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-11-02 04:22:09 | Wilson, Tennessee, US | |
710769 | 710769 | 2022-11-01 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-11-02 04:22:09 | Halland, Sweden | |||
3287914 | 3287914 | 2022-10-31 | US | Tennessee | Wilson | 47189 | 48732 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-11-01 04:22:36 | Wilson, Tennessee, US | |
3285218 | 3285218 | 2022-10-31 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-11-01 04:22:36 | Halland, Sweden | |||
322947 | 322947 | 2022-10-30 | US | Tennessee | Wilson | 47189 | 48685 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-10-31 04:21:36 | Wilson, Tennessee, US | |
320251 | 320251 | 2022-10-30 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-31 04:21:36 | Halland, Sweden | |||
915223 | 915223 | 2022-10-29 | US | Tennessee | Wilson | 47189 | 48681 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-10-30 04:22:14 | Wilson, Tennessee, US | |
912527 | 912527 | 2022-10-29 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-30 04:22:14 | Halland, Sweden | |||
1369492 | 1369492 | 2022-10-28 | US | Tennessee | Wilson | 47189 | 48670 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-10-29 04:21:13 | Wilson, Tennessee, US | |
1366796 | 1366796 | 2022-10-28 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-29 04:21:13 | Halland, Sweden | |||
3041347 | 3041347 | 2022-10-27 | US | Tennessee | Wilson | 47189 | 48640 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-10-28 04:22:31 | Wilson, Tennessee, US | |
3038651 | 3038651 | 2022-10-27 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-28 04:22:31 | Halland, Sweden | |||
541767 | 541767 | 2022-10-26 | US | Tennessee | Wilson | 47189 | 48625 | 518 | 0 | 36.15496772 | -86.29775884 | 2022-10-27 04:22:01 | Wilson, Tennessee, US | |
2274187 | 2274187 | 2022-10-20 | US | New York | Out of NY | 80036 | 0 | 518 | 0 | 44.74530905 | 0.0 | 2022-10-21 04:22:23 | Out of NY, New York, US | |
1812273 | 1812273 | 2022-10-05 | US | Louisiana | Bossier | 22015 | 46967 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-10-06 04:21:22 | Bossier, Louisiana, US | |
132247 | 132247 | 2022-10-04 | US | Louisiana | Bossier | 22015 | 46954 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-10-05 04:23:06 | Bossier, Louisiana, US | |
2687194 | 2687194 | 2022-10-03 | US | Louisiana | Bossier | 22015 | 46938 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-10-04 04:22:55 | Bossier, Louisiana, US | |
2261261 | 2261261 | 2022-10-02 | US | Louisiana | Bossier | 22015 | 46918 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-10-03 04:23:11 | Bossier, Louisiana, US | |
2996787 | 2996787 | 2022-10-01 | US | Louisiana | Bossier | 22015 | 46918 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-10-02 04:21:23 | Bossier, Louisiana, US | |
855113 | 855113 | 2022-09-30 | US | Louisiana | Bossier | 22015 | 46918 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-10-01 04:23:01 | Bossier, Louisiana, US | |
2377039 | 2377039 | 2022-09-29 | US | Louisiana | Bossier | 22015 | 46898 | 518 | 0 | 32.67932307 | -93.60460152 | 2022-09-30 04:23:09 | Bossier, Louisiana, US | |
1561875 | 1561875 | 2022-09-28 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-29 04:22:34 | Washington, Minnesota, US | |
3997327 | 3997327 | 2022-09-27 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-28 04:23:01 | Mercer, Pennsylvania, US | |
3996418 | 3996418 | 2022-09-27 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-28 04:23:01 | Washington, Minnesota, US | |
2771655 | 2771655 | 2022-09-26 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-27 04:23:01 | Mercer, Pennsylvania, US | |
2770746 | 2770746 | 2022-09-26 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-27 04:23:01 | Washington, Minnesota, US | |
1979308 | 1979308 | 2022-09-25 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-26 04:20:52 | Mercer, Pennsylvania, US | |
1978399 | 1978399 | 2022-09-25 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-26 04:20:52 | Washington, Minnesota, US | |
2652475 | 2652475 | 2022-09-24 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-25 04:23:31 | Mercer, Pennsylvania, US | |
2651566 | 2651566 | 2022-09-24 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-25 04:23:31 | Washington, Minnesota, US | |
386915 | 386915 | 2022-09-23 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-24 04:21:40 | Mercer, Pennsylvania, US | |
386006 | 386006 | 2022-09-23 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-24 04:21:40 | Washington, Minnesota, US | |
1626981 | 1626981 | 2022-09-22 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-23 04:23:13 | Mercer, Pennsylvania, US | |
1626072 | 1626072 | 2022-09-22 | US | Minnesota | Washington | 27163 | 77627 | 518 | 0 | 45.03864533 | -92.88429635 | 2022-09-23 04:23:13 | Washington, Minnesota, US | |
1624045 | 1624045 | 2022-09-22 | Canada | Nova Scotia | 123549 | 518 | 0 | 44.682 | -63.7443 | 2022-09-23 04:23:13 | Nova Scotia, Canada | |||
1373185 | 1373185 | 2022-09-21 | US | Pennsylvania | Mercer | 42085 | 26420 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-22 04:22:56 | Mercer, Pennsylvania, US | |
1371085 | 1371085 | 2022-09-21 | US | California | Sonoma | 6097 | 111638 | 518 | 0 | 38.52746429 | -122.8862506 | 2022-09-22 04:22:56 | Sonoma, California, US | |
1370249 | 1370249 | 2022-09-21 | Canada | Nova Scotia | 123549 | 518 | 0 | 44.682 | -63.7443 | 2022-09-22 04:22:56 | Nova Scotia, Canada | |||
2019415 | 2019415 | 2022-09-20 | US | Pennsylvania | Mercer | 42085 | 26310 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-21 04:23:22 | Mercer, Pennsylvania, US | |
2017315 | 2017315 | 2022-09-20 | US | California | Sonoma | 6097 | 111636 | 518 | 0 | 38.52746429 | -122.8862506 | 2022-09-21 04:23:22 | Sonoma, California, US | |
2016735 | 2016735 | 2022-09-20 | Japan | Nara | 215396 | 518 | 0 | 34.317451 | 135.871644 | 2022-09-21 04:23:22 | Nara, Japan | |||
2016479 | 2016479 | 2022-09-20 | Canada | Nova Scotia | 123549 | 518 | 0 | 44.682 | -63.7443 | 2022-09-21 04:23:22 | Nova Scotia, Canada | |||
3573288 | 3573288 | 2022-09-19 | US | Pennsylvania | Mercer | 42085 | 26310 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-20 04:22:48 | Mercer, Pennsylvania, US | |
3573119 | 3573119 | 2022-09-19 | US | Ohio | Tuscarawas | 39157 | 23484 | 518 | 0 | 40.44214695 | -81.47226262 | 2022-09-20 04:22:48 | Tuscarawas, Ohio, US | |
3571188 | 3571188 | 2022-09-19 | US | California | Sonoma | 6097 | 111342 | 518 | 0 | 38.52746429 | -122.8862506 | 2022-09-20 04:22:48 | Sonoma, California, US | |
3570608 | 3570608 | 2022-09-19 | Japan | Nara | 215126 | 518 | 0 | 34.317451 | 135.871644 | 2022-09-20 04:22:48 | Nara, Japan | |||
3570352 | 3570352 | 2022-09-19 | Canada | Nova Scotia | 123549 | 518 | 0 | 44.682 | -63.7443 | 2022-09-20 04:22:48 | Nova Scotia, Canada | |||
422027 | 422027 | 2022-09-18 | US | Pennsylvania | Mercer | 42085 | 26310 | 518 | 0 | 41.30248872 | -80.25816981 | 2022-09-19 04:21:49 | Mercer, Pennsylvania, US | |
421858 | 421858 | 2022-09-18 | US | Ohio | Tuscarawas | 39157 | 23484 | 518 | 0 | 40.44214695 | -81.47226262 | 2022-09-19 04:21:49 | Tuscarawas, Ohio, US | |
419927 | 419927 | 2022-09-18 | US | California | Sonoma | 6097 | 111338 | 518 | 0 | 38.52746429 | -122.8862506 | 2022-09-19 04:21:49 | Sonoma, California, US | |
419347 | 419347 | 2022-09-18 | Japan | Nara | 214366 | 518 | 0 | 34.317451 | 135.871644 | 2022-09-19 04:21:49 | Nara, Japan | |||
419091 | 419091 | 2022-09-18 | Canada | Nova Scotia | 123549 | 518 | 0 | 44.682 | -63.7443 | 2022-09-19 04:21:49 | Nova Scotia, Canada |
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]);