johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Peru" and province_or_state = "Ica" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237460 | 3237460 | 2020-07-10 | Peru | Ica | 9140 | 1620 | 0 | 7520 | -14.235097 | -75.574821 | 2020-07-11 04:34:26 | Ica, Peru | ||
1005445 | 1005445 | 2020-07-09 | Peru | Ica | 8997 | 1586 | 0 | 7411 | -14.235097 | -75.574821 | 2020-07-10 04:34:24 | Ica, Peru | ||
2222661 | 2222661 | 2020-07-08 | Peru | Ica | 8783 | 1563 | 0 | 7220 | -14.235097 | -75.574821 | 2020-07-09 04:34:23 | Ica, Peru | ||
887270 | 887270 | 2020-07-07 | Peru | Ica | 8704 | 1525 | 0 | 7179 | -14.235097 | -75.574821 | 2020-07-08 05:33:48 | Ica, Peru | ||
2684830 | 2684830 | 2020-07-06 | Peru | Ica | 8507 | 1494 | 0 | 7013 | -14.235097 | -75.574821 | 2020-07-07 04:34:00 | Ica, Peru | ||
415295 | 415295 | 2020-07-05 | Peru | Ica | 8314 | 1465 | 0 | 6849 | -14.235097 | -75.574821 | 2020-07-06 04:33:57 | Ica, Peru | ||
529857 | 529857 | 2020-07-04 | Peru | Ica | 8195 | 1426 | 0 | 6769 | -14.235097 | -75.574821 | 2020-07-05 04:33:46 | Ica, Peru | ||
2234518 | 2234518 | 2020-07-03 | Peru | Ica | 8072 | 1395 | 0 | 6677 | -14.235097 | -75.574821 | 2020-07-04 04:33:51 | Ica, Peru | ||
3045312 | 3045312 | 2020-07-02 | Peru | Ica | 7850 | 1376 | 0 | 6474 | -14.235097 | -75.574821 | 2020-07-03 04:33:54 | Ica, Peru | ||
303003 | 303003 | 2020-07-01 | Peru | Ica | 7727 | 1339 | 0 | 6388 | -14.235097 | -75.574821 | 2020-07-02 04:33:46 | Ica, Peru | ||
2974381 | 2974381 | 2020-06-30 | Peru | Ica | 7588 | 1315 | 0 | 6273 | -14.235097 | -75.574821 | 2020-07-01 04:33:52 | Ica, Peru | ||
2632858 | 2632858 | 2020-06-29 | Peru | Ica | 7407 | 1294 | 0 | 6113 | -14.235097 | -75.574821 | 2020-06-30 04:33:48 | Ica, Peru | ||
2306421 | 2306421 | 2020-06-28 | Peru | Ica | 7121 | 1270 | 0 | 5851 | -14.235097 | -75.574821 | 2020-06-29 04:33:44 | Ica, Peru | ||
2039756 | 2039756 | 2020-06-27 | Peru | Ica | 6981 | 1247 | 0 | 5734 | -14.235097 | -75.574821 | 2020-06-28 04:34:04 | Ica, Peru | ||
1136037 | 1136037 | 2020-06-26 | Peru | Ica | 6851 | 1227 | 0 | 5624 | -14.235097 | -75.574821 | 2020-06-27 04:33:35 | Ica, Peru | ||
2625024 | 2625024 | 2020-06-25 | Peru | Ica | 6723 | 1201 | 0 | 5522 | -14.235097 | -75.574821 | 2020-06-26 04:33:43 | Ica, Peru | ||
2700664 | 2700664 | 2020-06-24 | Peru | Ica | 6585 | 1176 | 0 | 5409 | -14.235097 | -75.574821 | 2020-06-25 05:26:54 | Ica, Peru | ||
1522349 | 1522349 | 2020-06-23 | Peru | Ica | 6397 | 1149 | 0 | 5248 | -14.235097 | -75.574821 | 2020-06-24 04:33:28 | Ica, Peru | ||
1510543 | 1510543 | 2020-06-22 | Peru | Ica | 6253 | 1124 | 0 | 5129 | -14.235097 | -75.574821 | 2020-06-23 04:33:22 | Ica, Peru | ||
3249282 | 3249282 | 2020-06-21 | Peru | Ica | 6048 | 1093 | 0 | 4955 | -14.235097 | -75.574821 | 2020-06-22 04:33:20 | Ica, Peru | ||
2437875 | 2437875 | 2020-06-20 | Peru | Ica | 6048 | 1057 | 0 | 4991 | -14.235097 | -75.574821 | 2020-06-21 04:33:19 | Ica, Peru | ||
1691453 | 1691453 | 2020-06-19 | Peru | Ica | 5968 | 1035 | 0 | 4933 | -14.235097 | -75.574821 | 2020-06-20 04:33:19 | Ica, Peru | ||
3682602 | 3682602 | 2020-06-18 | Peru | Ica | 5865 | 1006 | 0 | 4859 | -14.235097 | -75.574821 | 2020-06-19 04:33:17 | Ica, Peru | ||
1195805 | 1195805 | 2020-06-17 | Peru | Ica | 5745 | 977 | 0 | 4768 | -14.235097 | -75.574821 | 2020-06-18 04:33:18 | Ica, Peru | ||
2386568 | 2386568 | 2020-06-16 | Peru | Ica | 5653 | 946 | 0 | 4707 | -14.235097 | -75.574821 | 2020-06-17 04:33:21 | Ica, Peru | ||
287131 | 287131 | 2020-06-15 | Peru | Ica | 5534 | 928 | 0 | 4606 | -14.235097 | -75.574821 | 2020-06-16 04:33:09 | Ica, Peru | ||
1837082 | 1837082 | 2020-06-14 | Peru | Ica | 5456 | 896 | 0 | 4560 | -14.235097 | -75.574821 | 2020-06-15 03:33:14 | Ica, Peru | ||
3061134 | 3061134 | 2020-06-13 | Peru | Ica | 5101 | 868 | 0 | 4233 | -14.235097 | -75.574821 | 2020-06-14 03:33:15 | Ica, Peru | ||
737454 | 737454 | 2020-06-12 | Peru | Ica | 4893 | 848 | 0 | 4045 | -14.235097 | -75.574821 | 2020-06-13 03:33:14 | Ica, Peru | ||
1273424 | 1273424 | 2020-06-11 | Peru | Ica | 4893 | 821 | 0 | 4072 | -14.235097 | -75.574821 | 2020-06-12 05:09:52 | Ica, Peru | ||
2863867 | 2863867 | 2020-06-10 | Peru | Ica | 4713 | 784 | 0 | 3929 | -14.235097 | -75.574821 | 2020-06-11 03:33:41 | Ica, Peru | ||
1210711 | 1210711 | 2020-06-09 | Peru | Ica | 4530 | 759 | 0 | 3771 | -14.235097 | -75.574821 | 2020-06-10 04:07:00 | Ica, Peru | ||
217138 | 217138 | 2020-06-08 | Peru | Ica | 4375 | 731 | 0 | 3644 | -14.235097 | -75.574821 | 2020-06-09 03:33:03 | Ica, Peru | ||
2799934 | 2799934 | 2020-06-07 | Peru | Ica | 4330 | 696 | 0 | 3634 | -14.235097 | -75.574821 | 2020-06-08 03:33:22 | Ica, Peru | ||
573990 | 573990 | 2020-06-06 | Peru | Ica | 4187 | 668 | 0 | 3519 | -14.235097 | -75.574821 | 2020-06-07 03:53:30 | Ica, Peru | ||
1269687 | 1269687 | 2020-06-05 | Peru | Ica | 4020 | 647 | 0 | 3373 | -14.235097 | -75.574821 | 2020-06-06 02:33:00 | Ica, Peru | ||
1281163 | 1281163 | 2020-06-04 | Peru | Ica | 3919 | 620 | 0 | 3299 | -14.235097 | -75.574821 | 2020-06-05 02:33:06 | Ica, Peru | ||
3866718 | 3866718 | 2020-06-03 | Peru | Ica | 3851 | 587 | 0 | 3264 | -14.235097 | -75.574821 | 2020-06-04 02:33:14 | Ica, Peru | ||
2555760 | 2555760 | 2020-06-02 | Peru | Ica | 3536 | 569 | 0 | 2967 | -14.235097 | -75.574821 | 2020-06-03 02:33:13 | Ica, Peru | ||
805297 | 805297 | 2020-06-01 | Peru | Ica | 3450 | 534 | 0 | 2916 | -14.235097 | -75.574821 | 2020-06-02 02:33:08 | Ica, Peru | ||
1793921 | 1793921 | 2020-05-31 | Peru | Ica | 3334 | 504 | 0 | 2830 | -14.235097 | -75.574821 | 2020-06-01 02:32:46 | Ica, Peru | ||
3638814 | 3638814 | 2020-05-30 | Peru | Ica | 2789 | 483 | 0 | 2306 | -14.235097 | -75.574821 | 2020-05-31 02:32:45 | Ica, Peru | ||
1790355 | 1790355 | 2020-05-29 | Peru | Ica | 2662 | 455 | 0 | 2207 | -14.235097 | -75.574821 | 2020-05-30 02:32:48 | Ica, Peru | ||
2712234 | 2712234 | 2020-05-28 | Peru | Ica | 2662 | 440 | 0 | 2222 | -14.235097 | -75.574821 | 2020-05-29 02:32:50 | Ica, Peru |
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]);