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

954 rows where country_or_region = "Brazil" and province_or_state = "Amapa" 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

  • Amapa · 954 ✖

country_or_region 1

  • Brazil · 954 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752618 2752618 2022-12-29 Brazil Amapa     182515 2165 0   0.902 -52.003 2022-12-30 04:21:04 Amapa, Brazil
1073624 1073624 2022-12-28 Brazil Amapa     182510 2165 0   0.902 -52.003 2022-12-29 04:21:01 Amapa, Brazil
327621 327621 2022-12-27 Brazil Amapa     182502 2165 0   0.902 -52.003 2022-12-28 04:21:04 Amapa, Brazil
217694 217694 2022-12-26 Brazil Amapa     182501 2165 0   0.902 -52.003 2022-12-27 04:21:07 Amapa, Brazil
3222151 3222151 2022-12-25 Brazil Amapa     182436 2165 0   0.902 -52.003 2022-12-26 04:21:06 Amapa, Brazil
1018065 1018065 2022-12-24 Brazil Amapa     182436 2165 0   0.902 -52.003 2022-12-25 04:21:04 Amapa, Brazil
690088 690088 2022-12-23 Brazil Amapa     182436 2165 0   0.902 -52.003 2022-12-24 04:21:02 Amapa, Brazil
2179298 2179298 2022-12-22 Brazil Amapa     182436 2165 0   0.902 -52.003 2022-12-23 04:21:04 Amapa, Brazil
451102 451102 2022-12-21 Brazil Amapa     182387 2165 0   0.902 -52.003 2022-12-22 04:20:56 Amapa, Brazil
2951101 2951101 2022-12-20 Brazil Amapa     182308 2165 0   0.902 -52.003 2022-12-21 04:21:03 Amapa, Brazil
3173503 3173503 2022-12-19 Brazil Amapa     182291 2165 0   0.902 -52.003 2022-12-20 04:21:04 Amapa, Brazil
1628020 1628020 2022-12-18 Brazil Amapa     182244 2165 0   0.902 -52.003 2022-12-19 04:21:03 Amapa, Brazil
503399 503399 2022-12-17 Brazil Amapa     182244 2165 0   0.902 -52.003 2022-12-18 04:21:03 Amapa, Brazil
3323971 3323971 2022-12-16 Brazil Amapa     182244 2165 0   0.902 -52.003 2022-12-17 04:21:04 Amapa, Brazil
542483 542483 2022-12-15 Brazil Amapa     182228 2165 0   0.902 -52.003 2022-12-16 04:21:01 Amapa, Brazil
348011 348011 2022-12-14 Brazil Amapa     182212 2165 0   0.902 -52.003 2022-12-15 04:20:58 Amapa, Brazil
307599 307599 2022-12-13 Brazil Amapa     182152 2165 0   0.902 -52.003 2022-12-14 04:21:04 Amapa, Brazil
1148660 1148660 2022-12-12 Brazil Amapa     182118 2165 0   0.902 -52.003 2022-12-13 04:21:01 Amapa, Brazil
868514 868514 2022-12-11 Brazil Amapa     182001 2165 0   0.902 -52.003 2022-12-12 04:21:01 Amapa, Brazil
257044 257044 2022-12-10 Brazil Amapa     182001 2165 0   0.902 -52.003 2022-12-11 04:20:50 Amapa, Brazil
3935758 3935758 2022-12-09 Brazil Amapa     182001 2165 0   0.902 -52.003 2022-12-10 04:21:02 Amapa, Brazil
3377090 3377090 2022-12-08 Brazil Amapa     182001 2165 0   0.902 -52.003 2022-12-09 04:21:05 Amapa, Brazil
1984361 1984361 2022-12-07 Brazil Amapa     181766 2165 0   0.902 -52.003 2022-12-08 04:21:07 Amapa, Brazil
3713884 3713884 2022-12-06 Brazil Amapa     181766 2165 0   0.902 -52.003 2022-12-07 04:20:58 Amapa, Brazil
2414589 2414589 2022-12-05 Brazil Amapa     181766 2165 0   0.902 -52.003 2022-12-06 04:21:03 Amapa, Brazil
718197 718197 2022-12-04 Brazil Amapa     181588 2165 0   0.902 -52.003 2022-12-05 04:20:58 Amapa, Brazil
2816486 2816486 2022-12-03 Brazil Amapa     181588 2165 0   0.902 -52.003 2022-12-04 04:20:56 Amapa, Brazil
833342 833342 2022-12-02 Brazil Amapa     181588 2165 0   0.902 -52.003 2022-12-03 04:21:02 Amapa, Brazil
2135872 2135872 2022-12-01 Brazil Amapa     181555 2165 0   0.902 -52.003 2022-12-02 04:21:07 Amapa, Brazil
1964288 1964288 2022-11-30 Brazil Amapa     181359 2165 0   0.902 -52.003 2022-12-01 04:21:03 Amapa, Brazil
2556302 2556302 2022-11-29 Brazil Amapa     181359 2165 0   0.902 -52.003 2022-11-30 04:21:07 Amapa, Brazil
1239376 1239376 2022-11-28 Brazil Amapa     180941 2165 0   0.902 -52.003 2022-11-29 04:21:05 Amapa, Brazil
3551364 3551364 2022-11-27 Brazil Amapa     180941 2165 0   0.902 -52.003 2022-11-28 04:21:02 Amapa, Brazil
2099844 2099844 2022-11-26 Brazil Amapa     180941 2165 0   0.902 -52.003 2022-11-27 04:21:05 Amapa, Brazil
487335 487335 2022-11-25 Brazil Amapa     180941 2165 0   0.902 -52.003 2022-11-26 04:21:11 Amapa, Brazil
3523164 3523164 2022-11-24 Brazil Amapa     180684 2165 0   0.902 -52.003 2022-11-25 04:21:06 Amapa, Brazil
3311947 3311947 2022-11-23 Brazil Amapa     180464 2165 0   0.902 -52.003 2022-11-24 04:21:09 Amapa, Brazil
1619988 1619988 2022-11-22 Brazil Amapa     180171 2165 0   0.902 -52.003 2022-11-23 04:21:06 Amapa, Brazil
3459876 3459876 2022-11-21 Brazil Amapa     179730 2164 0   0.902 -52.003 2022-11-22 04:20:47 Amapa, Brazil
1640061 1640061 2022-11-20 Brazil Amapa     179730 2164 0   0.902 -52.003 2022-11-21 04:21:05 Amapa, Brazil
2063618 2063618 2022-11-19 Brazil Amapa     179730 2164 0   0.902 -52.003 2022-11-20 04:21:08 Amapa, Brazil
1755012 1755012 2022-11-18 Brazil Amapa     179730 2164 0   0.902 -52.003 2022-11-19 04:21:14 Amapa, Brazil
3026005 3026005 2022-11-17 Brazil Amapa     179610 2164 0   0.902 -52.003 2022-11-18 04:21:15 Amapa, Brazil
2485716 2485716 2022-11-16 Brazil Amapa     179338 2164 0   0.902 -52.003 2022-11-17 04:21:11 Amapa, Brazil
291727 291727 2022-11-15 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-16 04:21:09 Amapa, Brazil
3596757 3596757 2022-11-14 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-15 04:21:16 Amapa, Brazil
311615 311615 2022-11-13 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-14 04:21:09 Amapa, Brazil
62776 62776 2022-11-12 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-13 04:21:14 Amapa, Brazil
2926938 2926938 2022-11-11 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-12 04:20:41 Amapa, Brazil
2505774 2505774 2022-11-10 Brazil Amapa     178608 2164 0   0.902 -52.003 2022-11-11 04:21:22 Amapa, Brazil
2430649 2430649 2022-11-09 Brazil Amapa     178516 2164 0   0.902 -52.003 2022-11-10 04:21:16 Amapa, Brazil
479305 479305 2022-11-08 Brazil Amapa     178516 2164 0   0.902 -52.003 2022-11-09 04:21:22 Amapa, Brazil
2438455 2438455 2022-11-07 Brazil Amapa     178516 2164 0   0.902 -52.003 2022-11-08 04:21:21 Amapa, Brazil
1049553 1049553 2022-11-06 Brazil Amapa     178467 2164 0   0.902 -52.003 2022-11-07 04:21:26 Amapa, Brazil
617577 617577 2022-11-05 Brazil Amapa     178467 2164 0   0.902 -52.003 2022-11-06 04:21:24 Amapa, Brazil
1022081 1022081 2022-11-04 Brazil Amapa     178467 2164 0   0.902 -52.003 2022-11-05 04:21:52 Amapa, Brazil
431072 431072 2022-11-03 Brazil Amapa     178457 2164 0   0.902 -52.003 2022-11-04 04:22:11 Amapa, Brazil
849314 849314 2022-11-02 Brazil Amapa     178427 2164 0   0.902 -52.003 2022-11-03 04:22:05 Amapa, Brazil
710165 710165 2022-11-01 Brazil Amapa     178427 2164 0   0.902 -52.003 2022-11-02 04:22:09 Amapa, Brazil
3284614 3284614 2022-10-31 Brazil Amapa     178413 2164 0   0.902 -52.003 2022-11-01 04:22:36 Amapa, Brazil
319647 319647 2022-10-30 Brazil Amapa     178377 2164 0   0.902 -52.003 2022-10-31 04:21:36 Amapa, Brazil
911923 911923 2022-10-29 Brazil Amapa     178377 2164 0   0.902 -52.003 2022-10-30 04:22:14 Amapa, Brazil
1366192 1366192 2022-10-28 Brazil Amapa     178377 2164 0   0.902 -52.003 2022-10-29 04:21:13 Amapa, Brazil
3038047 3038047 2022-10-27 Brazil Amapa     178377 2164 0   0.902 -52.003 2022-10-28 04:22:31 Amapa, Brazil
538467 538467 2022-10-26 Brazil Amapa     178369 2164 0   0.902 -52.003 2022-10-27 04:22:01 Amapa, Brazil
1829868 1829868 2022-10-25 Brazil Amapa     178366 2164 0   0.902 -52.003 2022-10-26 04:22:19 Amapa, Brazil
794129 794129 2022-10-24 Brazil Amapa     178350 2164 0   0.902 -52.003 2022-10-25 04:21:53 Amapa, Brazil
3276584 3276584 2022-10-23 Brazil Amapa     178350 2164 0   0.902 -52.003 2022-10-24 04:22:29 Amapa, Brazil
2267622 2267622 2022-10-22 Brazil Amapa     178350 2164 0   0.902 -52.003 2022-10-23 04:22:46 Amapa, Brazil
1591922 1591922 2022-10-21 Brazil Amapa     178350 2164 0   0.902 -52.003 2022-10-22 04:22:53 Amapa, Brazil
2271638 2271638 2022-10-20 Brazil Amapa     178342 2164 0   0.902 -52.003 2022-10-21 04:22:23 Amapa, Brazil
197973 197973 2022-10-19 Brazil Amapa     178342 2164 0   0.902 -52.003 2022-10-20 04:22:59 Amapa, Brazil
2756634 2756634 2022-10-18 Brazil Amapa     178321 2164 0   0.902 -52.003 2022-10-19 04:22:26 Amapa, Brazil
2024468 2024468 2022-10-17 Brazil Amapa     178321 2164 0   0.902 -52.003 2022-10-18 04:22:42 Amapa, Brazil
2159246 2159246 2022-10-16 Brazil Amapa     178321 2164 0   0.902 -52.003 2022-10-17 04:20:31 Amapa, Brazil
515443 515443 2022-10-15 Brazil Amapa     178321 2164 0   0.902 -52.003 2022-10-16 04:22:39 Amapa, Brazil
2032500 2032500 2022-10-14 Brazil Amapa     178321 2164 0   0.902 -52.003 2022-10-15 04:22:00 Amapa, Brazil
3753188 3753188 2022-10-13 Brazil Amapa     178314 2164 0   0.902 -52.003 2022-10-14 04:22:28 Amapa, Brazil
3214013 3214013 2022-10-12 Brazil Amapa     178311 2164 0   0.902 -52.003 2022-10-13 04:22:39 Amapa, Brazil
3249862 3249862 2022-10-11 Brazil Amapa     178311 2164 0   0.902 -52.003 2022-10-12 04:22:51 Amapa, Brazil
2967121 2967121 2022-10-10 Brazil Amapa     178307 2163 0   0.902 -52.003 2022-10-11 04:23:05 Amapa, Brazil
3097157 3097157 2022-10-09 Brazil Amapa     178286 2163 0   0.902 -52.003 2022-10-10 04:22:32 Amapa, Brazil
4002382 4002382 2022-10-08 Brazil Amapa     178286 2163 0   0.902 -52.003 2022-10-09 04:21:16 Amapa, Brazil
395979 395979 2022-10-07 Brazil Amapa     178286 2163 0   0.902 -52.003 2022-10-08 04:22:56 Amapa, Brazil
2529096 2529096 2022-10-06 Brazil Amapa     178286 2163 0   0.902 -52.003 2022-10-07 04:23:08 Amapa, Brazil
1810490 1810490 2022-10-05 Brazil Amapa     178281 2163 0   0.902 -52.003 2022-10-06 04:21:22 Amapa, Brazil
130464 130464 2022-10-04 Brazil Amapa     178277 2163 0   0.902 -52.003 2022-10-05 04:23:06 Amapa, Brazil
2685411 2685411 2022-10-03 Brazil Amapa     178277 2163 0   0.902 -52.003 2022-10-04 04:22:55 Amapa, Brazil
2259478 2259478 2022-10-02 Brazil Amapa     178276 2163 0   0.902 -52.003 2022-10-03 04:23:11 Amapa, Brazil
2995004 2995004 2022-10-01 Brazil Amapa     178276 2163 0   0.902 -52.003 2022-10-02 04:21:23 Amapa, Brazil
853330 853330 2022-09-30 Brazil Amapa     178276 2163 0   0.902 -52.003 2022-10-01 04:23:01 Amapa, Brazil
2375256 2375256 2022-09-29 Brazil Amapa     178272 2163 0   0.902 -52.003 2022-09-30 04:23:09 Amapa, Brazil
1559807 1559807 2022-09-28 Brazil Amapa     178272 2163 0   0.902 -52.003 2022-09-29 04:22:34 Amapa, Brazil
3994350 3994350 2022-09-27 Brazil Amapa     178265 2163 0   0.902 -52.003 2022-09-28 04:23:01 Amapa, Brazil
2768678 2768678 2022-09-26 Brazil Amapa     178265 2163 0   0.902 -52.003 2022-09-27 04:23:01 Amapa, Brazil
1976331 1976331 2022-09-25 Brazil Amapa     178261 2163 0   0.902 -52.003 2022-09-26 04:20:52 Amapa, Brazil
2649498 2649498 2022-09-24 Brazil Amapa     178261 2163 0   0.902 -52.003 2022-09-25 04:23:31 Amapa, Brazil
383938 383938 2022-09-23 Brazil Amapa     178261 2163 0   0.902 -52.003 2022-09-24 04:21:40 Amapa, Brazil
1624004 1624004 2022-09-22 Brazil Amapa     178260 2163 0   0.902 -52.003 2022-09-23 04:23:13 Amapa, Brazil
1370208 1370208 2022-09-21 Brazil Amapa     178224 2163 0   0.902 -52.003 2022-09-22 04:22:56 Amapa, Brazil

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