johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where confirmed = 7349 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1987584 | 1987584 | 2022-12-07 | US | Tennessee | DeKalb | 47041 | 7349 | 107 | 0 | 35.97616272 | -85.83689361 | 2022-12-08 04:21:07 | DeKalb, Tennessee, US | |
713173 | 713173 | 2022-11-01 | US | Puerto Rico | Anasco | 72011 | 7349 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-02 04:22:09 | Anasco, Puerto Rico, US | |
3287622 | 3287622 | 2022-10-31 | US | Puerto Rico | Anasco | 72011 | 7349 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-01 04:22:36 | Anasco, Puerto Rico, US | |
2635249 | 2635249 | 2022-09-05 | US | Louisiana | Plaquemines | 22075 | 7349 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-09-06 04:21:02 | Plaquemines, Louisiana, US | |
2988813 | 2988813 | 2022-09-04 | US | Louisiana | Plaquemines | 22075 | 7349 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-09-05 04:21:01 | Plaquemines, Louisiana, US | |
2714498 | 2714498 | 2022-09-03 | US | Louisiana | Plaquemines | 22075 | 7349 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-09-04 04:21:22 | Plaquemines, Louisiana, US | |
1395203 | 1395203 | 2022-09-02 | US | Louisiana | Plaquemines | 22075 | 7349 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-09-03 04:21:04 | Plaquemines, Louisiana, US | |
3549032 | 3549032 | 2022-09-01 | US | Louisiana | Plaquemines | 22075 | 7349 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-09-02 04:21:07 | Plaquemines, Louisiana, US | |
93909 | 93909 | 2022-07-23 | US | Puerto Rico | Naranjito | 72105 | 7349 | 0 | 0 | 18.288019 | -66.252703 | 2022-07-24 04:20:47 | Naranjito, Puerto Rico, US | |
2493405 | 2493405 | 2022-06-29 | US | Virginia | Orange | 51137 | 7349 | 89 | 0 | 38.24530219 | -78.015604 | 2022-06-30 04:21:01 | Orange, Virginia, US | |
3272771 | 3272771 | 2022-06-19 | US | Texas | Willacy | 48489 | 7349 | 131 | 0 | 26.47411727 | -97.61535848 | 2022-06-20 04:21:01 | Willacy, Texas, US | |
1423884 | 1423884 | 2022-06-08 | US | Puerto Rico | San Lorenzo | 72129 | 7349 | 0 | 0 | 18.147987 | -65.976392 | 2022-06-09 04:20:54 | San Lorenzo, Puerto Rico, US | |
3898715 | 3898715 | 2022-05-19 | US | Puerto Rico | Juncos | 72077 | 7349 | 0 | 0 | 18.223793 | -65.909109 | 2022-05-20 04:20:57 | Juncos, Puerto Rico, US | |
2534904 | 2534904 | 2022-05-12 | US | Louisiana | Franklin | 22041 | 7349 | 178 | 0 | 32.13675181 | -91.67589857 | 2022-05-13 04:20:51 | Franklin, Louisiana, US | |
3446350 | 3446350 | 2022-05-11 | US | Louisiana | Franklin | 22041 | 7349 | 178 | 0 | 32.13675181 | -91.67589857 | 2022-05-12 04:20:54 | Franklin, Louisiana, US | |
3536967 | 3536967 | 2022-05-10 | US | Louisiana | Franklin | 22041 | 7349 | 178 | 0 | 32.13675181 | -91.67589857 | 2022-05-11 04:20:48 | Franklin, Louisiana, US | |
223502 | 223502 | 2022-05-09 | US | Louisiana | Franklin | 22041 | 7349 | 178 | 0 | 32.13675181 | -91.67589857 | 2022-05-10 04:20:50 | Franklin, Louisiana, US | |
3917889 | 3917889 | 2022-05-01 | US | Mississippi | Tippah | 28139 | 7349 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-05-02 04:21:10 | Tippah, Mississippi, US | |
2842693 | 2842693 | 2022-04-30 | US | Mississippi | Tippah | 28139 | 7349 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-05-01 04:20:57 | Tippah, Mississippi, US | |
1159006 | 1159006 | 2022-04-29 | US | Mississippi | Tippah | 28139 | 7349 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-04-30 04:21:05 | Tippah, Mississippi, US | |
1698188 | 1698188 | 2022-04-28 | US | Mississippi | Tippah | 28139 | 7349 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-04-29 04:20:59 | Tippah, Mississippi, US | |
3853671 | 3853671 | 2022-04-27 | US | Mississippi | Tippah | 28139 | 7349 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-04-28 04:20:47 | Tippah, Mississippi, US | |
1328101 | 1328101 | 2022-04-26 | US | Mississippi | Tippah | 28139 | 7349 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-04-27 04:20:52 | Tippah, Mississippi, US | |
1575917 | 1575917 | 2022-04-10 | Chad | 7349 | 192 | 0 | 15.4542 | 18.7322 | 2022-04-11 04:21:02 | Chad | ||||
1652159 | 1652159 | 2022-04-09 | Chad | 7349 | 192 | 0 | 15.4542 | 18.7322 | 2022-04-10 04:20:52 | Chad | ||||
2115481 | 2115481 | 2022-04-08 | Chad | 7349 | 192 | 0 | 15.4542 | 18.7322 | 2022-04-09 04:20:42 | Chad | ||||
3320005 | 3320005 | 2022-04-07 | Chad | 7349 | 192 | 0 | 15.4542 | 18.7322 | 2022-04-08 04:20:48 | Chad | ||||
2800541 | 2800541 | 2022-04-06 | Chad | 7349 | 192 | 0 | 15.4542 | 18.7322 | 2022-04-07 04:20:53 | Chad | ||||
1541515 | 1541515 | 2022-03-31 | US | Maine | Hancock | 23009 | 7349 | 81 | 0 | 44.59816444 | -68.38401854 | 2022-04-01 04:20:28 | Hancock, Maine, US | |
944646 | 944646 | 2022-02-28 | US | Mississippi | Itawamba | 28057 | 7349 | 142 | 0 | 34.27993475 | -88.3606733 | 2022-03-01 04:21:09 | Itawamba, Mississippi, US | |
3302129 | 3302129 | 2022-01-30 | US | Missouri | Lafayette | 29107 | 7349 | 109 | 0 | 39.06986886 | -93.78076396 | 2022-01-31 04:21:09 | Lafayette, Missouri, US | |
1116160 | 1116160 | 2022-01-11 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-12 04:21:44 | Logan, Oklahoma, US | |
1694888 | 1694888 | 2022-01-10 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-11 04:22:01 | Logan, Oklahoma, US | |
129303 | 129303 | 2022-01-09 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-10 04:22:07 | Logan, Oklahoma, US | |
126793 | 126793 | 2022-01-09 | Malaysia | Perlis | 7349 | 137 | 0 | 6.4449 | 100.2048 | 2022-01-10 04:22:07 | Perlis, Malaysia | |||
1218138 | 1218138 | 2022-01-08 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-09 04:21:46 | Logan, Oklahoma, US | |
1392231 | 1392231 | 2022-01-07 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-08 04:21:53 | Logan, Oklahoma, US | |
2612618 | 2612618 | 2022-01-06 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-07 04:22:09 | Logan, Oklahoma, US | |
1284560 | 1284560 | 2022-01-05 | US | Oklahoma | Logan | 40083 | 7349 | 131 | 0 | 35.91899576 | -97.44352845 | 2022-01-06 04:22:09 | Logan, Oklahoma, US | |
1286757 | 1286757 | 2022-01-04 | US | Georgia | Baldwin | 13009 | 7349 | 203 | 0 | 33.06882326 | -83.24701748 | 2022-01-05 04:21:59 | Baldwin, Georgia, US | |
1717871 | 1717871 | 2021-12-16 | US | Louisiana | Lincoln | 22061 | 7349 | 119 | 0 | 32.6003154 | -92.66597409999999 | 2021-12-17 04:22:14 | Lincoln, Louisiana, US | |
3499598 | 3499598 | 2021-12-15 | US | Virginia | Shenandoah | 51171 | 7349 | 178 | 0 | 38.85905135 | -78.56813762 | 2021-12-16 04:22:11 | Shenandoah, Virginia, US | |
3750101 | 3750101 | 2021-11-22 | US | Illinois | Clinton | 17027 | 7349 | 105 | 0 | 38.60704876 | -89.42385254 | 2021-11-23 04:22:39 | Clinton, Illinois, US | |
29906 | 29906 | 2021-11-11 | US | Louisiana | Avoyelles | 22009 | 7349 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-11-12 04:22:01 | Avoyelles, Louisiana, US | |
2846345 | 2846345 | 2021-11-10 | US | Louisiana | Avoyelles | 22009 | 7349 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-11-11 04:21:45 | Avoyelles, Louisiana, US | |
698998 | 698998 | 2021-11-04 | US | California | Tuolumne | 6109 | 7349 | 90 | 0 | 38.02644018 | -119.95250929999999 | 2021-11-05 04:21:54 | Tuolumne, California, US | |
44604 | 44604 | 2021-11-02 | US | Georgia | Ware | 13299 | 7349 | 246 | 0 | 31.05449097 | -82.42224148 | 2021-11-03 06:22:09 | Ware, Georgia, US | |
598454 | 598454 | 2021-10-19 | US | Georgia | Colquitt | 13071 | 7349 | 175 | 0 | 31.18810588 | -83.7677946 | 2021-10-20 04:21:00 | Colquitt, Georgia, US | |
1276731 | 1276731 | 2021-10-03 | US | Ohio | Athens | 39009 | 7349 | 80 | 0 | 39.33425634 | -82.04278644 | 2021-10-04 04:21:31 | Athens, Ohio, US | |
3758953 | 3758953 | 2021-09-21 | US | Kentucky | Whitley | 21235 | 7349 | 70 | 0 | 36.75700531 | -84.14541217 | 2021-09-22 04:21:45 | Whitley, Kentucky, US | |
67854 | 67854 | 2021-09-01 | US | Georgia | Effingham | 13103 | 7349 | 89 | 0 | 32.36616021 | -81.34280942 | 2021-09-02 04:21:15 | Effingham, Georgia, US | |
3894652 | 3894652 | 2021-08-29 | US | Puerto Rico | Caguas | 72025 | 7349 | 0 | 0 | 18.211615 | -66.050779 | 2021-08-30 04:21:23 | Caguas, Puerto Rico, US | |
3219385 | 3219385 | 2021-07-26 | US | Indiana | Grant | 18053 | 7349 | 181 | 0 | 40.51587228 | -85.65468702 | 2021-07-27 04:21:18 | Grant, Indiana, US | |
1709683 | 1709683 | 2021-06-02 | US | Kentucky | Bullitt | 21029 | 7349 | 80 | 0 | 37.97162523 | -85.68955617 | 2021-06-03 04:23:32 | Bullitt, Kentucky, US | |
241992 | 241992 | 2021-04-02 | US | Florida | Walton | 12131 | 7349 | 83 | 0 | 30.64204028 | -86.16935664 | 2021-04-03 04:20:44 | Walton, Florida, US | |
3372348 | 3372348 | 2021-03-21 | US | Texas | Bowie | 48037 | 7349 | 198 | 0 | 33.44626922 | -94.41834132 | 2021-03-22 05:25:43 | Bowie, Texas, US | |
1858287 | 1858287 | 2021-02-25 | South Sudan | 7349 | 87 | 4107 | 3155 | 6.877000000000002 | 31.307 | 2021-02-26 05:22:40 | South Sudan | |||
280983 | 280983 | 2021-02-24 | US | Georgia | Gordon | 13129 | 7349 | 101 | 0 | 7248 | 34.50487351 | -84.87296253 | 2021-02-25 05:24:57 | Gordon, Georgia, US |
1339841 | 1339841 | 2021-02-15 | US | Maryland | Carroll | 24013 | 7349 | 207 | 0 | 7142 | 39.56453592 | -77.02373735 | 2021-02-16 05:24:38 | Carroll, Maryland, US |
13767 | 13767 | 2021-01-26 | US | Kentucky | Madison | 21151 | 7349 | 49 | 0 | 7300 | 37.71659336 | -84.27220275 | 2021-01-27 05:23:41 | Madison, Kentucky, US |
2429155 | 2429155 | 2021-01-23 | US | New York | Rensselaer | 36083 | 7349 | 110 | 0 | 7239 | 42.71348136 | -73.51089874 | 2021-01-24 05:22:35 | Rensselaer, New York, US |
1095655 | 1095655 | 2021-01-20 | US | Maryland | Charles | 24017 | 7349 | 138 | 0 | 7211 | 38.51092331 | -76.98580666 | 2021-01-21 05:22:01 | Charles, Maryland, US |
2541484 | 2541484 | 2021-01-07 | Mexico | Campeche | 7349 | 975 | 0 | 6374 | 19.8301 | -90.5349 | 2021-01-08 05:22:42 | Campeche, Mexico | ||
3034372 | 3034372 | 2021-01-05 | Mali | 7349 | 284 | 5070 | 1995 | 17.570692 | -3.996166000000001 | 2021-01-06 05:22:16 | Mali | |||
681843 | 681843 | 2020-11-23 | US | Wisconsin | Eau Claire | 55035 | 7349 | 58 | 0 | 7291 | 44.726614 | -91.28609183 | 2020-11-24 05:27:31 | Eau Claire, Wisconsin, US |
3339231 | 3339231 | 2020-11-17 | US | Colorado | Pueblo | 8101 | 7349 | 167 | 0 | 5206 | 38.17359144 | -104.5127437 | 2020-11-18 05:40:31 | Pueblo, Colorado, US |
2915731 | 2915731 | 2020-11-14 | US | California | Marin | 6041 | 7349 | 133 | 0 | 7215 | 38.07122463 | -122.7210631 | 2020-11-15 05:26:53 | Marin, California, US |
274058 | 274058 | 2020-11-10 | US | Missouri | Jefferson | 29099 | 7349 | 94 | 0 | 7255 | 38.25926778 | -90.53870896 | 2020-11-11 05:25:30 | Jefferson, Missouri, US |
1988505 | 1988505 | 2020-11-09 | Cuba | 7349 | 130 | 6721 | 498 | 21.521757 | -77.78116700000002 | 2020-11-10 05:40:07 | Cuba | |||
2919338 | 2919338 | 2020-11-04 | Peru | Huancavelica | 7349 | 364 | 0 | 6985 | -13.023888 | -75.00277 | 2020-11-05 06:05:03 | Huancavelica, Peru | ||
2691202 | 2691202 | 2020-10-08 | US | Louisiana | St. Tammany | 22103 | 7349 | 264 | 0 | 7085 | 30.40942847 | -89.95642711 | 2020-10-09 04:23:59 | St. Tammany, Louisiana, US |
3389308 | 3389308 | 2020-10-02 | Germany | Sachsen | 7349 | 237 | 6359 | 790 | 51.1045 | 13.2017 | 2020-10-03 04:23:40 | Sachsen, Germany | ||
2299681 | 2299681 | 2020-08-22 | Russia | Perm Krai | 7349 | 197 | 5174 | 1978 | 58.5951603 | 56.3159546 | 2020-08-23 04:27:48 | Perm Krai, Russia |
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]);