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 = "Sao Paulo" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237677 | 3237677 | 2020-07-10 | Brazil | Sao Paulo | 359110 | 17442 | 204531 | 137137 | -23.5505 | -46.6333 | 2020-07-11 04:34:26 | Sao Paulo, Brazil | ||
1005662 | 1005662 | 2020-07-09 | Brazil | Sao Paulo | 349715 | 17118 | 202967 | 129630 | -23.5505 | -46.6333 | 2020-07-10 04:34:24 | Sao Paulo, Brazil | ||
2222878 | 2222878 | 2020-07-08 | Brazil | Sao Paulo | 341365 | 16788 | 199005 | 125572 | -23.5505 | -46.6333 | 2020-07-09 04:34:23 | Sao Paulo, Brazil | ||
887487 | 887487 | 2020-07-07 | Brazil | Sao Paulo | 332708 | 16475 | 194958 | 121275 | -23.5505 | -46.6333 | 2020-07-08 05:33:48 | Sao Paulo, Brazil | ||
2685047 | 2685047 | 2020-07-06 | Brazil | Sao Paulo | 323070 | 16134 | 176494 | 130442 | -23.5505 | -46.6333 | 2020-07-07 04:34:00 | Sao Paulo, Brazil | ||
415512 | 415512 | 2020-07-05 | Brazil | Sao Paulo | 320179 | 16078 | 175439 | 128662 | -23.5505 | -46.6333 | 2020-07-06 04:33:57 | Sao Paulo, Brazil | ||
530074 | 530074 | 2020-07-04 | Brazil | Sao Paulo | 312530 | 15996 | 162851 | 133683 | -23.5505 | -46.6333 | 2020-07-05 04:33:46 | Sao Paulo, Brazil | ||
2234735 | 2234735 | 2020-07-03 | Brazil | Sao Paulo | 310702 | 15694 | 162851 | 132157 | -23.5505 | -46.6333 | 2020-07-04 04:33:51 | Sao Paulo, Brazil | ||
3045529 | 3045529 | 2020-07-02 | Brazil | Sao Paulo | 302179 | 15351 | 162851 | 123977 | -23.5505 | -46.6333 | 2020-07-03 04:33:54 | Sao Paulo, Brazil | ||
303220 | 303220 | 2020-07-01 | Brazil | Sao Paulo | 289935 | 15030 | 157845 | 117060 | -23.5505 | -46.6333 | 2020-07-02 04:33:46 | Sao Paulo, Brazil | ||
2974598 | 2974598 | 2020-06-30 | Brazil | Sao Paulo | 281380 | 14763 | 49295 | 217322 | -23.5505 | -46.6333 | 2020-07-01 04:33:52 | Sao Paulo, Brazil | ||
2633075 | 2633075 | 2020-06-29 | Brazil | Sao Paulo | 275145 | 14398 | 49295 | 211452 | -23.5505 | -46.6333 | 2020-06-30 04:33:48 | Sao Paulo, Brazil | ||
2306638 | 2306638 | 2020-06-28 | Brazil | Sao Paulo | 271737 | 14338 | 49295 | 208104 | -23.5505 | -46.6333 | 2020-06-29 04:33:44 | Sao Paulo, Brazil | ||
2039973 | 2039973 | 2020-06-27 | Brazil | Sao Paulo | 265581 | 14263 | 49295 | 202023 | -23.5505 | -46.6333 | 2020-06-28 04:34:04 | Sao Paulo, Brazil | ||
1136254 | 1136254 | 2020-06-26 | Brazil | Sao Paulo | 258508 | 13966 | 49295 | 195247 | -23.5505 | -46.6333 | 2020-06-27 04:33:35 | Sao Paulo, Brazil | ||
2625241 | 2625241 | 2020-06-25 | Brazil | Sao Paulo | 248587 | 13759 | 49295 | 185533 | -23.5505 | -46.6333 | 2020-06-26 04:33:43 | Sao Paulo, Brazil | ||
2700881 | 2700881 | 2020-06-24 | Brazil | Sao Paulo | 238822 | 13352 | 49295 | 176175 | -23.5505 | -46.6333 | 2020-06-25 05:26:54 | Sao Paulo, Brazil | ||
1522566 | 1522566 | 2020-06-23 | Brazil | Sao Paulo | 229475 | 13068 | 49295 | 167112 | -23.5505 | -46.6333 | 2020-06-24 04:33:28 | Sao Paulo, Brazil | ||
1510760 | 1510760 | 2020-06-22 | Brazil | Sao Paulo | 221973 | 12634 | 49295 | 160044 | -23.5505 | -46.6333 | 2020-06-23 04:33:22 | Sao Paulo, Brazil | ||
3249499 | 3249499 | 2020-06-21 | Brazil | Sao Paulo | 219185 | 12588 | 49295 | 157302 | -23.5505 | -46.6333 | 2020-06-22 04:33:20 | Sao Paulo, Brazil | ||
2438092 | 2438092 | 2020-06-20 | Brazil | Sao Paulo | 215793 | 12494 | 49295 | 149869 | -23.5505 | -46.6333 | 2020-06-21 04:33:19 | Sao Paulo, Brazil | ||
1691670 | 1691670 | 2020-06-19 | Brazil | Sao Paulo | 211658 | 12232 | 49295 | 150131 | -23.5505 | -46.6333 | 2020-06-20 04:33:19 | Sao Paulo, Brazil | ||
3682819 | 3682819 | 2020-06-18 | Brazil | Sao Paulo | 192628 | 11846 | 49295 | 131487 | -23.5505 | -46.6333 | 2020-06-19 04:33:17 | Sao Paulo, Brazil | ||
1196022 | 1196022 | 2020-06-17 | Brazil | Sao Paulo | 191517 | 11521 | 49295 | 130701 | -23.5505 | -46.6333 | 2020-06-18 04:33:18 | Sao Paulo, Brazil | ||
2386785 | 2386785 | 2020-06-16 | Brazil | Sao Paulo | 190285 | 11132 | 49295 | 129858 | -23.5505 | -46.6333 | 2020-06-17 04:33:21 | Sao Paulo, Brazil | ||
287348 | 287348 | 2020-06-15 | Brazil | Sao Paulo | 181460 | 10767 | 49295 | 121398 | -23.5505 | -46.6333 | 2020-06-16 04:33:09 | Sao Paulo, Brazil | ||
1837299 | 1837299 | 2020-06-14 | Brazil | Sao Paulo | 178202 | 10694 | 49295 | 118213 | -23.5505 | -46.6333 | 2020-06-15 03:33:14 | Sao Paulo, Brazil | ||
3061351 | 3061351 | 2020-06-13 | Brazil | Sao Paulo | 172875 | 10581 | 49295 | 112999 | -23.5505 | -46.6333 | 2020-06-14 03:33:15 | Sao Paulo, Brazil | ||
737671 | 737671 | 2020-06-12 | Brazil | Sao Paulo | 167900 | 10368 | 49295 | 108237 | -23.5505 | -46.6333 | 2020-06-13 03:33:14 | Sao Paulo, Brazil | ||
1273641 | 1273641 | 2020-06-11 | Brazil | Sao Paulo | 162520 | 10145 | 49295 | 103080 | -23.5505 | -46.6333 | 2020-06-12 05:09:52 | Sao Paulo, Brazil | ||
2864083 | 2864083 | 2020-06-10 | Brazil | Sao Paulo | 156316 | 9862 | 49295 | 97159 | -23.5505 | -46.6333 | 2020-06-11 03:33:41 | Sao Paulo, Brazil | ||
1210909 | 1210909 | 2020-06-09 | Brazil | Sao Paulo | 150138 | 9522 | 49295 | 91321 | -23.5505 | -46.6333 | 2020-06-10 04:07:00 | Sao Paulo, Brazil | ||
217336 | 217336 | 2020-06-08 | Brazil | Sao Paulo | 144593 | 9188 | 49295 | 86110 | -23.5505 | -46.6333 | 2020-06-09 03:33:03 | Sao Paulo, Brazil | ||
2800132 | 2800132 | 2020-06-07 | Brazil | Sao Paulo | 143073 | 9145 | 0 | 133928 | -23.5505 | -46.6333 | 2020-06-08 03:33:22 | Sao Paulo, Brazil | ||
574188 | 574188 | 2020-06-06 | Brazil | Sao Paulo | 140549 | 9058 | 0 | 131491 | -23.5505 | -46.6333 | 2020-06-07 03:53:30 | Sao Paulo, Brazil | ||
1269885 | 1269885 | 2020-06-05 | Brazil | Sao Paulo | 134565 | 8842 | 0 | 125723 | -23.5505 | -46.6333 | 2020-06-06 02:33:00 | Sao Paulo, Brazil | ||
1281354 | 1281354 | 2020-06-04 | Brazil | Sao Paulo | 129200 | 8561 | 0 | 120640 | -23.5505 | -46.6333 | 2020-06-05 02:33:06 | Sao Paulo, Brazil | ||
3866909 | 3866909 | 2020-06-03 | Brazil | Sao Paulo | 123483 | 8276 | 0 | 115207 | -23.5505 | -46.6333 | 2020-06-04 02:33:14 | Sao Paulo, Brazil | ||
2555951 | 2555951 | 2020-06-02 | Brazil | Sao Paulo | 118295 | 7994 | 0 | 110301 | -23.5505 | -46.6333 | 2020-06-03 02:33:13 | Sao Paulo, Brazil | ||
805488 | 805488 | 2020-06-01 | Brazil | Sao Paulo | 111296 | 7667 | 0 | 103629 | -23.5505 | -46.6333 | 2020-06-02 02:33:08 | Sao Paulo, Brazil | ||
1794051 | 1794051 | 2020-05-31 | Brazil | Sao Paulo | 109698 | 7615 | 0 | 102083 | -23.5505 | -46.6333 | 2020-06-01 02:32:46 | Sao Paulo, Brazil | ||
3638944 | 3638944 | 2020-05-30 | Brazil | Sao Paulo | 107142 | 7532 | 0 | 99610 | -23.5505 | -46.6333 | 2020-05-31 02:32:45 | Sao Paulo, Brazil | ||
1790485 | 1790485 | 2020-05-29 | Brazil | Sao Paulo | 101556 | 7275 | 0 | 94281 | -23.5505 | -46.6333 | 2020-05-30 02:32:48 | Sao Paulo, Brazil | ||
2712364 | 2712364 | 2020-05-28 | Brazil | Sao Paulo | 95865 | 6980 | 0 | 88885 | -23.5505 | -46.6333 | 2020-05-29 02:32:50 | Sao Paulo, Brazil | ||
2548301 | 2548301 | 2020-05-27 | Brazil | Sao Paulo | 89483 | 6712 | 0 | 82771 | -23.5505 | -46.6333 | 2020-05-28 02:32:31 | Sao Paulo, Brazil | ||
1041264 | 1041264 | 2020-05-26 | Brazil | Sao Paulo | 86017 | 6423 | 0 | 79594 | -23.5505 | -46.6333 | 2020-05-27 02:32:31 | Sao Paulo, Brazil | ||
1104994 | 1104994 | 2020-05-25 | Brazil | Sao Paulo | 83625 | 6220 | 0 | 77405 | -23.5505 | -46.6333 | 2020-05-26 02:32:35 | Sao Paulo, Brazil | ||
875674 | 875674 | 2020-05-24 | Brazil | Sao Paulo | 82161 | 6163 | 0 | 75998 | -23.5505 | -46.6333 | 2020-05-25 02:32:44 | Sao Paulo, Brazil | ||
997865 | 997865 | 2020-05-23 | Brazil | Sao Paulo | 80558 | 6045 | 0 | 74513 | -23.5505 | -46.6333 | 2020-05-24 02:32:43 | Sao Paulo, Brazil | ||
1864888 | 1864888 | 2020-05-22 | Brazil | Sao Paulo | 76871 | 5773 | 0 | 71098 | -23.5505 | -46.6333 | 2020-05-23 02:32:42 | Sao Paulo, Brazil | ||
268394 | 268394 | 2020-05-21 | Brazil | Sao Paulo | 73739 | 5558 | 0 | 68181 | -23.5505 | -46.6333 | 2020-05-22 02:36:51 | Sao Paulo, Brazil | ||
1431977 | 1431977 | 2020-05-20 | Brazil | Sao Paulo | 69859 | 5363 | 0 | 64496 | -23.5505 | -46.6333 | 2020-05-21 02:32:48 | Sao Paulo, 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]);