johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where deaths = 2218 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2325951 | 2325951 | 2022-08-24 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-25 04:21:13 | Tulsa, Oklahoma, US | |
1253360 | 1253360 | 2022-08-23 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-24 04:20:46 | Tulsa, Oklahoma, US | |
2855464 | 2855464 | 2022-08-22 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-23 04:20:56 | Tulsa, Oklahoma, US | |
2405436 | 2405436 | 2022-08-21 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-22 04:20:38 | Tulsa, Oklahoma, US | |
3800514 | 3800514 | 2022-08-20 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-21 04:20:44 | Tulsa, Oklahoma, US | |
2366100 | 2366100 | 2022-08-19 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-20 04:21:01 | Tulsa, Oklahoma, US | |
1163771 | 1163771 | 2022-08-18 | US | Oklahoma | Tulsa | 40143 | 190382 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-19 04:20:54 | Tulsa, Oklahoma, US | |
3953095 | 3953095 | 2022-08-17 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-18 04:21:11 | Tulsa, Oklahoma, US | |
993597 | 993597 | 2022-08-16 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-17 04:20:59 | Tulsa, Oklahoma, US | |
2496636 | 2496636 | 2022-08-15 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-16 04:20:58 | Tulsa, Oklahoma, US | |
3650186 | 3650186 | 2022-08-14 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-15 04:20:59 | Tulsa, Oklahoma, US | |
1971192 | 1971192 | 2022-08-13 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-14 04:20:55 | Tulsa, Oklahoma, US | |
2891001 | 2891001 | 2022-08-12 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-13 04:20:52 | Tulsa, Oklahoma, US | |
2888515 | 2888515 | 2022-08-12 | Mozambique | 229836 | 2218 | 0 | -18.665695 | 35.529562 | 2022-08-13 04:20:52 | Mozambique | ||||
3910606 | 3910606 | 2022-08-11 | US | Oklahoma | Tulsa | 40143 | 188886 | 2218 | 0 | 36.11939621 | -95.94013939 | 2022-08-12 04:20:54 | Tulsa, Oklahoma, US | |
3908120 | 3908120 | 2022-08-11 | Mozambique | 229836 | 2218 | 0 | -18.665695 | 35.529562 | 2022-08-12 04:20:54 | Mozambique | ||||
1099706 | 1099706 | 2022-08-03 | US | Maryland | Prince George's | 24033 | 197364 | 2218 | 0 | 38.83070039 | -76.8496441 | 2022-08-04 04:20:58 | Prince George's, Maryland, US | |
1406631 | 1406631 | 2022-08-02 | US | Maryland | Prince George's | 24033 | 197075 | 2218 | 0 | 38.83070039 | -76.8496441 | 2022-08-03 04:20:59 | Prince George's, Maryland, US | |
3982611 | 3982611 | 2022-06-15 | Japan | Kanagawa | 766238 | 2218 | 0 | 35.415312 | 139.338983 | 2022-06-16 04:20:55 | Kanagawa, Japan | |||
946852 | 946852 | 2022-06-14 | Japan | Kanagawa | 765402 | 2218 | 0 | 35.415312 | 139.338983 | 2022-06-15 04:20:54 | Kanagawa, Japan | |||
2028962 | 2028962 | 2022-04-24 | Russia | Belgorod Oblast | 129347 | 2218 | 0 | 50.7080119 | 37.5837615 | 2022-04-25 04:20:56 | Belgorod Oblast, Russia | |||
1656375 | 1656375 | 2022-03-19 | Italy | Calabria | 262006 | 2218 | 0 | 38.90597598 | 16.59440194 | 2022-03-20 04:20:45 | Calabria, Italy | |||
2447071 | 2447071 | 2022-02-22 | Spain | Extremadura | 232461 | 2218 | 0 | 39.4937 | -6.0679 | 2022-02-23 04:21:09 | Extremadura, Spain | |||
186337 | 186337 | 2022-02-13 | Russia | Yaroslavl Oblast | 108194 | 2218 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-02-14 04:20:51 | Yaroslavl Oblast, Russia | |||
2613685 | 2613685 | 2022-01-06 | Ukraine | Luhansk Oblast | 60056 | 2218 | 0 | 48.574 | 39.3078 | 2022-01-07 04:22:09 | Luhansk Oblast, Ukraine | |||
447918 | 447918 | 2021-11-17 | US | California | Fresno | 6019 | 155346 | 2218 | 0 | 36.75733899 | -119.6466953 | 2021-11-18 04:21:33 | Fresno, California, US | |
3639301 | 3639301 | 2021-11-08 | Canada | British Columbia | 209703 | 2218 | 0 | 53.7267 | -127.6476 | 2021-11-09 04:21:36 | British Columbia, Canada | |||
938426 | 938426 | 2021-10-16 | Ukraine | Chernivtsi Oblast | 97830 | 2218 | 0 | 48.2917 | 25.9352 | 2021-10-17 04:21:29 | Chernivtsi Oblast, Ukraine | |||
1724244 | 1724244 | 2021-09-25 | Cambodia | 108257 | 2218 | 0 | 11.55 | 104.9167 | 2021-09-26 04:21:29 | Cambodia | ||||
809433 | 809433 | 2021-09-20 | Colombia | Risaralda | 87494 | 2218 | 0 | 5.3158 | -75.9928 | 2021-09-21 04:21:26 | Risaralda, Colombia | |||
1814632 | 1814632 | 2021-09-19 | Colombia | Risaralda | 87488 | 2218 | 0 | 5.3158 | -75.9928 | 2021-09-20 04:21:22 | Risaralda, Colombia | |||
16212 | 16212 | 2021-09-18 | Colombia | Risaralda | 87469 | 2218 | 0 | 5.3158 | -75.9928 | 2021-09-19 04:21:34 | Risaralda, Colombia | |||
2617897 | 2617897 | 2021-09-17 | Colombia | Risaralda | 87449 | 2218 | 0 | 5.3158 | -75.9928 | 2021-09-18 04:21:24 | Risaralda, Colombia | |||
2808605 | 2808605 | 2021-09-16 | Colombia | Risaralda | 87431 | 2218 | 0 | 5.3158 | -75.9928 | 2021-09-17 04:21:46 | Risaralda, Colombia | |||
67721 | 67721 | 2021-09-01 | US | Connecticut | Fairfield | 9001 | 106300 | 2218 | 0 | 41.26809896 | -73.3881171 | 2021-09-02 04:21:15 | Fairfield, Connecticut, US | |
2068563 | 2068563 | 2021-08-31 | US | Connecticut | Fairfield | 9001 | 106173 | 2218 | 0 | 41.26809896 | -73.3881171 | 2021-09-01 04:21:38 | Fairfield, Connecticut, US | |
1776017 | 1776017 | 2021-08-30 | US | Connecticut | Fairfield | 9001 | 105960 | 2218 | 0 | 41.26809896 | -73.3881171 | 2021-08-31 04:21:46 | Fairfield, Connecticut, US | |
3892591 | 3892591 | 2021-08-29 | US | Connecticut | Fairfield | 9001 | 105657 | 2218 | 0 | 41.26809896 | -73.3881171 | 2021-08-30 04:21:23 | Fairfield, Connecticut, US | |
2793694 | 2793694 | 2021-08-28 | US | Connecticut | Fairfield | 9001 | 105657 | 2218 | 0 | 41.26809896 | -73.3881171 | 2021-08-29 04:21:14 | Fairfield, Connecticut, US | |
2923853 | 2923853 | 2021-08-27 | US | Connecticut | Fairfield | 9001 | 105657 | 2218 | 0 | 41.26809896 | -73.3881171 | 2021-08-28 04:21:28 | Fairfield, Connecticut, US | |
589849 | 589849 | 2021-08-08 | Russia | Leningrad Oblast | 57983 | 2218 | 0 | 60.1853296 | 32.3925325 | 2021-08-09 04:21:24 | Leningrad Oblast, Russia | |||
332101 | 332101 | 2021-08-04 | Russia | Chelyabinsk Oblast | 74886 | 2218 | 67063 | 5605 | 54.4223954 | 61.1865846 | 2021-08-05 04:21:51 | Chelyabinsk Oblast, Russia | ||
1932280 | 1932280 | 2021-07-05 | Colombia | Cesar | 81498 | 2218 | 77042 | 2238 | 9.3373 | -73.6536 | 2021-07-06 04:21:32 | Cesar, Colombia | ||
1712366 | 1712366 | 2021-06-25 | Japan | Tokyo | 171481 | 2218 | 164951 | 4312 | 35.711343 | 139.446921 | 2021-06-26 04:21:43 | Tokyo, Japan | ||
2911021 | 2911021 | 2021-06-17 | Colombia | Huila | 65483 | 2218 | 61073 | 2192 | 2.5359 | -75.5277 | 2021-06-18 04:22:16 | Huila, Colombia | ||
3381211 | 3381211 | 2021-06-13 | Colombia | Bolivar | 115359 | 2218 | 110969 | 2172 | 8.6704 | -74.03 | 2021-06-14 04:22:46 | Bolivar, Colombia | ||
3956941 | 3956941 | 2021-05-11 | US | Ohio | Cuyahoga | 39035 | 112407 | 2218 | 0 | 41.424119 | -81.65918339 | 2021-05-12 04:21:29 | Cuyahoga, Ohio, US | |
3954545 | 3954545 | 2021-05-11 | Kosovo | 106130 | 2218 | 98007 | 5905 | 42.602636 | 20.902977 | 2021-05-12 04:21:29 | Kosovo | |||
382357 | 382357 | 2021-04-30 | US | New Jersey | Hudson | 34017 | 86752 | 2218 | 0 | 40.73766234 | -74.07515667 | 2021-05-01 04:20:47 | Hudson, New Jersey, US | |
3005578 | 3005578 | 2021-04-06 | US | New York | Westchester | 36119 | 122066 | 2218 | 0 | 41.16278376 | -73.75741653 | 2021-04-07 04:20:53 | Westchester, New York, US | |
1802257 | 1802257 | 2021-03-23 | Ukraine | Dnipropetrovsk Oblast | 84513 | 2218 | 72586 | 9709 | 48.4647 | 35.0462 | 2021-03-24 05:25:40 | Dnipropetrovsk Oblast, Ukraine | ||
3453012 | 3453012 | 2021-03-18 | Peru | Cajamarca | 36702 | 2218 | 0 | 34484 | -6.430284 | -78.74559599999998 | 2021-03-19 05:26:09 | Cajamarca, Peru | ||
352398 | 352398 | 2021-03-11 | Mexico | Tlaxcala | 17661 | 2218 | 0 | 15443 | 19.3139 | -98.2404 | 2021-03-12 05:26:50 | Tlaxcala, Mexico | ||
2638396 | 2638396 | 2021-02-11 | US | Florida | Broward | 12011 | 182419 | 2218 | 0 | 180201 | 26.15184651 | -80.48725556 | 2021-02-12 05:23:29 | Broward, Florida, US |
3519054 | 3519054 | 2021-01-15 | United Kingdom | Northern Ireland | 93834 | 2218 | 0 | 92275 | 54.7877 | -6.4923 | 2021-01-16 05:22:40 | Northern Ireland, United Kingdom | ||
3037409 | 3037409 | 2021-01-05 | US | Texas | Hidalgo | 48215 | 60470 | 2218 | 0 | 50439 | 26.39418217 | -98.18299696 | 2021-01-06 05:22:16 | Hidalgo, Texas, US |
2122397 | 2122397 | 2020-12-20 | US | Pennsylvania | Philadelphia | 42101 | 87689 | 2218 | 0 | 85471 | 40.00338507 | -75.1379271 | 2020-12-21 05:27:58 | Philadelphia, Pennsylvania, US |
2933904 | 2933904 | 2020-12-19 | US | Pennsylvania | Philadelphia | 42101 | 87230 | 2218 | 0 | 85012 | 40.00338507 | -75.1379271 | 2020-12-20 05:27:32 | Philadelphia, Pennsylvania, US |
1903850 | 1903850 | 2020-12-18 | US | Pennsylvania | Philadelphia | 42101 | 86436 | 2218 | 0 | 84218 | 40.00338507 | -75.1379271 | 2020-12-19 05:27:52 | Philadelphia, Pennsylvania, US |
1972551 | 1972551 | 2020-11-25 | India | Rajasthan | 253767 | 2218 | 225229 | 26320 | 26.583423 | 73.847973 | 2020-11-26 05:27:44 | Rajasthan, India | ||
1544029 | 1544029 | 2020-11-07 | Mexico | Guerrero | 22561 | 2218 | 19932 | 411 | 17.4392 | -99.5451 | 2020-11-08 05:24:56 | Guerrero, Mexico | ||
894356 | 894356 | 2020-11-05 | US | New York | Nassau | 36059 | 50918 | 2218 | 0 | 48700 | 40.74066522 | -73.58941873 | 2020-11-06 05:24:55 | Nassau, New York, US |
2921418 | 2921418 | 2020-11-04 | US | New York | Nassau | 36059 | 50702 | 2218 | 0 | 48484 | 40.74066522 | -73.58941873 | 2020-11-05 06:05:03 | Nassau, New York, US |
3785894 | 3785894 | 2020-10-11 | Italy | Veneto | 31503 | 2218 | 23197 | 6088 | 45.43490485 | 12.33845213 | 2020-10-12 04:23:45 | Veneto, Italy | ||
609443 | 609443 | 2020-08-29 | Brazil | Santa Catarina | 146404 | 2218 | 131550 | 12636 | -27.2423 | -50.2189 | 2020-08-30 04:28:22 | Santa Catarina, Brazil | ||
327299 | 327299 | 2020-07-20 | Bolivia | 60991 | 2218 | 18875 | 39898 | -16.2902 | -63.5887 | 2020-07-21 04:38:46 | Bolivia |
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]);