johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▲ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
542505 | 542505 | 2022-12-15 | Brazil | Sao Paulo | 6247608 | 176824 | 0 | -23.5505 | -46.6333 | 2022-12-16 04:21:01 | Sao Paulo, Brazil | |||
134412 | 134412 | 2022-10-04 | United Kingdom | England | 19968866 | 176800 | 0 | 52.3555 | -1.1743 | 2022-10-05 04:23:06 | England, United Kingdom | |||
348033 | 348033 | 2022-12-14 | Brazil | Sao Paulo | 6241703 | 176769 | 0 | -23.5505 | -46.6333 | 2022-12-15 04:20:58 | Sao Paulo, Brazil | |||
2689359 | 2689359 | 2022-10-03 | United Kingdom | England | 19968866 | 176722 | 0 | 52.3555 | -1.1743 | 2022-10-04 04:22:55 | England, United Kingdom | |||
2263426 | 2263426 | 2022-10-02 | United Kingdom | England | 19968866 | 176654 | 0 | 52.3555 | -1.1743 | 2022-10-03 04:23:11 | England, United Kingdom | |||
307621 | 307621 | 2022-12-13 | Brazil | Sao Paulo | 6236690 | 176631 | 0 | -23.5505 | -46.6333 | 2022-12-14 04:21:04 | Sao Paulo, Brazil | |||
1148682 | 1148682 | 2022-12-12 | Brazil | Sao Paulo | 6230070 | 176631 | 0 | -23.5505 | -46.6333 | 2022-12-13 04:21:01 | Sao Paulo, Brazil | |||
2998952 | 2998952 | 2022-10-01 | United Kingdom | England | 19968866 | 176601 | 0 | 52.3555 | -1.1743 | 2022-10-02 04:21:23 | England, United Kingdom | |||
257066 | 257066 | 2022-12-10 | Brazil | Sao Paulo | 6221071 | 176563 | 0 | -23.5505 | -46.6333 | 2022-12-11 04:20:50 | Sao Paulo, Brazil | |||
868536 | 868536 | 2022-12-11 | Brazil | Sao Paulo | 6221071 | 176563 | 0 | -23.5505 | -46.6333 | 2022-12-12 04:21:01 | Sao Paulo, Brazil | |||
3377112 | 3377112 | 2022-12-08 | Brazil | Sao Paulo | 6221071 | 176563 | 0 | -23.5505 | -46.6333 | 2022-12-09 04:21:05 | Sao Paulo, Brazil | |||
3935780 | 3935780 | 2022-12-09 | Brazil | Sao Paulo | 6221071 | 176563 | 0 | -23.5505 | -46.6333 | 2022-12-10 04:21:02 | Sao Paulo, Brazil | |||
857278 | 857278 | 2022-09-30 | United Kingdom | England | 19968866 | 176544 | 0 | 52.3555 | -1.1743 | 2022-10-01 04:23:01 | England, United Kingdom | |||
2379204 | 2379204 | 2022-09-29 | United Kingdom | England | 19968866 | 176498 | 0 | 52.3555 | -1.1743 | 2022-09-30 04:23:09 | England, United Kingdom | |||
1563755 | 1563755 | 2022-09-28 | United Kingdom | England | 19922057 | 176445 | 0 | 52.3555 | -1.1743 | 2022-09-29 04:22:34 | England, United Kingdom | |||
1984383 | 1984383 | 2022-12-07 | Brazil | Sao Paulo | 6204502 | 176417 | 0 | -23.5505 | -46.6333 | 2022-12-08 04:21:07 | Sao Paulo, Brazil | |||
2414611 | 2414611 | 2022-12-05 | Brazil | Sao Paulo | 6204502 | 176417 | 0 | -23.5505 | -46.6333 | 2022-12-06 04:21:03 | Sao Paulo, Brazil | |||
3713906 | 3713906 | 2022-12-06 | Brazil | Sao Paulo | 6204502 | 176417 | 0 | -23.5505 | -46.6333 | 2022-12-07 04:20:58 | Sao Paulo, Brazil | |||
3998298 | 3998298 | 2022-09-27 | United Kingdom | England | 19922057 | 176394 | 0 | 52.3555 | -1.1743 | 2022-09-28 04:23:01 | England, United Kingdom | |||
718219 | 718219 | 2022-12-04 | Brazil | Sao Paulo | 6197738 | 176356 | 0 | -23.5505 | -46.6333 | 2022-12-05 04:20:58 | Sao Paulo, Brazil | |||
833364 | 833364 | 2022-12-02 | Brazil | Sao Paulo | 6197738 | 176356 | 0 | -23.5505 | -46.6333 | 2022-12-03 04:21:02 | Sao Paulo, Brazil | |||
2816508 | 2816508 | 2022-12-03 | Brazil | Sao Paulo | 6197738 | 176356 | 0 | -23.5505 | -46.6333 | 2022-12-04 04:20:56 | Sao Paulo, Brazil | |||
2772626 | 2772626 | 2022-09-26 | United Kingdom | England | 19922057 | 176339 | 0 | 52.3555 | -1.1743 | 2022-09-27 04:23:01 | England, United Kingdom | |||
2135894 | 2135894 | 2022-12-01 | Brazil | Sao Paulo | 6192819 | 176298 | 0 | -23.5505 | -46.6333 | 2022-12-02 04:21:07 | Sao Paulo, Brazil | |||
1980279 | 1980279 | 2022-09-25 | United Kingdom | England | 19922057 | 176290 | 0 | 52.3555 | -1.1743 | 2022-09-26 04:20:52 | England, United Kingdom | |||
2653446 | 2653446 | 2022-09-24 | United Kingdom | England | 19922057 | 176259 | 0 | 52.3555 | -1.1743 | 2022-09-25 04:23:31 | England, United Kingdom | |||
387886 | 387886 | 2022-09-23 | United Kingdom | England | 19922057 | 176220 | 0 | 52.3555 | -1.1743 | 2022-09-24 04:21:40 | England, United Kingdom | |||
1964310 | 1964310 | 2022-11-30 | Brazil | Sao Paulo | 6190288 | 176199 | 0 | -23.5505 | -46.6333 | 2022-12-01 04:21:03 | Sao Paulo, Brazil | |||
2556324 | 2556324 | 2022-11-29 | Brazil | Sao Paulo | 6190288 | 176199 | 0 | -23.5505 | -46.6333 | 2022-11-30 04:21:07 | Sao Paulo, Brazil | |||
1627952 | 1627952 | 2022-09-22 | United Kingdom | England | 19922057 | 176179 | 0 | 52.3555 | -1.1743 | 2022-09-23 04:23:13 | England, United Kingdom | |||
1374156 | 1374156 | 2022-09-21 | United Kingdom | England | 19888584 | 176134 | 0 | 52.3555 | -1.1743 | 2022-09-22 04:22:56 | England, United Kingdom | |||
487357 | 487357 | 2022-11-25 | Brazil | Sao Paulo | 6185851 | 176133 | 0 | -23.5505 | -46.6333 | 2022-11-26 04:21:11 | Sao Paulo, Brazil | |||
1239398 | 1239398 | 2022-11-28 | Brazil | Sao Paulo | 6185851 | 176133 | 0 | -23.5505 | -46.6333 | 2022-11-29 04:21:05 | Sao Paulo, Brazil | |||
2099866 | 2099866 | 2022-11-26 | Brazil | Sao Paulo | 6185851 | 176133 | 0 | -23.5505 | -46.6333 | 2022-11-27 04:21:05 | Sao Paulo, Brazil | |||
3551386 | 3551386 | 2022-11-27 | Brazil | Sao Paulo | 6185851 | 176133 | 0 | -23.5505 | -46.6333 | 2022-11-28 04:21:02 | Sao Paulo, Brazil | |||
2020386 | 2020386 | 2022-09-20 | United Kingdom | England | 19888584 | 176104 | 0 | 52.3555 | -1.1743 | 2022-09-21 04:23:22 | England, United Kingdom | |||
3523186 | 3523186 | 2022-11-24 | Brazil | Sao Paulo | 6182046 | 176102 | 0 | -23.5505 | -46.6333 | 2022-11-25 04:21:06 | Sao Paulo, Brazil | |||
3311969 | 3311969 | 2022-11-23 | Brazil | Sao Paulo | 6177577 | 176074 | 0 | -23.5505 | -46.6333 | 2022-11-24 04:21:09 | Sao Paulo, Brazil | |||
3574259 | 3574259 | 2022-09-19 | United Kingdom | England | 19888584 | 176063 | 0 | 52.3555 | -1.1743 | 2022-09-20 04:22:48 | England, United Kingdom | |||
1620010 | 1620010 | 2022-11-22 | Brazil | Sao Paulo | 6174756 | 176037 | 0 | -23.5505 | -46.6333 | 2022-11-23 04:21:06 | Sao Paulo, Brazil | |||
422998 | 422998 | 2022-09-18 | United Kingdom | England | 19888584 | 176023 | 0 | 52.3555 | -1.1743 | 2022-09-19 04:21:49 | England, United Kingdom | |||
3377022 | 3377022 | 2022-09-17 | United Kingdom | England | 19888584 | 175995 | 0 | 52.3555 | -1.1743 | 2022-09-18 04:22:50 | England, United Kingdom | |||
2359130 | 2359130 | 2022-09-16 | United Kingdom | England | 19888584 | 175964 | 0 | 52.3555 | -1.1743 | 2022-09-17 04:20:19 | England, United Kingdom | |||
1640083 | 1640083 | 2022-11-20 | Brazil | Sao Paulo | 6170605 | 175941 | 0 | -23.5505 | -46.6333 | 2022-11-21 04:21:05 | Sao Paulo, Brazil | |||
1755034 | 1755034 | 2022-11-18 | Brazil | Sao Paulo | 6170605 | 175941 | 0 | -23.5505 | -46.6333 | 2022-11-19 04:21:14 | Sao Paulo, Brazil | |||
2063640 | 2063640 | 2022-11-19 | Brazil | Sao Paulo | 6170605 | 175941 | 0 | -23.5505 | -46.6333 | 2022-11-20 04:21:08 | Sao Paulo, Brazil | |||
3459898 | 3459898 | 2022-11-21 | Brazil | Sao Paulo | 6170605 | 175941 | 0 | -23.5505 | -46.6333 | 2022-11-22 04:20:47 | Sao Paulo, Brazil | |||
3990287 | 3990287 | 2022-09-15 | United Kingdom | England | 19888584 | 175935 | 0 | 52.3555 | -1.1743 | 2022-09-16 04:21:19 | England, United Kingdom | |||
3026027 | 3026027 | 2022-11-17 | Brazil | Sao Paulo | 6167559 | 175912 | 0 | -23.5505 | -46.6333 | 2022-11-18 04:21:15 | Sao Paulo, Brazil | |||
1892804 | 1892804 | 2022-09-14 | United Kingdom | England | 19861556 | 175896 | 0 | 52.3555 | -1.1743 | 2022-09-15 04:21:02 | England, United Kingdom | |||
2485738 | 2485738 | 2022-11-16 | Brazil | Sao Paulo | 6163619 | 175875 | 0 | -23.5505 | -46.6333 | 2022-11-17 04:21:11 | Sao Paulo, Brazil | |||
375859 | 375859 | 2022-09-13 | United Kingdom | England | 19861556 | 175860 | 0 | 52.3555 | -1.1743 | 2022-09-14 04:20:44 | England, United Kingdom | |||
62798 | 62798 | 2022-11-12 | Brazil | Sao Paulo | 6160930 | 175825 | 0 | -23.5505 | -46.6333 | 2022-11-13 04:21:14 | Sao Paulo, Brazil | |||
291749 | 291749 | 2022-11-15 | Brazil | Sao Paulo | 6160930 | 175825 | 0 | -23.5505 | -46.6333 | 2022-11-16 04:21:09 | Sao Paulo, Brazil | |||
311637 | 311637 | 2022-11-13 | Brazil | Sao Paulo | 6160930 | 175825 | 0 | -23.5505 | -46.6333 | 2022-11-14 04:21:09 | Sao Paulo, Brazil | |||
2926960 | 2926960 | 2022-11-11 | Brazil | Sao Paulo | 6160930 | 175825 | 0 | -23.5505 | -46.6333 | 2022-11-12 04:20:41 | Sao Paulo, Brazil | |||
3596779 | 3596779 | 2022-11-14 | Brazil | Sao Paulo | 6160930 | 175825 | 0 | -23.5505 | -46.6333 | 2022-11-15 04:21:16 | Sao Paulo, Brazil | |||
2398461 | 2398461 | 2022-09-12 | United Kingdom | England | 19861556 | 175815 | 0 | 52.3555 | -1.1743 | 2022-09-13 04:20:57 | England, United Kingdom | |||
2505796 | 2505796 | 2022-11-10 | Brazil | Sao Paulo | 6157150 | 175804 | 0 | -23.5505 | -46.6333 | 2022-11-11 04:21:22 | Sao Paulo, Brazil | |||
3769539 | 3769539 | 2022-09-11 | United Kingdom | England | 19861556 | 175783 | 0 | 52.3555 | -1.1743 | 2022-09-12 04:20:58 | England, United Kingdom | |||
3828114 | 3828114 | 2022-09-10 | United Kingdom | England | 19861556 | 175766 | 0 | 52.3555 | -1.1743 | 2022-09-11 04:20:50 | England, United Kingdom | |||
966571 | 966571 | 2022-09-09 | United Kingdom | England | 19861556 | 175735 | 0 | 52.3555 | -1.1743 | 2022-09-10 04:21:10 | England, United Kingdom | |||
256973 | 256973 | 2022-09-08 | United Kingdom | England | 19861556 | 175706 | 0 | 52.3555 | -1.1743 | 2022-09-09 04:21:11 | England, United Kingdom | |||
479327 | 479327 | 2022-11-08 | Brazil | Sao Paulo | 6149751 | 175673 | 0 | -23.5505 | -46.6333 | 2022-11-09 04:21:22 | Sao Paulo, Brazil | |||
2430671 | 2430671 | 2022-11-09 | Brazil | Sao Paulo | 6149751 | 175673 | 0 | -23.5505 | -46.6333 | 2022-11-10 04:21:16 | Sao Paulo, Brazil | |||
2438477 | 2438477 | 2022-11-07 | Brazil | Sao Paulo | 6149751 | 175673 | 0 | -23.5505 | -46.6333 | 2022-11-08 04:21:21 | Sao Paulo, Brazil | |||
3748771 | 3748771 | 2022-09-07 | United Kingdom | England | 19833314 | 175669 | 0 | 52.3555 | -1.1743 | 2022-09-08 04:21:02 | England, United Kingdom | |||
617599 | 617599 | 2022-11-05 | Brazil | Sao Paulo | 6149046 | 175640 | 0 | -23.5505 | -46.6333 | 2022-11-06 04:21:24 | Sao Paulo, Brazil | |||
1022103 | 1022103 | 2022-11-04 | Brazil | Sao Paulo | 6149046 | 175640 | 0 | -23.5505 | -46.6333 | 2022-11-05 04:21:52 | Sao Paulo, Brazil | |||
1049575 | 1049575 | 2022-11-06 | Brazil | Sao Paulo | 6149046 | 175640 | 0 | -23.5505 | -46.6333 | 2022-11-07 04:21:26 | Sao Paulo, Brazil | |||
118411 | 118411 | 2022-09-06 | United Kingdom | England | 19833314 | 175623 | 0 | 52.3555 | -1.1743 | 2022-09-07 04:20:59 | England, United Kingdom | |||
431094 | 431094 | 2022-11-03 | Brazil | Sao Paulo | 6148633 | 175602 | 0 | -23.5505 | -46.6333 | 2022-11-04 04:22:11 | Sao Paulo, Brazil | |||
2637383 | 2637383 | 2022-09-05 | United Kingdom | England | 19833314 | 175597 | 0 | 52.3555 | -1.1743 | 2022-09-06 04:21:02 | England, United Kingdom | |||
710187 | 710187 | 2022-11-01 | Brazil | Sao Paulo | 6145825 | 175574 | 0 | -23.5505 | -46.6333 | 2022-11-02 04:22:09 | Sao Paulo, Brazil | |||
849336 | 849336 | 2022-11-02 | Brazil | Sao Paulo | 6145825 | 175574 | 0 | -23.5505 | -46.6333 | 2022-11-03 04:22:05 | Sao Paulo, Brazil | |||
2990947 | 2990947 | 2022-09-04 | United Kingdom | England | 19833314 | 175566 | 0 | 52.3555 | -1.1743 | 2022-09-05 04:21:01 | England, United Kingdom | |||
3284636 | 3284636 | 2022-10-31 | Brazil | Sao Paulo | 6143549 | 175554 | 0 | -23.5505 | -46.6333 | 2022-11-01 04:22:36 | Sao Paulo, Brazil | |||
2716632 | 2716632 | 2022-09-03 | United Kingdom | England | 19833314 | 175530 | 0 | 52.3555 | -1.1743 | 2022-09-04 04:21:22 | England, United Kingdom | |||
319669 | 319669 | 2022-10-30 | Brazil | Sao Paulo | 6140622 | 175504 | 0 | -23.5505 | -46.6333 | 2022-10-31 04:21:36 | Sao Paulo, Brazil | |||
911945 | 911945 | 2022-10-29 | Brazil | Sao Paulo | 6140622 | 175504 | 0 | -23.5505 | -46.6333 | 2022-10-30 04:22:14 | Sao Paulo, Brazil | |||
1366214 | 1366214 | 2022-10-28 | Brazil | Sao Paulo | 6140622 | 175504 | 0 | -23.5505 | -46.6333 | 2022-10-29 04:21:13 | Sao Paulo, Brazil | |||
3038069 | 3038069 | 2022-10-27 | Brazil | Sao Paulo | 6140622 | 175504 | 0 | -23.5505 | -46.6333 | 2022-10-28 04:22:31 | Sao Paulo, Brazil | |||
1397337 | 1397337 | 2022-09-02 | United Kingdom | England | 19833314 | 175490 | 0 | 52.3555 | -1.1743 | 2022-09-03 04:21:04 | England, United Kingdom | |||
538489 | 538489 | 2022-10-26 | Brazil | Sao Paulo | 6137710 | 175479 | 0 | -23.5505 | -46.6333 | 2022-10-27 04:22:01 | Sao Paulo, Brazil | |||
1829890 | 1829890 | 2022-10-25 | Brazil | Sao Paulo | 6134532 | 175451 | 0 | -23.5505 | -46.6333 | 2022-10-26 04:22:19 | Sao Paulo, Brazil | |||
3551166 | 3551166 | 2022-09-01 | United Kingdom | England | 19833314 | 175449 | 0 | 52.3555 | -1.1743 | 2022-09-02 04:21:07 | England, United Kingdom | |||
2347086 | 2347086 | 2022-08-31 | United Kingdom | England | 19833314 | 175415 | 0 | 52.3555 | -1.1743 | 2022-09-01 04:21:03 | England, United Kingdom | |||
197995 | 197995 | 2022-10-19 | Brazil | Sao Paulo | 6126367 | 175371 | 0 | -23.5505 | -46.6333 | 2022-10-20 04:22:59 | Sao Paulo, Brazil | |||
794151 | 794151 | 2022-10-24 | Brazil | Sao Paulo | 6126367 | 175371 | 0 | -23.5505 | -46.6333 | 2022-10-25 04:21:53 | Sao Paulo, Brazil | |||
1591944 | 1591944 | 2022-10-21 | Brazil | Sao Paulo | 6126367 | 175371 | 0 | -23.5505 | -46.6333 | 2022-10-22 04:22:53 | Sao Paulo, Brazil | |||
2267644 | 2267644 | 2022-10-22 | Brazil | Sao Paulo | 6126367 | 175371 | 0 | -23.5505 | -46.6333 | 2022-10-23 04:22:46 | Sao Paulo, Brazil | |||
2271660 | 2271660 | 2022-10-20 | Brazil | Sao Paulo | 6126367 | 175371 | 0 | -23.5505 | -46.6333 | 2022-10-21 04:22:23 | Sao Paulo, Brazil | |||
3276606 | 3276606 | 2022-10-23 | Brazil | Sao Paulo | 6126367 | 175371 | 0 | -23.5505 | -46.6333 | 2022-10-24 04:22:29 | Sao Paulo, Brazil | |||
3777566 | 3777566 | 2022-08-30 | United Kingdom | England | 19808426 | 175360 | 0 | 52.3555 | -1.1743 | 2022-08-31 04:20:57 | England, United Kingdom | |||
1684162 | 1684162 | 2022-08-29 | United Kingdom | England | 19808426 | 175326 | 0 | 52.3555 | -1.1743 | 2022-08-30 04:21:03 | England, United Kingdom | |||
1880646 | 1880646 | 2022-08-28 | United Kingdom | England | 19808426 | 175282 | 0 | 52.3555 | -1.1743 | 2022-08-29 04:21:06 | England, United Kingdom | |||
515465 | 515465 | 2022-10-15 | Brazil | Sao Paulo | 6120384 | 175252 | 0 | -23.5505 | -46.6333 | 2022-10-16 04:22:39 | Sao Paulo, Brazil | |||
2024490 | 2024490 | 2022-10-17 | Brazil | Sao Paulo | 6120384 | 175252 | 0 | -23.5505 | -46.6333 | 2022-10-18 04:22:42 | Sao Paulo, Brazil | |||
2032522 | 2032522 | 2022-10-14 | Brazil | Sao Paulo | 6120384 | 175252 | 0 | -23.5505 | -46.6333 | 2022-10-15 04:22:00 | Sao Paulo, Brazil | |||
2159268 | 2159268 | 2022-10-16 | Brazil | Sao Paulo | 6120384 | 175252 | 0 | -23.5505 | -46.6333 | 2022-10-17 04:20:31 | 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]);