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 province_or_state = "Amapa" sorted by rowid

✎ 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

Link rowid ▼ day country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
44 44 2021-12-02 Brazil Amapa     124755 2004 0   0.902 -52.003 2021-12-03 04:23:05 Amapa, Brazil
4060 4060 2021-10-28 Brazil Amapa     123549 1991 0   0.902 -52.003 2021-10-29 04:22:03 Amapa, Brazil
8065 8065 2020-10-25 Brazil Amapa     51127 741 36905 13481 0.902 -52.003 2020-10-26 04:25:02 Amapa, Brazil
12071 12071 2021-01-26 Brazil Amapa     75641 1036 57192 17413 0.902 -52.003 2021-01-27 05:23:41 Amapa, Brazil
16085 16085 2021-09-18 Brazil Amapa     122664 1969 0   0.902 -52.003 2021-09-19 04:21:34 Amapa, Brazil
20100 20100 2021-05-28 Brazil Amapa     111524 1685 87050 22789 0.902 -52.003 2021-05-29 04:20:41 Amapa, Brazil
24115 24115 2022-03-20 Brazil Amapa     160260 2120 0   0.902 -52.003 2022-03-21 04:20:50 Amapa, Brazil
28130 28130 2021-11-11 Brazil Amapa     123967 1994 0   0.902 -52.003 2021-11-12 04:22:01 Amapa, Brazil
32146 32146 2021-08-25 Brazil Amapa     122333 1949 0   0.902 -52.003 2021-08-26 04:21:28 Amapa, Brazil
36160 36160 2021-04-12 Brazil Amapa     101647 1402 74102 26143 0.902 -52.003 2021-04-13 04:20:37 Amapa, Brazil
43422 43422 2021-11-02 Brazil Amapa     123674 1993 0   0.902 -52.003 2021-11-03 06:22:09 Amapa, Brazil
50521 50521 2021-05-29 Brazil Amapa     111763 1688 87050 23025 0.902 -52.003 2021-05-30 04:20:55 Amapa, Brazil
54535 54535 2021-03-07 Brazil Amapa     85578 1156 65267 19155 0.902 -52.003 2021-03-08 05:24:48 Amapa, Brazil
61750 61750 2020-07-23 Brazil Amapa     34838 548 23107 11183 0.902 -52.003 2020-07-24 05:30:40 Amapa, Brazil
62776 62776 2022-11-12 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-13 04:21:14 Amapa, Brazil
66791 66791 2021-09-01 Brazil Amapa     122439 1953 0   0.902 -52.003 2021-09-02 04:21:15 Amapa, Brazil
70805 70805 2022-02-07 Brazil Amapa     157127 2059 0   0.902 -52.003 2022-02-08 04:21:15 Amapa, Brazil
74821 74821 2020-12-03 Brazil Amapa     60391 819 47357 12215 0.902 -52.003 2020-12-04 05:27:27 Amapa, Brazil
78821 78821 2020-10-14 Brazil Amapa     49745 728 36905 12112 0.902 -52.003 2020-10-15 04:24:28 Amapa, Brazil
82825 82825 2021-05-25 Brazil Amapa     110853 1666 82294 26893 0.902 -52.003 2021-05-26 04:20:35 Amapa, Brazil
86839 86839 2021-11-09 Brazil Amapa     123894 1993 0   0.902 -52.003 2021-11-10 04:21:38 Amapa, Brazil
90856 90856 2022-07-23 Brazil Amapa     173935 2149 0   0.902 -52.003 2022-07-24 04:20:47 Amapa, Brazil
98081 98081 2020-08-04 Brazil Amapa     36999 581 25138 11280 0.902 -52.003 2020-08-05 04:34:43 Amapa, Brazil
99040 99040 2022-01-14 Brazil Amapa     128571 2030 0   0.902 -52.003 2022-01-15 04:21:07 Amapa, Brazil
103056 103056 2021-08-15 Brazil Amapa     122034 1936 0   0.902 -52.003 2021-08-16 04:21:31 Amapa, Brazil
107181 107181 2021-06-19 Brazil Amapa     115516 1793 92769 20954 0.902 -52.003 2021-06-20 04:21:48 Amapa, Brazil
114466 114466 2022-09-06 Brazil Amapa     178115 2158 0   0.902 -52.003 2022-09-07 04:20:59 Amapa, Brazil
121674 121674 2020-07-19 Brazil Amapa     33705 507 22346 10852 0.902 -52.003 2020-07-20 05:34:40 Amapa, Brazil
122437 122437 2020-11-18 Brazil Amapa     55652 783 45870 8999 0.902 -52.003 2020-11-19 05:25:23 Amapa, Brazil
126447 126447 2022-01-09 Brazil Amapa     127529 2024 0   0.902 -52.003 2022-01-10 04:22:07 Amapa, Brazil
130464 130464 2022-10-04 Brazil Amapa     178277 2163 0   0.902 -52.003 2022-10-05 04:23:06 Amapa, Brazil
137685 137685 2021-12-04 Brazil Amapa     124893 2004 0   0.902 -52.003 2021-12-05 04:22:25 Amapa, Brazil
141702 141702 2022-07-09 Brazil Amapa     164422 2141 0   0.902 -52.003 2022-07-10 04:20:54 Amapa, Brazil
145706 145706 2020-08-15 Brazil Amapa     39431 613 27512 11306 0.902 -52.003 2020-08-16 04:27:42 Amapa, Brazil
149698 149698 2021-11-29 Brazil Amapa     124574 2003 0   0.902 -52.003 2021-11-30 04:22:53 Amapa, Brazil
153714 153714 2021-01-08 Brazil Amapa     70344 962 53850 15532 0.902 -52.003 2021-01-09 05:22:18 Amapa, Brazil
157727 157727 2022-03-29 Brazil Amapa     160336 2124 0   0.902 -52.003 2022-03-30 04:20:45 Amapa, Brazil
161742 161742 2021-11-19 Brazil Amapa     124236 1996 0   0.902 -52.003 2021-11-20 04:22:17 Amapa, Brazil
165759 165759 2022-06-21 Brazil Amapa     160566 2140 0   0.902 -52.003 2022-06-22 04:20:54 Amapa, Brazil
169774 169774 2021-04-16 Brazil Amapa     102836 1456 74779 26601 0.902 -52.003 2021-04-17 04:20:40 Amapa, Brazil
176992 176992 2020-07-27 Brazil Amapa     35364 556 23927 10881 0.902 -52.003 2020-07-28 04:58:43 Amapa, Brazil
177756 177756 2021-09-02 Brazil Amapa     122457 1954 0   0.902 -52.003 2021-09-03 04:21:20 Amapa, Brazil
181770 181770 2021-02-21 Brazil Amapa     82018 1121 59917 20977 0.902 -52.003 2021-02-22 05:24:21 Amapa, Brazil
185785 185785 2022-02-13 Brazil Amapa     159149 2078 0   0.902 -52.003 2022-02-14 04:20:51 Amapa, Brazil
189800 189800 2021-01-11 Brazil Amapa     71287 976 54715 15596 0.902 -52.003 2021-01-12 05:22:15 Amapa, Brazil
193801 193801 2020-08-31 Brazil Amapa     43193 661 31352 11180 0.902 -52.003 2020-09-01 04:28:31 Amapa, Brazil
197973 197973 2022-10-19 Brazil Amapa     178342 2164 0   0.902 -52.003 2022-10-20 04:22:59 Amapa, Brazil
201988 201988 2020-12-25 Brazil Amapa     66221 899 51267 14055 0.902 -52.003 2020-12-26 05:22:28 Amapa, Brazil
205988 205988 2020-08-19 Brazil Amapa     40211 622 28497 11092 0.902 -52.003 2020-08-20 04:27:43 Amapa, Brazil
209973 209973 2020-10-29 Brazil Amapa     51875 746 43840 7289 0.902 -52.003 2020-10-30 04:24:49 Amapa, Brazil
216987 216987 2020-06-08 Brazil Amapa     13294 278 6148 6868 0.902 -52.003 2020-06-09 03:33:03 Amapa, Brazil
217694 217694 2022-12-26 Brazil Amapa     182501 2165 0   0.902 -52.003 2022-12-27 04:21:07 Amapa, Brazil
221710 221710 2022-05-09 Brazil Amapa     160401 2132 0   0.902 -52.003 2022-05-10 04:20:50 Amapa, Brazil
228941 228941 2022-05-31 Brazil Amapa     160426 2134 0   0.902 -52.003 2022-06-01 04:20:55 Amapa, Brazil
232957 232957 2022-02-11 Brazil Amapa     158926 2076 0   0.902 -52.003 2022-02-12 04:21:06 Amapa, Brazil
236972 236972 2021-01-18 Brazil Amapa     73626 1005 56455 16166 0.902 -52.003 2021-01-19 05:22:15 Amapa, Brazil
240985 240985 2021-04-02 Brazil Amapa     98324 1318 72266 24740 0.902 -52.003 2021-04-03 04:20:44 Amapa, Brazil
244999 244999 2021-08-17 Brazil Amapa     122080 1941 0   0.902 -52.003 2021-08-18 04:21:35 Amapa, Brazil
249013 249013 2021-09-04 Brazil Amapa     122493 1959 0   0.902 -52.003 2021-09-05 04:21:33 Amapa, Brazil
253028 253028 2022-09-08 Brazil Amapa     178115 2158 0   0.902 -52.003 2022-09-09 04:21:11 Amapa, Brazil
257044 257044 2022-12-10 Brazil Amapa     182001 2165 0   0.902 -52.003 2022-12-11 04:20:50 Amapa, Brazil
261247 261247 2022-03-15 Brazil Amapa     160217 2119 0   0.902 -52.003 2022-03-16 04:20:50 Amapa, Brazil
268219 268219 2020-05-21 Brazil Amapa     5188 151 0 5037 0.902 -52.003 2020-05-22 02:36:51 Amapa, Brazil
271888 271888 2020-11-10 Brazil Amapa     53574 766 44578 8230 0.902 -52.003 2020-11-11 05:25:30 Amapa, Brazil
275897 275897 2021-11-03 Brazil Amapa     123695 1993 0   0.902 -52.003 2021-11-04 04:22:20 Amapa, Brazil
279913 279913 2021-02-24 Brazil Amapa     82868 1131 60115 21622 0.902 -52.003 2021-02-25 05:24:57 Amapa, Brazil
286963 286963 2020-06-15 Brazil Amapa     16813 329 7460 9024 0.902 -52.003 2020-06-16 04:33:09 Amapa, Brazil
287710 287710 2021-10-31 Brazil Amapa     123627 1991 0   0.902 -52.003 2021-11-01 04:22:01 Amapa, Brazil
291727 291727 2022-11-15 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-16 04:21:09 Amapa, Brazil
295742 295742 2021-07-15 Brazil Amapa     119427 1876 100523 17028 0.902 -52.003 2021-07-16 04:21:22 Amapa, Brazil
302835 302835 2020-07-01 Brazil Amapa     28927 420 14168 14339 0.902 -52.003 2020-07-02 04:33:46 Amapa, Brazil
303583 303583 2022-04-16 Brazil Amapa     160369 2128 0   0.902 -52.003 2022-04-17 04:20:59 Amapa, Brazil
307599 307599 2022-12-13 Brazil Amapa     182152 2165 0   0.902 -52.003 2022-12-14 04:21:04 Amapa, Brazil
311615 311615 2022-11-13 Brazil Amapa     178709 2164 0   0.902 -52.003 2022-11-14 04:21:09 Amapa, Brazil
315631 315631 2022-02-12 Brazil Amapa     159081 2078 0   0.902 -52.003 2022-02-13 04:21:00 Amapa, Brazil
319647 319647 2022-10-30 Brazil Amapa     178377 2164 0   0.902 -52.003 2022-10-31 04:21:36 Amapa, Brazil
326769 326769 2020-07-20 Brazil Amapa     34145 515 22548 11082 0.902 -52.003 2020-07-21 04:38:46 Amapa, Brazil
327621 327621 2022-12-27 Brazil Amapa     182502 2165 0   0.902 -52.003 2022-12-28 04:21:04 Amapa, Brazil
331636 331636 2021-08-04 Brazil Amapa     121490 1915 102852 16723 0.902 -52.003 2021-08-05 04:21:51 Amapa, Brazil
335651 335651 2022-03-18 Brazil Amapa     160255 2120 0   0.902 -52.003 2022-03-19 04:20:47 Amapa, Brazil
340006 340006 2021-02-03 Brazil Amapa     77989 1069 58282 18638 0.902 -52.003 2021-02-04 05:22:26 Amapa, Brazil
344009 344009 2020-09-14 Brazil Amapa     45955 680 33837 11438 0.902 -52.003 2020-09-15 03:22:50 Amapa, Brazil
348011 348011 2022-12-14 Brazil Amapa     182212 2165 0   0.902 -52.003 2022-12-15 04:20:58 Amapa, Brazil
352026 352026 2021-03-11 Brazil Amapa     87095 1169 69433 16493 0.902 -52.003 2021-03-12 05:26:50 Amapa, Brazil
356041 356041 2022-03-11 Brazil Amapa     160202 2118 0   0.902 -52.003 2022-03-12 04:20:50 Amapa, Brazil
360057 360057 2022-05-07 Brazil Amapa     160400 2132 0   0.902 -52.003 2022-05-08 04:20:49 Amapa, Brazil
367184 367184 2020-07-16 Brazil Amapa     33004 493 21319 11192 0.902 -52.003 2020-07-17 04:34:50 Amapa, Brazil
371146 371146 2020-08-08 Brazil Amapa     38139 601 26175 11363 0.902 -52.003 2020-08-09 04:34:54 Amapa, Brazil
371911 371911 2022-09-13 Brazil Amapa     178187 2159 0   0.902 -52.003 2022-09-14 04:20:44 Amapa, Brazil
375915 375915 2020-11-06 Brazil Amapa     52832 751 44578 7503 0.902 -52.003 2020-11-07 05:24:52 Amapa, Brazil
379923 379923 2021-04-30 Brazil Amapa     105754 1543 76652 27559 0.902 -52.003 2021-05-01 04:20:47 Amapa, Brazil
383938 383938 2022-09-23 Brazil Amapa     178261 2163 0   0.902 -52.003 2022-09-24 04:21:40 Amapa, Brazil
387953 387953 2021-04-04 Brazil Amapa     98898 1323 72266 25309 0.902 -52.003 2021-04-05 04:20:35 Amapa, Brazil
391967 391967 2020-11-27 Brazil Amapa     58300 805 46648 10847 0.902 -52.003 2020-11-28 05:25:50 Amapa, Brazil
395979 395979 2022-10-07 Brazil Amapa     178286 2163 0   0.902 -52.003 2022-10-08 04:22:56 Amapa, Brazil
399994 399994 2021-06-29 Brazil Amapa     116991 1833 94183 20975 0.902 -52.003 2021-06-30 04:21:41 Amapa, Brazil
404008 404008 2021-12-07 Brazil Amapa     125081 2005 0   0.902 -52.003 2021-12-08 04:22:46 Amapa, Brazil
408024 408024 2021-07-28 Brazil Amapa     120962 1902 102852 16208 0.902 -52.003 2021-07-29 04:21:33 Amapa, Brazil
415127 415127 2020-07-05 Brazil Amapa     29883 442 17566 11875 0.902 -52.003 2020-07-06 04:33:57 Amapa, Brazil
419050 419050 2022-09-18 Brazil Amapa     178204 2159 0   0.902 -52.003 2022-09-19 04:21:49 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]);