johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

946 rows where country_or_region = "Peru" and province_or_state = "La Libertad" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • La Libertad · 946 ✖

country_or_region 1

  • Peru · 946 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2753073 2753073 2022-12-29 Peru La Libertad     180183 10967 0   -7.92139 -78.370238 2022-12-30 04:21:04 La Libertad, Peru
1074079 1074079 2022-12-28 Peru La Libertad     180183 10967 0   -7.92139 -78.370238 2022-12-29 04:21:01 La Libertad, Peru
328076 328076 2022-12-27 Peru La Libertad     180183 10967 0   -7.92139 -78.370238 2022-12-28 04:21:04 La Libertad, Peru
218149 218149 2022-12-26 Peru La Libertad     180183 10967 0   -7.92139 -78.370238 2022-12-27 04:21:07 La Libertad, Peru
3222606 3222606 2022-12-25 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-26 04:21:06 La Libertad, Peru
1018520 1018520 2022-12-24 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-25 04:21:04 La Libertad, Peru
690543 690543 2022-12-23 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-24 04:21:02 La Libertad, Peru
2179753 2179753 2022-12-22 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-23 04:21:04 La Libertad, Peru
451557 451557 2022-12-21 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-22 04:20:56 La Libertad, Peru
2951556 2951556 2022-12-20 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-21 04:21:03 La Libertad, Peru
3173958 3173958 2022-12-19 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-20 04:21:04 La Libertad, Peru
1628475 1628475 2022-12-18 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-19 04:21:03 La Libertad, Peru
503854 503854 2022-12-17 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-18 04:21:03 La Libertad, Peru
3324426 3324426 2022-12-16 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-17 04:21:04 La Libertad, Peru
542938 542938 2022-12-15 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-16 04:21:01 La Libertad, Peru
348466 348466 2022-12-14 Peru La Libertad     176161 10947 0   -7.92139 -78.370238 2022-12-15 04:20:58 La Libertad, Peru
308054 308054 2022-12-13 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-14 04:21:04 La Libertad, Peru
1149115 1149115 2022-12-12 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-13 04:21:01 La Libertad, Peru
868969 868969 2022-12-11 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-12 04:21:01 La Libertad, Peru
257499 257499 2022-12-10 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-11 04:20:50 La Libertad, Peru
3936213 3936213 2022-12-09 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-10 04:21:02 La Libertad, Peru
3377545 3377545 2022-12-08 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-09 04:21:05 La Libertad, Peru
1984816 1984816 2022-12-07 Peru La Libertad     172302 10943 0   -7.92139 -78.370238 2022-12-08 04:21:07 La Libertad, Peru
3714339 3714339 2022-12-06 Peru La Libertad     170320 10943 0   -7.92139 -78.370238 2022-12-07 04:20:58 La Libertad, Peru
2415044 2415044 2022-12-05 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-12-06 04:21:03 La Libertad, Peru
718652 718652 2022-12-04 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-12-05 04:20:58 La Libertad, Peru
2816941 2816941 2022-12-03 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-12-04 04:20:56 La Libertad, Peru
833797 833797 2022-12-02 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-12-03 04:21:02 La Libertad, Peru
2136327 2136327 2022-12-01 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-12-02 04:21:07 La Libertad, Peru
1964743 1964743 2022-11-30 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-12-01 04:21:03 La Libertad, Peru
2556757 2556757 2022-11-29 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-11-30 04:21:07 La Libertad, Peru
1239831 1239831 2022-11-28 Peru La Libertad     170320 11055 0   -7.92139 -78.370238 2022-11-29 04:21:05 La Libertad, Peru
3551819 3551819 2022-11-27 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-28 04:21:02 La Libertad, Peru
2100299 2100299 2022-11-26 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-27 04:21:05 La Libertad, Peru
487790 487790 2022-11-25 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-26 04:21:11 La Libertad, Peru
3523619 3523619 2022-11-24 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-25 04:21:06 La Libertad, Peru
3312402 3312402 2022-11-23 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-24 04:21:09 La Libertad, Peru
1620443 1620443 2022-11-22 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-23 04:21:06 La Libertad, Peru
3460331 3460331 2022-11-21 Peru La Libertad     169780 11051 0   -7.92139 -78.370238 2022-11-22 04:20:47 La Libertad, Peru
1640516 1640516 2022-11-20 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-21 04:21:05 La Libertad, Peru
2064073 2064073 2022-11-19 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-20 04:21:08 La Libertad, Peru
1755467 1755467 2022-11-18 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-19 04:21:14 La Libertad, Peru
3026460 3026460 2022-11-17 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-18 04:21:15 La Libertad, Peru
2486171 2486171 2022-11-16 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-17 04:21:11 La Libertad, Peru
292182 292182 2022-11-15 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-16 04:21:09 La Libertad, Peru
3597212 3597212 2022-11-14 Peru La Libertad     169550 11046 0   -7.92139 -78.370238 2022-11-15 04:21:16 La Libertad, Peru
312070 312070 2022-11-13 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-14 04:21:09 La Libertad, Peru
63231 63231 2022-11-12 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-13 04:21:14 La Libertad, Peru
2927393 2927393 2022-11-11 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-12 04:20:41 La Libertad, Peru
2506229 2506229 2022-11-10 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-11 04:21:22 La Libertad, Peru
2431104 2431104 2022-11-09 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-10 04:21:16 La Libertad, Peru
479760 479760 2022-11-08 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-09 04:21:22 La Libertad, Peru
2438910 2438910 2022-11-07 Peru La Libertad     169327 11045 0   -7.92139 -78.370238 2022-11-08 04:21:21 La Libertad, Peru
1050008 1050008 2022-11-06 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-07 04:21:26 La Libertad, Peru
618032 618032 2022-11-05 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-06 04:21:24 La Libertad, Peru
1022536 1022536 2022-11-04 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-05 04:21:52 La Libertad, Peru
431527 431527 2022-11-03 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-04 04:22:11 La Libertad, Peru
849769 849769 2022-11-02 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-03 04:22:05 La Libertad, Peru
710620 710620 2022-11-01 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-02 04:22:09 La Libertad, Peru
3285069 3285069 2022-10-31 Peru La Libertad     169230 11042 0   -7.92139 -78.370238 2022-11-01 04:22:36 La Libertad, Peru
320102 320102 2022-10-30 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-31 04:21:36 La Libertad, Peru
912378 912378 2022-10-29 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-30 04:22:14 La Libertad, Peru
1366647 1366647 2022-10-28 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-29 04:21:13 La Libertad, Peru
3038502 3038502 2022-10-27 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-28 04:22:31 La Libertad, Peru
538922 538922 2022-10-26 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-27 04:22:01 La Libertad, Peru
1830323 1830323 2022-10-25 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-26 04:22:19 La Libertad, Peru
794584 794584 2022-10-24 Peru La Libertad     169174 11043 0   -7.92139 -78.370238 2022-10-25 04:21:53 La Libertad, Peru
3277039 3277039 2022-10-23 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-24 04:22:29 La Libertad, Peru
2268077 2268077 2022-10-22 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-23 04:22:46 La Libertad, Peru
1592377 1592377 2022-10-21 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-22 04:22:53 La Libertad, Peru
2272093 2272093 2022-10-20 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-21 04:22:23 La Libertad, Peru
198428 198428 2022-10-19 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-20 04:22:59 La Libertad, Peru
2757089 2757089 2022-10-18 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-19 04:22:26 La Libertad, Peru
2024923 2024923 2022-10-17 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-18 04:22:42 La Libertad, Peru
2159701 2159701 2022-10-16 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-17 04:20:31 La Libertad, Peru
515898 515898 2022-10-15 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-16 04:22:39 La Libertad, Peru
2032955 2032955 2022-10-14 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-15 04:22:00 La Libertad, Peru
3753643 3753643 2022-10-13 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-14 04:22:28 La Libertad, Peru
3214468 3214468 2022-10-12 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-13 04:22:39 La Libertad, Peru
3250317 3250317 2022-10-11 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-12 04:22:51 La Libertad, Peru
2967576 2967576 2022-10-10 Peru La Libertad     169089 11036 0   -7.92139 -78.370238 2022-10-11 04:23:05 La Libertad, Peru
3097612 3097612 2022-10-09 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-10 04:22:32 La Libertad, Peru
4002837 4002837 2022-10-08 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-09 04:21:16 La Libertad, Peru
396434 396434 2022-10-07 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-08 04:22:56 La Libertad, Peru
2529551 2529551 2022-10-06 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-07 04:23:08 La Libertad, Peru
1810945 1810945 2022-10-05 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-06 04:21:22 La Libertad, Peru
130919 130919 2022-10-04 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-05 04:23:06 La Libertad, Peru
2685866 2685866 2022-10-03 Peru La Libertad     169039 11030 0   -7.92139 -78.370238 2022-10-04 04:22:55 La Libertad, Peru
2259933 2259933 2022-10-02 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-10-03 04:23:11 La Libertad, Peru
2995459 2995459 2022-10-01 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-10-02 04:21:23 La Libertad, Peru
853785 853785 2022-09-30 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-10-01 04:23:01 La Libertad, Peru
2375711 2375711 2022-09-29 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-09-30 04:23:09 La Libertad, Peru
1560262 1560262 2022-09-28 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-09-29 04:22:34 La Libertad, Peru
3994805 3994805 2022-09-27 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-09-28 04:23:01 La Libertad, Peru
2769133 2769133 2022-09-26 Peru La Libertad     168960 11025 0   -7.92139 -78.370238 2022-09-27 04:23:01 La Libertad, Peru
1976786 1976786 2022-09-25 Peru La Libertad     168701 11020 0   -7.92139 -78.370238 2022-09-26 04:20:52 La Libertad, Peru
2649953 2649953 2022-09-24 Peru La Libertad     168701 11020 0   -7.92139 -78.370238 2022-09-25 04:23:31 La Libertad, Peru
384393 384393 2022-09-23 Peru La Libertad     168701 11020 0   -7.92139 -78.370238 2022-09-24 04:21:40 La Libertad, Peru
1624459 1624459 2022-09-22 Peru La Libertad     168701 11020 0   -7.92139 -78.370238 2022-09-23 04:23:13 La Libertad, Peru
1370663 1370663 2022-09-21 Peru La Libertad     168701 11020 0   -7.92139 -78.370238 2022-09-22 04:22:56 La Libertad, Peru

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);