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 = "Loreto" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237526 | 3237526 | 2020-07-10 | Peru | Loreto | 9727 | 2347 | 0 | 7380 | -4.124847 | -74.424115 | 2020-07-11 04:34:26 | Loreto, Peru | ||
1005511 | 1005511 | 2020-07-09 | Peru | Loreto | 9656 | 2340 | 0 | 7316 | -4.124847 | -74.424115 | 2020-07-10 04:34:24 | Loreto, Peru | ||
2222727 | 2222727 | 2020-07-08 | Peru | Loreto | 9598 | 2335 | 0 | 7263 | -4.124847 | -74.424115 | 2020-07-09 04:34:23 | Loreto, Peru | ||
887336 | 887336 | 2020-07-07 | Peru | Loreto | 9498 | 2327 | 0 | 7171 | -4.124847 | -74.424115 | 2020-07-08 05:33:48 | Loreto, Peru | ||
2684896 | 2684896 | 2020-07-06 | Peru | Loreto | 9404 | 2316 | 0 | 7088 | -4.124847 | -74.424115 | 2020-07-07 04:34:00 | Loreto, Peru | ||
415361 | 415361 | 2020-07-05 | Peru | Loreto | 9374 | 2310 | 0 | 7064 | -4.124847 | -74.424115 | 2020-07-06 04:33:57 | Loreto, Peru | ||
529923 | 529923 | 2020-07-04 | Peru | Loreto | 9343 | 2301 | 0 | 7042 | -4.124847 | -74.424115 | 2020-07-05 04:33:46 | Loreto, Peru | ||
2234584 | 2234584 | 2020-07-03 | Peru | Loreto | 9280 | 2297 | 0 | 6983 | -4.124847 | -74.424115 | 2020-07-04 04:33:51 | Loreto, Peru | ||
3045378 | 3045378 | 2020-07-02 | Peru | Loreto | 9162 | 2288 | 0 | 6874 | -4.124847 | -74.424115 | 2020-07-03 04:33:54 | Loreto, Peru | ||
303069 | 303069 | 2020-07-01 | Peru | Loreto | 9072 | 2283 | 0 | 6789 | -4.124847 | -74.424115 | 2020-07-02 04:33:46 | Loreto, Peru | ||
2974447 | 2974447 | 2020-06-30 | Peru | Loreto | 9023 | 2277 | 0 | 6746 | -4.124847 | -74.424115 | 2020-07-01 04:33:52 | Loreto, Peru | ||
2632924 | 2632924 | 2020-06-29 | Peru | Loreto | 8955 | 2271 | 0 | 6684 | -4.124847 | -74.424115 | 2020-06-30 04:33:48 | Loreto, Peru | ||
2306487 | 2306487 | 2020-06-28 | Peru | Loreto | 8904 | 2260 | 0 | 6644 | -4.124847 | -74.424115 | 2020-06-29 04:33:44 | Loreto, Peru | ||
2039822 | 2039822 | 2020-06-27 | Peru | Loreto | 8835 | 2246 | 0 | 6589 | -4.124847 | -74.424115 | 2020-06-28 04:34:04 | Loreto, Peru | ||
1136103 | 1136103 | 2020-06-26 | Peru | Loreto | 8786 | 2233 | 0 | 6553 | -4.124847 | -74.424115 | 2020-06-27 04:33:35 | Loreto, Peru | ||
2625090 | 2625090 | 2020-06-25 | Peru | Loreto | 8743 | 2225 | 0 | 6518 | -4.124847 | -74.424115 | 2020-06-26 04:33:43 | Loreto, Peru | ||
2700730 | 2700730 | 2020-06-24 | Peru | Loreto | 8681 | 2217 | 0 | 6464 | -4.124847 | -74.424115 | 2020-06-25 05:26:54 | Loreto, Peru | ||
1522415 | 1522415 | 2020-06-23 | Peru | Loreto | 8449 | 2209 | 0 | 6240 | -4.124847 | -74.424115 | 2020-06-24 04:33:28 | Loreto, Peru | ||
1510609 | 1510609 | 2020-06-22 | Peru | Loreto | 8364 | 2198 | 0 | 6166 | -4.124847 | -74.424115 | 2020-06-23 04:33:22 | Loreto, Peru | ||
3249348 | 3249348 | 2020-06-21 | Peru | Loreto | 8195 | 2190 | 0 | 6005 | -4.124847 | -74.424115 | 2020-06-22 04:33:20 | Loreto, Peru | ||
2437941 | 2437941 | 2020-06-20 | Peru | Loreto | 8195 | 2182 | 0 | 6013 | -4.124847 | -74.424115 | 2020-06-21 04:33:19 | Loreto, Peru | ||
1691519 | 1691519 | 2020-06-19 | Peru | Loreto | 8051 | 2172 | 0 | 5879 | -4.124847 | -74.424115 | 2020-06-20 04:33:19 | Loreto, Peru | ||
3682668 | 3682668 | 2020-06-18 | Peru | Loreto | 7953 | 2155 | 0 | 5798 | -4.124847 | -74.424115 | 2020-06-19 04:33:17 | Loreto, Peru | ||
1195871 | 1195871 | 2020-06-17 | Peru | Loreto | 7849 | 2140 | 0 | 5709 | -4.124847 | -74.424115 | 2020-06-18 04:33:18 | Loreto, Peru | ||
2386634 | 2386634 | 2020-06-16 | Peru | Loreto | 7781 | 2129 | 0 | 5652 | -4.124847 | -74.424115 | 2020-06-17 04:33:21 | Loreto, Peru | ||
287197 | 287197 | 2020-06-15 | Peru | Loreto | 7737 | 2115 | 0 | 5622 | -4.124847 | -74.424115 | 2020-06-16 04:33:09 | Loreto, Peru | ||
1837148 | 1837148 | 2020-06-14 | Peru | Loreto | 7629 | 2101 | 0 | 5528 | -4.124847 | -74.424115 | 2020-06-15 03:33:14 | Loreto, Peru | ||
3061200 | 3061200 | 2020-06-13 | Peru | Loreto | 7167 | 2092 | 0 | 5075 | -4.124847 | -74.424115 | 2020-06-14 03:33:15 | Loreto, Peru | ||
737520 | 737520 | 2020-06-12 | Peru | Loreto | 7000 | 2075 | 0 | 4925 | -4.124847 | -74.424115 | 2020-06-13 03:33:14 | Loreto, Peru | ||
1273490 | 1273490 | 2020-06-11 | Peru | Loreto | 7000 | 2060 | 0 | 4940 | -4.124847 | -74.424115 | 2020-06-12 05:09:52 | Loreto, Peru | ||
2863933 | 2863933 | 2020-06-10 | Peru | Loreto | 6719 | 2040 | 0 | 4679 | -4.124847 | -74.424115 | 2020-06-11 03:33:41 | Loreto, Peru | ||
1210770 | 1210770 | 2020-06-09 | Peru | Loreto | 6506 | 2017 | 0 | 4489 | -4.124847 | -74.424115 | 2020-06-10 04:07:00 | Loreto, Peru | ||
217197 | 217197 | 2020-06-08 | Peru | Loreto | 6349 | 1994 | 0 | 4355 | -4.124847 | -74.424115 | 2020-06-09 03:33:03 | Loreto, Peru | ||
2799993 | 2799993 | 2020-06-07 | Peru | Loreto | 6225 | 1984 | 0 | 4241 | -4.124847 | -74.424115 | 2020-06-08 03:33:22 | Loreto, Peru | ||
574049 | 574049 | 2020-06-06 | Peru | Loreto | 6187 | 1971 | 0 | 4216 | -4.124847 | -74.424115 | 2020-06-07 03:53:30 | Loreto, Peru | ||
1269746 | 1269746 | 2020-06-05 | Peru | Loreto | 6172 | 1948 | 0 | 4224 | -4.124847 | -74.424115 | 2020-06-06 02:33:00 | Loreto, Peru | ||
1281218 | 1281218 | 2020-06-04 | Peru | Loreto | 5757 | 1929 | 0 | 3828 | -4.124847 | -74.424115 | 2020-06-05 02:33:06 | Loreto, Peru | ||
3866773 | 3866773 | 2020-06-03 | Peru | Loreto | 5517 | 1917 | 0 | 3600 | -4.124847 | -74.424115 | 2020-06-04 02:33:14 | Loreto, Peru | ||
2555815 | 2555815 | 2020-06-02 | Peru | Loreto | 5355 | 1906 | 0 | 3449 | -4.124847 | -74.424115 | 2020-06-03 02:33:13 | Loreto, Peru | ||
805352 | 805352 | 2020-06-01 | Peru | Loreto | 5133 | 1877 | 0 | 3256 | -4.124847 | -74.424115 | 2020-06-02 02:33:08 | Loreto, Peru | ||
1793945 | 1793945 | 2020-05-31 | Peru | Loreto | 4715 | 1859 | 0 | 2856 | -4.124847 | -74.424115 | 2020-06-01 02:32:46 | Loreto, Peru | ||
3638838 | 3638838 | 2020-05-30 | Peru | Loreto | 4635 | 1839 | 0 | 2796 | -4.124847 | -74.424115 | 2020-05-31 02:32:45 | Loreto, Peru | ||
1790379 | 1790379 | 2020-05-29 | Peru | Loreto | 3959 | 1820 | 0 | 2139 | -4.124847 | -74.424115 | 2020-05-30 02:32:48 | Loreto, Peru | ||
2712258 | 2712258 | 2020-05-28 | Peru | Loreto | 3959 | 1792 | 0 | 2167 | -4.124847 | -74.424115 | 2020-05-29 02:32:50 | Loreto, 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]);