johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where active = 3580 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829446 | 829446 | 2021-07-09 | Colombia | Huila | 77173 | 2579 | 71014 | 3580 | 2.5359 | -75.5277 | 2021-07-10 04:21:25 | Huila, Colombia | ||
1165385 | 1165385 | 2021-07-04 | Russia | Krasnodar Krai | 52689 | 3504 | 45605 | 3580 | 45.7684014 | 39.0261044 | 2021-07-05 04:21:28 | Krasnodar Krai, Russia | ||
400232 | 400232 | 2021-06-29 | India | Tripura | 65770 | 677 | 61513 | 3580 | 23.746783 | 91.743565 | 2021-06-30 04:21:41 | Tripura, India | ||
3667828 | 3667828 | 2021-03-06 | Russia | Karelia Republic | 41430 | 322 | 37528 | 3580 | 62.61940309999999 | 33.4920267 | 2021-03-07 05:21:54 | Karelia Republic, Russia | ||
2370806 | 2370806 | 2021-02-28 | US | Virginia | Charlottesville | 51540 | 3624 | 44 | 0 | 3580 | 38.03527919 | -78.48569588 | 2021-03-01 05:23:01 | Charlottesville, Virginia, US |
1938274 | 1938274 | 2021-02-23 | US | Mississippi | Neshoba | 28099 | 3746 | 166 | 0 | 3580 | 32.75339664 | -89.11726492 | 2021-02-24 05:29:16 | Neshoba, Mississippi, US |
182635 | 182635 | 2021-02-21 | US | Colorado | Broomfield | 8014 | 3843 | 73 | 0 | 3580 | 39.95998787 | -105.0566324 | 2021-02-22 05:24:21 | Broomfield, Colorado, US |
472093 | 472093 | 2021-02-19 | US | Florida | DeSoto | 12027 | 3652 | 72 | 0 | 3580 | 27.18677893 | -81.80941373 | 2021-02-20 05:22:51 | DeSoto, Florida, US |
1155558 | 1155558 | 2021-02-18 | US | Ohio | Brown | 39015 | 3634 | 54 | 0 | 3580 | 38.93416837 | -83.86788395 | 2021-02-19 05:24:16 | Brown, Ohio, US |
3604648 | 3604648 | 2021-02-17 | US | Wyoming | Sweetwater | 56037 | 3614 | 34 | 0 | 3580 | 41.65943896 | -108.8827882 | 2021-02-18 05:22:58 | Sweetwater, Wyoming, US |
3980183 | 3980183 | 2021-02-10 | US | Michigan | Barry | 26015 | 3621 | 41 | 0 | 3580 | 42.59513984 | -85.30834519 | 2021-02-11 05:23:55 | Barry, Michigan, US |
1529162 | 1529162 | 2021-02-09 | US | Kansas | Cowley | 20035 | 3658 | 78 | 0 | 3580 | 37.23781842 | -96.83776647 | 2021-02-10 05:22:41 | Cowley, Kansas, US |
614953 | 614953 | 2021-02-08 | US | Kansas | Cowley | 20035 | 3658 | 78 | 0 | 3580 | 37.23781842 | -96.83776647 | 2021-02-09 05:23:30 | Cowley, Kansas, US |
791993 | 791993 | 2021-02-04 | US | Michigan | Branch | 26023 | 3661 | 81 | 0 | 3580 | 41.91600556 | -85.05929476 | 2021-02-05 05:22:38 | Branch, Michigan, US |
2214032 | 2214032 | 2021-01-30 | US | North Carolina | Vance | 37181 | 3655 | 75 | 0 | 3580 | 36.36880673 | -78.40670845 | 2021-01-31 05:22:42 | Vance, North Carolina, US |
1899519 | 1899519 | 2021-01-29 | US | North Carolina | Vance | 37181 | 3655 | 75 | 0 | 3580 | 36.36880673 | -78.40670845 | 2021-01-30 05:22:49 | Vance, North Carolina, US |
2430402 | 2430402 | 2021-01-23 | US | West Virginia | Putnam | 54079 | 3647 | 67 | 0 | 3580 | 38.50782345 | -81.9082131 | 2021-01-24 05:22:35 | Putnam, West Virginia, US |
2429192 | 2429192 | 2021-01-23 | US | North Carolina | Carteret | 37031 | 3599 | 19 | 0 | 3580 | 34.8932941 | -76.54120135 | 2021-01-24 05:22:35 | Carteret, North Carolina, US |
2428955 | 2428955 | 2021-01-23 | US | Nebraska | Dakota | 31043 | 3636 | 56 | 0 | 3580 | 42.39040144 | -96.56656425 | 2021-01-24 05:22:35 | Dakota, Nebraska, US |
2467822 | 2467822 | 2021-01-22 | US | Illinois | Monroe | 17133 | 3651 | 71 | 0 | 3580 | 38.27594376 | -90.17761038 | 2021-01-23 05:22:03 | Monroe, Illinois, US |
910842 | 910842 | 2021-01-19 | US | Pennsylvania | Huntingdon | 42061 | 3679 | 99 | 0 | 3580 | 40.42162652 | -77.97673273 | 2021-01-20 05:21:54 | Huntingdon, Pennsylvania, US |
3903547 | 3903547 | 2021-01-09 | US | Wyoming | Albany | 56001 | 3590 | 10 | 0 | 3580 | 41.65498705 | -105.7235415 | 2021-01-10 05:22:12 | Albany, Wyoming, US |
3899960 | 3899960 | 2021-01-09 | Japan | Aichi | 19097 | 266 | 15251 | 3580 | 35.035551 | 137.211621 | 2021-01-10 05:22:12 | Aichi, Japan | ||
1064483 | 1064483 | 2021-01-04 | US | Pennsylvania | Armstrong | 42005 | 3652 | 72 | 0 | 3580 | 40.81665618 | -79.46290811 | 2021-01-05 05:21:49 | Armstrong, Pennsylvania, US |
205071 | 205071 | 2020-12-25 | US | South Carolina | Kershaw | 45055 | 3652 | 72 | 0 | 3580 | 34.33988254 | -80.58763164 | 2020-12-26 05:22:28 | Kershaw, South Carolina, US |
3694294 | 3694294 | 2020-12-24 | US | South Carolina | Kershaw | 45055 | 3652 | 72 | 0 | 3580 | 34.33988254 | -80.58763164 | 2020-12-25 05:22:48 | Kershaw, South Carolina, US |
2931907 | 2931907 | 2020-12-19 | US | Florida | Gadsden | 12039 | 3638 | 58 | 0 | 3580 | 30.57796289 | -84.61915825 | 2020-12-20 05:27:32 | Gadsden, Florida, US |
2128237 | 2128237 | 2020-12-17 | Russia | Smolensk Oblast | 14833 | 302 | 10951 | 3580 | 55.03434960000001 | 33.0192065 | 2020-12-18 05:28:18 | Smolensk Oblast, Russia | ||
1818526 | 1818526 | 2020-12-08 | Brazil | Goias | 288822 | 6504 | 277792 | 3580 | -15.827 | -49.8362 | 2020-12-09 05:28:01 | Goias, Brazil | ||
1007875 | 1007875 | 2020-12-06 | US | Maryland | Wicomico | 24045 | 3640 | 60 | 0 | 3580 | 38.37301947 | -75.62705831 | 2020-12-07 05:26:14 | Wicomico, Maryland, US |
3863514 | 3863514 | 2020-12-04 | Malaysia | Selangor | 15858 | 30 | 12248 | 3580 | 3.0738 | 101.5183 | 2020-12-05 05:27:36 | Selangor, Malaysia | ||
76898 | 76898 | 2020-12-03 | US | Mississippi | Lauderdale | 28075 | 3727 | 147 | 0 | 3580 | 32.40419769 | -88.66229662 | 2020-12-04 05:27:27 | Lauderdale, Mississippi, US |
2539812 | 2539812 | 2020-12-01 | US | North Dakota | Stark | 38089 | 3635 | 39 | 0 | 3580 | 46.80851182 | -102.6576326 | 2020-12-02 05:27:41 | Stark, North Dakota, US |
3838796 | 3838796 | 2020-11-21 | US | North Carolina | Harnett | 37085 | 3657 | 77 | 0 | 3580 | 35.36731853 | -78.87243571 | 2020-11-22 05:25:45 | Harnett, North Carolina, US |
376416 | 376416 | 2020-11-06 | Russia | Primorsky Krai | 16599 | 169 | 12850 | 3580 | 45.0819456 | 134.726645 | 2020-11-07 05:24:52 | Primorsky Krai, Russia | ||
3410116 | 3410116 | 2020-11-01 | US | Florida | Charlotte | 12015 | 3741 | 161 | 0 | 3580 | 26.90131002 | -81.92949121 | 2020-11-02 05:25:04 | Charlotte, Florida, US |
10629 | 10629 | 2020-10-25 | US | North Carolina | Davidson | 37057 | 3623 | 43 | 0 | 3580 | 35.79115496 | -80.21256572 | 2020-10-26 04:25:02 | Davidson, North Carolina, US |
3990923 | 3990923 | 2020-10-20 | Sweden | Orebro | 3752 | 172 | 0 | 3580 | 59.535 | 15.0066 | 2020-10-21 04:24:14 | Orebro, Sweden | ||
2837582 | 2837582 | 2020-09-21 | US | Georgia | Columbia | 13073 | 3637 | 57 | 0 | 3580 | 33.54534185 | -82.263524 | 2020-09-22 04:23:00 | Columbia, Georgia, US |
2455203 | 2455203 | 2020-09-19 | US | Arizona | Coconino | 4005 | 3713 | 133 | 0 | 3580 | 35.83883429 | -111.7707178 | 2020-09-20 04:22:00 | Coconino, Arizona, US |
2729441 | 2729441 | 2020-09-15 | US | Arizona | Mohave | 4015 | 3798 | 218 | 0 | 3580 | 35.70471703 | -113.7577902 | 2020-09-16 04:22:53 | Mohave, Arizona, US |
1174004 | 1174004 | 2020-09-10 | US | Georgia | Lowndes | 13185 | 3652 | 72 | 0 | 3580 | 30.83568832 | -83.27056716 | 2020-09-11 04:46:23 | Lowndes, Georgia, US |
2171865 | 2171865 | 2020-09-09 | Sweden | Uppsala | 3822 | 242 | 0 | 3580 | 60.0092 | 17.2715 | 2020-09-10 04:29:01 | Uppsala, Sweden | ||
427649 | 427649 | 2020-09-07 | Sweden | Ostergotland | 3855 | 275 | 0 | 3580 | 58.3454 | 15.5198 | 2020-09-08 04:28:25 | Ostergotland, Sweden | ||
3162002 | 3162002 | 2020-09-06 | US | Alabama | Marshall | 1095 | 3621 | 41 | 0 | 3580 | 34.36975964 | -86.30486727 | 2020-09-07 04:28:30 | Marshall, Alabama, US |
1999941 | 1999941 | 2020-08-26 | US | Virginia | Chesapeake | 51550 | 3625 | 45 | 0 | 3580 | 36.67670048 | -76.30545744 | 2020-08-27 04:28:15 | Chesapeake, Virginia, US |
2300120 | 2300120 | 2020-08-22 | US | Florida | Clay | 12019 | 3650 | 70 | 0 | 3580 | 29.98319144 | -81.85609986 | 2020-08-23 04:27:48 | Clay, Florida, US |
96227 | 96227 | 2020-08-04 | US | Missouri | Jackson | 29095 | 3639 | 59 | 0 | 3580 | 39.01002188 | -94.34724536 | 2020-08-05 04:34:43 | Jackson, Missouri, US |
2955275 | 2955275 | 2020-07-29 | US | South Carolina | Berkeley | 45015 | 3636 | 56 | 0 | 3580 | 33.20222596 | -79.94654523 | 2020-07-30 04:35:05 | Berkeley, South Carolina, US |
3043902 | 3043902 | 2020-07-02 | US | South Dakota | Minnehaha | 46099 | 3638 | 58 | 0 | 3580 | 43.67441641 | -96.7910885 | 2020-07-03 04:33:54 | Minnehaha, South Dakota, US |
572339 | 572339 | 2020-06-06 | US | Pennsylvania | Lehigh | 42077 | 3828 | 248 | 0 | 3580 | 40.6154815 | -75.59435245 | 2020-06-07 03:53:30 | Lehigh, Pennsylvania, US |
872669 | 872669 | 2020-05-24 | US | Pennsylvania | Berks | 42011 | 3876 | 296 | 0 | 3580 | 40.41570541 | -75.92457766 | 2020-05-25 02:32:44 | Berks, Pennsylvania, US |
268561 | 268561 | 2020-05-21 | Panama | 10116 | 291 | 6245 | 3580 | 8.538 | -80.7821 | 2020-05-22 02:36:51 | Panama | |||
3258776 | 3258776 | 2020-05-18 | US | Georgia | Fulton | 13121 | 3751 | 171 | 0 | 3580 | 33.79216944 | -84.46319413 | 2020-05-19 02:32:18 | Fulton, Georgia, 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]);