johns_hopkins_csse_daily_reports
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237292 | 3237292 | 2020-07-10 | Brazil | Amapa | 31080 | 470 | 19803 | 10807 | 0.902 | -52.003 | 2020-07-11 04:34:26 | Amapa, Brazil | ||
1005277 | 1005277 | 2020-07-09 | Brazil | Amapa | 30763 | 467 | 19644 | 10652 | 0.902 | -52.003 | 2020-07-10 04:34:24 | Amapa, Brazil | ||
2222493 | 2222493 | 2020-07-08 | Brazil | Amapa | 30524 | 462 | 19372 | 10690 | 0.902 | -52.003 | 2020-07-09 04:34:23 | Amapa, Brazil | ||
887102 | 887102 | 2020-07-07 | Brazil | Amapa | 30294 | 455 | 18843 | 10996 | 0.902 | -52.003 | 2020-07-08 05:33:48 | Amapa, Brazil | ||
2684662 | 2684662 | 2020-07-06 | Brazil | Amapa | 30004 | 449 | 17850 | 11705 | 0.902 | -52.003 | 2020-07-07 04:34:00 | 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 | ||
529689 | 529689 | 2020-07-04 | Brazil | Amapa | 29809 | 441 | 17156 | 12212 | 0.902 | -52.003 | 2020-07-05 04:33:46 | Amapa, Brazil | ||
2234350 | 2234350 | 2020-07-03 | Brazil | Amapa | 29574 | 438 | 17156 | 11980 | 0.902 | -52.003 | 2020-07-04 04:33:51 | Amapa, Brazil | ||
3045144 | 3045144 | 2020-07-02 | Brazil | Amapa | 29153 | 427 | 16298 | 12428 | 0.902 | -52.003 | 2020-07-03 04:33:54 | 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 | ||
2974213 | 2974213 | 2020-06-30 | Brazil | Amapa | 28492 | 417 | 13573 | 14502 | 0.902 | -52.003 | 2020-07-01 04:33:52 | Amapa, Brazil | ||
2632690 | 2632690 | 2020-06-29 | Brazil | Amapa | 28253 | 413 | 12929 | 14911 | 0.902 | -52.003 | 2020-06-30 04:33:48 | Amapa, Brazil | ||
2306253 | 2306253 | 2020-06-28 | Brazil | Amapa | 27985 | 407 | 12815 | 14763 | 0.902 | -52.003 | 2020-06-29 04:33:44 | Amapa, Brazil | ||
2039588 | 2039588 | 2020-06-27 | Brazil | Amapa | 27901 | 406 | 12804 | 14691 | 0.902 | -52.003 | 2020-06-28 04:34:04 | Amapa, Brazil | ||
1135869 | 1135869 | 2020-06-26 | Brazil | Amapa | 27662 | 401 | 11333 | 15928 | 0.902 | -52.003 | 2020-06-27 04:33:35 | Amapa, Brazil | ||
2624856 | 2624856 | 2020-06-25 | Brazil | Amapa | 27415 | 394 | 10912 | 16109 | 0.902 | -52.003 | 2020-06-26 04:33:43 | Amapa, Brazil | ||
2700496 | 2700496 | 2020-06-24 | Brazil | Amapa | 26919 | 387 | 10544 | 15988 | 0.902 | -52.003 | 2020-06-25 05:26:54 | Amapa, Brazil | ||
1522181 | 1522181 | 2020-06-23 | Brazil | Amapa | 26437 | 380 | 10178 | 15879 | 0.902 | -52.003 | 2020-06-24 04:33:28 | Amapa, Brazil | ||
1510375 | 1510375 | 2020-06-22 | Brazil | Amapa | 24862 | 372 | 9601 | 14709 | 0.902 | -52.003 | 2020-06-23 04:33:22 | Amapa, Brazil | ||
3249114 | 3249114 | 2020-06-21 | Brazil | Amapa | 21840 | 359 | 9521 | 11960 | 0.902 | -52.003 | 2020-06-22 04:33:20 | Amapa, Brazil | ||
2437707 | 2437707 | 2020-06-20 | Brazil | Amapa | 21574 | 353 | 9416 | 10153 | 0.902 | -52.003 | 2020-06-21 04:33:19 | Amapa, Brazil | ||
1691285 | 1691285 | 2020-06-19 | Brazil | Amapa | 19922 | 348 | 9080 | 10494 | 0.902 | -52.003 | 2020-06-20 04:33:19 | Amapa, Brazil | ||
3682434 | 3682434 | 2020-06-18 | Brazil | Amapa | 19387 | 342 | 8766 | 10279 | 0.902 | -52.003 | 2020-06-19 04:33:17 | Amapa, Brazil | ||
1195637 | 1195637 | 2020-06-17 | Brazil | Amapa | 18618 | 338 | 8529 | 9751 | 0.902 | -52.003 | 2020-06-18 04:33:18 | Amapa, Brazil | ||
2386400 | 2386400 | 2020-06-16 | Brazil | Amapa | 18024 | 337 | 8041 | 9646 | 0.902 | -52.003 | 2020-06-17 04:33:21 | 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 | ||
1836914 | 1836914 | 2020-06-14 | Brazil | Amapa | 16512 | 324 | 7363 | 8825 | 0.902 | -52.003 | 2020-06-15 03:33:14 | Amapa, Brazil | ||
3060966 | 3060966 | 2020-06-13 | Brazil | Amapa | 16322 | 319 | 7311 | 8692 | 0.902 | -52.003 | 2020-06-14 03:33:15 | Amapa, Brazil | ||
737286 | 737286 | 2020-06-12 | Brazil | Amapa | 15683 | 312 | 7253 | 8118 | 0.902 | -52.003 | 2020-06-13 03:33:14 | Amapa, Brazil | ||
1273256 | 1273256 | 2020-06-11 | Brazil | Amapa | 15166 | 303 | 7095 | 7768 | 0.902 | -52.003 | 2020-06-12 05:09:52 | Amapa, Brazil | ||
2863700 | 2863700 | 2020-06-10 | Brazil | Amapa | 14623 | 289 | 6717 | 7617 | 0.902 | -52.003 | 2020-06-11 03:33:41 | Amapa, Brazil | ||
1210560 | 1210560 | 2020-06-09 | Brazil | Amapa | 13771 | 285 | 6544 | 6942 | 0.902 | -52.003 | 2020-06-10 04:07:00 | 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 | ||
2799784 | 2799784 | 2020-06-07 | Brazil | Amapa | 13045 | 272 | 0 | 12773 | 0.902 | -52.003 | 2020-06-08 03:33:22 | Amapa, Brazil | ||
573840 | 573840 | 2020-06-06 | Brazil | Amapa | 12773 | 269 | 0 | 12504 | 0.902 | -52.003 | 2020-06-07 03:53:30 | Amapa, Brazil | ||
1269537 | 1269537 | 2020-06-05 | Brazil | Amapa | 12327 | 260 | 0 | 12067 | 0.902 | -52.003 | 2020-06-06 02:33:00 | Amapa, Brazil | ||
1281018 | 1281018 | 2020-06-04 | Brazil | Amapa | 11551 | 254 | 0 | 11297 | 0.902 | -52.003 | 2020-06-05 02:33:06 | Amapa, Brazil | ||
3866573 | 3866573 | 2020-06-03 | Brazil | Amapa | 11107 | 247 | 0 | 10860 | 0.902 | -52.003 | 2020-06-04 02:33:14 | Amapa, Brazil | ||
2555616 | 2555616 | 2020-06-02 | Brazil | Amapa | 10511 | 237 | 0 | 10274 | 0.902 | -52.003 | 2020-06-03 02:33:13 | Amapa, Brazil | ||
805152 | 805152 | 2020-06-01 | Brazil | Amapa | 9890 | 228 | 0 | 9662 | 0.902 | -52.003 | 2020-06-02 02:33:08 | Amapa, Brazil | ||
1793794 | 1793794 | 2020-05-31 | Brazil | Amapa | 9602 | 222 | 0 | 9380 | 0.902 | -52.003 | 2020-06-01 02:32:46 | Amapa, Brazil | ||
3638687 | 3638687 | 2020-05-30 | Brazil | Amapa | 9313 | 215 | 0 | 9098 | 0.902 | -52.003 | 2020-05-31 02:32:45 | Amapa, Brazil | ||
1790228 | 1790228 | 2020-05-29 | Brazil | Amapa | 8469 | 207 | 0 | 8262 | 0.902 | -52.003 | 2020-05-30 02:32:48 | Amapa, Brazil | ||
2712108 | 2712108 | 2020-05-28 | Brazil | Amapa | 8152 | 198 | 0 | 7954 | 0.902 | -52.003 | 2020-05-29 02:32:50 | Amapa, Brazil | ||
2548126 | 2548126 | 2020-05-27 | Brazil | Amapa | 7619 | 183 | 0 | 7436 | 0.902 | -52.003 | 2020-05-28 02:32:31 | Amapa, Brazil | ||
1041089 | 1041089 | 2020-05-26 | Brazil | Amapa | 6967 | 173 | 0 | 6794 | 0.902 | -52.003 | 2020-05-27 02:32:31 | Amapa, Brazil | ||
1104819 | 1104819 | 2020-05-25 | Brazil | Amapa | 6584 | 168 | 0 | 6416 | 0.902 | -52.003 | 2020-05-26 02:32:35 | Amapa, Brazil | ||
875499 | 875499 | 2020-05-24 | Brazil | Amapa | 6353 | 163 | 0 | 6190 | 0.902 | -52.003 | 2020-05-25 02:32:44 | Amapa, Brazil | ||
997690 | 997690 | 2020-05-23 | Brazil | Amapa | 6091 | 162 | 0 | 5929 | 0.902 | -52.003 | 2020-05-24 02:32:43 | Amapa, Brazil | ||
1864713 | 1864713 | 2020-05-22 | Brazil | Amapa | 5655 | 157 | 0 | 5498 | 0.902 | -52.003 | 2020-05-23 02:32:42 | 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 | ||
1431802 | 1431802 | 2020-05-20 | Brazil | Amapa | 4549 | 142 | 0 | 4407 | 0.902 | -52.003 | 2020-05-21 02:32:48 | Amapa, Brazil |
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]);