johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
152 rows where deaths = 2002 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
327809 | 327809 | 2022-12-27 | Germany | Saarland | 477361 | 2002 | 0 | 49.3964 | 7.023 | 2022-12-28 04:21:04 | Saarland, Germany | |||
310556 | 310556 | 2022-12-13 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-14 04:21:04 | Delaware, Pennsylvania, US | |
1151617 | 1151617 | 2022-12-12 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-13 04:21:01 | Delaware, Pennsylvania, US | |
871471 | 871471 | 2022-12-11 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-12 04:21:01 | Delaware, Pennsylvania, US | |
260001 | 260001 | 2022-12-10 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-11 04:20:50 | Delaware, Pennsylvania, US | |
3938715 | 3938715 | 2022-12-09 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-10 04:21:02 | Delaware, Pennsylvania, US | |
3380047 | 3380047 | 2022-12-08 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-09 04:21:05 | Delaware, Pennsylvania, US | |
1987318 | 1987318 | 2022-12-07 | US | Pennsylvania | Delaware | 42045 | 135285 | 2002 | 0 | 39.91680171 | -75.40243663 | 2022-12-08 04:21:07 | Delaware, Pennsylvania, US | |
292221 | 292221 | 2022-11-15 | Russia | Kaliningrad Oblast | 190790 | 2002 | 0 | 54.7293041 | 21.1489473 | 2022-11-16 04:21:09 | Kaliningrad Oblast, Russia | |||
3597251 | 3597251 | 2022-11-14 | Russia | Kaliningrad Oblast | 190761 | 2002 | 0 | 54.7293041 | 21.1489473 | 2022-11-15 04:21:16 | Kaliningrad Oblast, Russia | |||
2323409 | 2323409 | 2022-08-24 | Malaysia | Perak | 221317 | 2002 | 0 | 4.5921 | 101.0901 | 2022-08-25 04:21:13 | Perak, Malaysia | |||
2489730 | 2489730 | 2022-06-29 | Brazil | Acre | 125759 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-30 04:21:01 | Acre, Brazil | |||
2239112 | 2239112 | 2022-06-28 | Brazil | Acre | 125759 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-29 04:20:59 | Acre, Brazil | |||
2147354 | 2147354 | 2022-06-27 | Brazil | Acre | 125592 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-28 04:20:58 | Acre, Brazil | |||
475155 | 475155 | 2022-06-26 | Brazil | Acre | 125500 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-27 04:21:00 | Acre, Brazil | |||
938530 | 938530 | 2022-06-25 | Brazil | Acre | 125500 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-26 04:21:02 | Acre, Brazil | |||
3346350 | 3346350 | 2022-06-24 | Brazil | Acre | 125500 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-25 04:20:57 | Acre, Brazil | |||
1648091 | 1648091 | 2022-06-23 | Brazil | Acre | 125428 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-24 04:20:58 | Acre, Brazil | |||
2187326 | 2187326 | 2022-06-22 | Brazil | Acre | 125354 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-23 04:20:55 | Acre, Brazil | |||
165757 | 165757 | 2022-06-21 | Brazil | Acre | 125263 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-22 04:20:54 | Acre, Brazil | |||
1763040 | 1763040 | 2022-06-20 | Brazil | Acre | 125257 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-21 04:20:56 | Acre, Brazil | |||
3269226 | 3269226 | 2022-06-19 | Brazil | Acre | 125224 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-20 04:21:01 | Acre, Brazil | |||
3397138 | 3397138 | 2022-06-18 | Brazil | Acre | 125224 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-19 04:20:51 | Acre, Brazil | |||
2311015 | 2311015 | 2022-06-17 | Brazil | Acre | 125224 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-18 04:21:10 | Acre, Brazil | |||
558519 | 558519 | 2022-06-16 | Brazil | Acre | 125224 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-17 04:20:56 | Acre, Brazil | |||
3982321 | 3982321 | 2022-06-15 | Brazil | Acre | 125224 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-16 04:20:55 | Acre, Brazil | |||
946562 | 946562 | 2022-06-14 | Brazil | Acre | 125202 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-15 04:20:54 | Acre, Brazil | |||
2978970 | 2978970 | 2022-06-13 | Brazil | Acre | 125179 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-14 04:20:52 | Acre, Brazil | |||
2235096 | 2235096 | 2022-06-12 | Brazil | Acre | 125177 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-13 04:21:14 | Acre, Brazil | |||
3141294 | 3141294 | 2022-06-11 | Brazil | Acre | 125176 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-12 04:20:53 | Acre, Brazil | |||
1944210 | 1944210 | 2022-06-10 | Brazil | Acre | 125164 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-11 04:21:01 | Acre, Brazil | |||
3157349 | 3157349 | 2022-06-09 | Brazil | Acre | 125146 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-10 04:20:55 | Acre, Brazil | |||
1420816 | 1420816 | 2022-06-08 | Brazil | Acre | 125119 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-09 04:20:54 | Acre, Brazil | |||
3725930 | 3725930 | 2022-06-07 | Brazil | Acre | 125119 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-08 04:20:55 | Acre, Brazil | |||
3887332 | 3887332 | 2022-06-06 | Brazil | Acre | 125119 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-07 04:21:08 | Acre, Brazil | |||
3507101 | 3507101 | 2022-06-05 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-06 04:20:57 | Acre, Brazil | |||
3527178 | 3527178 | 2022-06-04 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-05 04:20:55 | Acre, Brazil | |||
3133264 | 3133264 | 2022-06-03 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-04 04:20:58 | Acre, Brazil | |||
3578339 | 3578339 | 2022-06-02 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-03 04:20:58 | Acre, Brazil | |||
970632 | 970632 | 2022-06-01 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-02 05:20:39 | Acre, Brazil | |||
228939 | 228939 | 2022-05-31 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-06-01 04:20:55 | Acre, Brazil | |||
3185704 | 3185704 | 2022-05-30 | Brazil | Acre | 125111 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-31 04:20:51 | Acre, Brazil | |||
3197853 | 3197853 | 2022-05-29 | Brazil | Acre | 124975 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-30 04:20:50 | Acre, Brazil | |||
2724731 | 2724731 | 2022-05-28 | Brazil | Acre | 124975 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-29 04:20:53 | Acre, Brazil | |||
1313912 | 1313912 | 2022-05-27 | Brazil | Acre | 124975 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-28 04:21:07 | Acre, Brazil | |||
1849704 | 1849704 | 2022-05-26 | Brazil | Acre | 124974 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-27 04:20:56 | Acre, Brazil | |||
2047580 | 2047580 | 2022-05-25 | Brazil | Acre | 124974 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-26 04:20:50 | Acre, Brazil | |||
2999018 | 2999018 | 2022-05-24 | Brazil | Acre | 124974 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-25 04:20:56 | Acre, Brazil | |||
3592739 | 3592739 | 2022-05-23 | Brazil | Acre | 124974 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-24 04:20:57 | Acre, Brazil | |||
621591 | 621591 | 2022-05-22 | Brazil | Acre | 124974 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-26 04:20:50 | Acre, Brazil | |||
1109287 | 1109287 | 2022-05-21 | Brazil | Acre | 124973 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-22 04:20:52 | Acre, Brazil | |||
1168911 | 1168911 | 2022-05-20 | Brazil | Acre | 124973 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-21 04:20:58 | Acre, Brazil | |||
3895674 | 3895674 | 2022-05-19 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-20 04:20:57 | Acre, Brazil | |||
1184458 | 1184458 | 2022-05-18 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-19 04:20:54 | Acre, Brazil | |||
3582355 | 3582355 | 2022-05-17 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-18 04:20:50 | Acre, Brazil | |||
1503312 | 1503312 | 2022-05-16 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-17 04:20:59 | Acre, Brazil | |||
2083671 | 2083671 | 2022-05-15 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-16 04:20:47 | Acre, Brazil | |||
3354382 | 3354382 | 2022-05-14 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-15 04:20:53 | Acre, Brazil | |||
658027 | 658027 | 2022-05-13 | Brazil | Acre | 124970 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-14 04:20:48 | Acre, Brazil | |||
2533110 | 2533110 | 2022-05-12 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-13 04:20:51 | Acre, Brazil | |||
3446450 | 3446450 | 2022-05-11 | US | Massachusetts | Suffolk | 25025 | 224692 | 2002 | 0 | 42.3279514 | -71.07850442 | 2022-05-12 04:20:54 | Suffolk, Massachusetts, US | |
3444556 | 3444556 | 2022-05-11 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-12 04:20:54 | Acre, Brazil | |||
3535173 | 3535173 | 2022-05-10 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-11 04:20:48 | Acre, Brazil | |||
221708 | 221708 | 2022-05-09 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-10 04:20:50 | Acre, Brazil | |||
2331093 | 2331093 | 2022-05-08 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-09 04:20:54 | Acre, Brazil | |||
360055 | 360055 | 2022-05-07 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-08 04:20:49 | Acre, Brazil | |||
1397406 | 1397406 | 2022-05-06 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-07 04:21:09 | Acre, Brazil | |||
2597761 | 2597761 | 2022-05-05 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-06 04:21:00 | Acre, Brazil | |||
3265210 | 3265210 | 2022-05-04 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-05 04:20:55 | Acre, Brazil | |||
1571849 | 1571849 | 2022-05-03 | Brazil | Acre | 124969 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-04 04:20:59 | Acre, Brazil | |||
463109 | 463109 | 2022-05-02 | Brazil | Acre | 124921 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-03 04:21:00 | Acre, Brazil | |||
3915748 | 3915748 | 2022-05-01 | Brazil | Acre | 124921 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-02 04:21:10 | Acre, Brazil | |||
2840552 | 2840552 | 2022-04-30 | Brazil | Acre | 124921 | 2002 | 0 | -9.0238 | -70.812 | 2022-05-01 04:20:57 | Acre, Brazil | |||
1156865 | 1156865 | 2022-04-29 | Brazil | Acre | 124918 | 2002 | 0 | -9.0238 | -70.812 | 2022-04-30 04:21:05 | Acre, Brazil | |||
1696047 | 1696047 | 2022-04-28 | Brazil | Acre | 124918 | 2002 | 0 | -9.0238 | -70.812 | 2022-04-29 04:20:59 | Acre, Brazil | |||
3851530 | 3851530 | 2022-04-27 | Brazil | Acre | 124672 | 2002 | 0 | -9.0238 | -70.812 | 2022-04-28 04:20:47 | Acre, Brazil | |||
1325960 | 1325960 | 2022-04-26 | Brazil | Acre | 124672 | 2002 | 0 | -9.0238 | -70.812 | 2022-04-27 04:20:52 | Acre, Brazil | |||
953362 | 953362 | 2022-03-12 | US | Ohio | Montgomery | 39113 | 126376 | 2002 | 0 | 39.75394919 | -84.29050975 | 2022-03-13 04:20:49 | Montgomery, Ohio, US | |
358823 | 358823 | 2022-03-11 | US | Ohio | Montgomery | 39113 | 126364 | 2002 | 0 | 39.75394919 | -84.29050975 | 2022-03-12 04:20:50 | Montgomery, Ohio, US | |
921270 | 921270 | 2022-03-08 | US | Maryland | Montgomery | 24031 | 165707 | 2002 | 0 | 39.13676329 | -77.20358245 | 2022-03-09 04:20:59 | Montgomery, Maryland, US | |
186035 | 186035 | 2022-02-13 | Italy | Calabria | 192175 | 2002 | 0 | 38.90597598 | 16.59440194 | 2022-02-14 04:20:51 | Calabria, Italy | |||
1141180 | 1141180 | 2022-01-23 | Russia | Zabaykalsky Krai | 98758 | 2002 | 0 | 52.248521000000004 | 115.956325 | 2022-01-24 04:21:12 | Zabaykalsky Krai, Russia | |||
3613331 | 3613331 | 2022-01-12 | Russia | Yaroslavl Oblast | 87966 | 2002 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-01-13 08:00:09 | Yaroslavl Oblast, Russia | |||
2167504 | 2167504 | 2022-01-01 | India | Manipur | 125807 | 2002 | 0 | 24.738975 | 93.882541 | 2022-01-02 04:20:52 | Manipur, India | |||
2776935 | 2776935 | 2021-12-31 | India | Manipur | 125788 | 2002 | 0 | 24.738975 | 93.882541 | 2022-01-01 04:22:14 | Manipur, India | |||
3998592 | 3998592 | 2021-12-30 | India | Manipur | 125778 | 2002 | 0 | 24.738975 | 93.882541 | 2021-12-31 04:21:50 | Manipur, India | |||
1668399 | 1668399 | 2021-12-29 | India | Manipur | 125761 | 2002 | 0 | 24.738975 | 93.882541 | 2021-12-30 04:21:25 | Manipur, India | |||
1432508 | 1432508 | 2021-12-28 | India | Manipur | 125747 | 2002 | 0 | 24.738975 | 93.882541 | 2021-12-29 03:21:43 | Manipur, India | |||
730469 | 730469 | 2021-12-27 | India | Manipur | 125732 | 2002 | 0 | 24.738975 | 93.882541 | 2021-12-28 04:21:47 | Manipur, India | |||
1231344 | 1231344 | 2021-11-28 | Brazil | Amapa | 124550 | 2002 | 0 | 0.902 | -52.003 | 2021-11-29 04:22:30 | Amapa, Brazil | |||
1358051 | 1358051 | 2021-11-27 | Brazil | Amapa | 124528 | 2002 | 0 | 0.902 | -52.003 | 2021-11-28 04:22:43 | Amapa, Brazil | |||
758042 | 758042 | 2021-11-26 | Brazil | Amapa | 124500 | 2002 | 0 | 0.902 | -52.003 | 2021-11-27 04:22:45 | Amapa, Brazil | |||
1802459 | 1802459 | 2021-11-25 | Brazil | Amapa | 124438 | 2002 | 0 | 0.902 | -52.003 | 2021-11-26 04:22:33 | Amapa, Brazil | |||
3749507 | 3749507 | 2021-11-22 | US | Alabama | Jefferson | 1073 | 116084 | 2002 | 0 | 33.55554728 | -86.89506300000002 | 2021-11-23 04:22:39 | Jefferson, Alabama, US | |
1014714 | 1014714 | 2021-11-21 | US | Alabama | Jefferson | 1073 | 116056 | 2002 | 0 | 33.55554728 | -86.89506300000002 | 2021-11-22 04:22:20 | Jefferson, Alabama, US | |
722878 | 722878 | 2021-11-20 | US | Alabama | Jefferson | 1073 | 116023 | 2002 | 0 | 33.55554728 | -86.89506300000002 | 2021-11-21 04:22:13 | Jefferson, Alabama, US | |
162408 | 162408 | 2021-11-19 | US | Alabama | Jefferson | 1073 | 115983 | 2002 | 0 | 33.55554728 | -86.89506300000002 | 2021-11-20 04:22:17 | Jefferson, Alabama, US | |
1324465 | 1324465 | 2021-11-14 | US | New York | Erie | 36029 | 115291 | 2002 | 0 | 42.76249024 | -78.73063652 | 2021-11-15 04:21:36 | Erie, New York, US | |
495736 | 495736 | 2021-11-06 | Mexico | Colima | 33199 | 2002 | 0 | 19.1223 | -104.0072 | 2021-11-07 04:21:53 | Colima, Mexico | |||
279629 | 279629 | 2021-11-03 | US | Washington | King | 53033 | 165670 | 2002 | 0 | 47.49137892 | -121.8346131 | 2021-11-04 04:22:20 | King, Washington, 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]);