home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for johns_hopkins_csse_daily_reports
⚠️ 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

850 rows where country_or_region = "Antarctica" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: confirmed, longitude, day (date), last_update (date)

country_or_region 1

  • Antarctica · 850 ✖

province_or_state 0

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1733144 1733144 2022-05-20 Antarctica       11 0 0   -71.9499 23.347 2022-05-21 04:20:58 Antarctica
2572562 2572562 2022-05-19 Antarctica       11 0 0   -71.9499 23.347 2022-05-20 04:20:57 Antarctica
1431948 1431948 2022-05-18 Antarctica       11 0 0   -71.9499 23.347 2022-05-19 04:20:54 Antarctica
1599224 1599224 2022-05-17 Antarctica       11 0 0   -71.9499 23.347 2022-05-18 04:20:50 Antarctica
2425342 2425342 2022-05-16 Antarctica       11 0 0   -71.9499 23.347 2022-05-17 04:20:59 Antarctica
1316666 1316666 2022-05-15 Antarctica       11 0 0   -71.9499 23.347 2022-05-16 04:20:47 Antarctica
2631850 2631850 2022-05-14 Antarctica       11 0 0   -71.9499 23.347 2022-05-15 04:20:53 Antarctica
2671032 2671032 2022-05-13 Antarctica       11 0 0   -71.9499 23.347 2022-05-14 04:20:48 Antarctica
1895901 1895901 2022-05-12 Antarctica       11 0 0   -71.9499 23.347 2022-05-13 04:20:51 Antarctica
1368850 1368850 2022-05-11 Antarctica       11 0 0   -71.9499 23.347 2022-05-12 04:20:54 Antarctica
1978622 1978622 2022-05-10 Antarctica       11 0 0   -71.9499 23.347 2022-05-11 04:20:48 Antarctica
1053082 1053082 2022-05-09 Antarctica       11 0 0   -71.9499 23.347 2022-05-10 04:20:50 Antarctica
2456880 2456880 2022-05-08 Antarctica       11 0 0   -71.9499 23.347 2022-05-09 04:20:54 Antarctica
1126943 1126943 2022-05-07 Antarctica       11 0 0   -71.9499 23.347 2022-05-08 04:20:49 Antarctica
1915954 1915954 2022-05-06 Antarctica       11 0 0   -71.9499 23.347 2022-05-07 04:21:09 Antarctica
3007619 3007619 2022-05-05 Antarctica       11 0 0   -71.9499 23.347 2022-05-06 04:21:00 Antarctica
2065802 2065802 2022-05-04 Antarctica       11 0 0   -71.9499 23.347 2022-05-05 04:20:55 Antarctica
1709086 1709086 2022-05-03 Antarctica       11 0 0   -71.9499 23.347 2022-05-04 04:20:59 Antarctica
1384885 1384885 2022-05-02 Antarctica       11 0 0   -71.9499 23.347 2022-05-03 04:21:00 Antarctica
512915 512915 2022-05-01 Antarctica       11 0 0   -71.9499 23.347 2022-05-02 04:21:10 Antarctica
611345 611345 2022-04-30 Antarctica       11 0 0   -71.9499 23.347 2022-05-01 04:20:57 Antarctica
318485 318485 2022-04-29 Antarctica       11 0 0   -71.9499 23.347 2022-04-30 04:21:05 Antarctica
2971553 2971553 2022-04-28 Antarctica       11 0 0   -71.9499 23.347 2022-04-29 04:20:59 Antarctica
1020959 1020959 2022-04-27 Antarctica       11 0 0   -71.9499 23.347 2022-04-28 04:20:47 Antarctica
1004874 1004874 2022-04-26 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-27 04:20:52 Antarctica
1045062 1045062 2022-04-25 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-26 04:20:51 Antarctica
1829664 1829664 2022-04-24 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-25 04:20:56 Antarctica
2608336 2608336 2022-04-23 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-24 04:20:56 Antarctica
788170 788170 2022-04-22 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-23 04:20:50 Antarctica
3085950 3085950 2022-04-21 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-22 04:20:45 Antarctica
1630498 1630498 2022-04-20 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-21 04:20:46 Antarctica
198250 198250 2022-04-19 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-20 04:20:45 Antarctica
2726331 2726331 2022-04-18 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-19 04:21:00 Antarctica
739911 739911 2022-04-17 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-18 04:21:12 Antarctica
2294116 2294116 2022-04-16 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-17 04:20:59 Antarctica
2492888 2492888 2022-04-15 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-16 04:20:48 Antarctica
1217087 1217087 2022-04-14 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-15 04:20:57 Antarctica
1134964 1134964 2022-04-13 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-13 23:21:06 Antarctica
1487014 1487014 2022-04-12 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-13 04:21:03 Antarctica
190230 190230 2022-04-11 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-12 04:20:49 Antarctica
2987597 2987597 2022-04-10 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-11 04:21:02 Antarctica
1474983 1474983 2022-04-09 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-10 04:20:52 Antarctica
1202734 1202734 2022-04-08 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-09 04:20:42 Antarctica
2121465 2121465 2022-04-07 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-08 04:20:48 Antarctica
630630 630630 2022-04-06 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-07 04:20:53 Antarctica
2983586 2983586 2022-04-05 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-06 04:20:49 Antarctica
302443 302443 2022-04-04 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-05 04:20:48 Antarctica
310465 310465 2022-04-03 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-04 04:20:51 Antarctica
812167 812167 2022-04-02 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-03 04:20:48 Antarctica
2694869 2694869 2022-04-01 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-02 04:20:47 Antarctica
2623830 2623830 2022-03-31 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-04-01 04:20:28 Antarctica
2409796 2409796 2022-03-30 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-31 04:20:56 Antarctica
2109650 2109650 2022-03-29 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-30 04:20:45 Antarctica
1393106 1393106 2022-03-28 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-29 04:20:46 Antarctica
544223 544223 2022-03-27 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-28 04:20:33 Antarctica
1024970 1024970 2022-03-26 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-27 04:20:47 Antarctica
31931 31931 2022-03-25 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-26 04:20:23 Antarctica
6 6 2022-03-24 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-25 04:20:46 Antarctica
1478994 1478994 2022-03-23 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-24 04:20:43 Antarctica
990164 990164 2022-03-22 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-23 04:20:48 Antarctica
1943963 1943963 2022-03-21 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-22 04:20:54 Antarctica
2346596 2346596 2022-03-20 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-21 04:20:50 Antarctica
126461 126461 2022-03-19 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-20 04:20:45 Antarctica
902083 902083 2022-03-18 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-19 04:20:47 Antarctica
1081121 1081121 2022-03-17 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-18 04:20:55 Antarctica
2322113 2322113 2022-03-16 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-17 04:20:56 Antarctica
2354599 2354599 2022-03-15 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-16 04:20:50 Antarctica
532190 532190 2022-03-14 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-15 04:20:47 Antarctica
166372 166372 2022-03-13 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-14 04:20:46 Antarctica
294421 294421 2022-03-12 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-13 04:20:49 Antarctica
556254 556254 2022-03-11 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-12 04:20:50 Antarctica
2132810 2132810 2022-03-10 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-11 04:20:50 Antarctica
298432 298432 2022-03-09 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-10 04:20:48 Antarctica
2481030 2481030 2022-03-08 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-09 04:20:59 Antarctica
1264913 1264913 2022-03-07 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-08 04:20:54 Antarctica
431331 431331 2022-03-06 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-07 04:20:47 Antarctica
1564134 1564134 2022-03-05 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-06 04:20:49 Antarctica
1903923 1903923 2022-03-04 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-05 04:21:10 Antarctica
1462954 1462954 2022-03-03 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-04 04:21:09 Antarctica
1780240 1780240 2022-03-02 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-03 04:21:01 Antarctica
1618268 1618268 2022-03-01 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-02 04:21:07 Antarctica
99187 99187 2022-02-28 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-03-01 04:21:09 Antarctica
724443 724443 2022-02-27 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-28 04:21:05 Antarctica
747707 747707 2022-02-26 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-27 04:21:04 Antarctica
1959543 1959543 2022-02-25 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-26 04:21:12 Antarctica
2975564 2975564 2022-02-24 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-25 04:21:11 Antarctica
2113661 2113661 2022-02-23 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-24 04:21:14 Antarctica
415562 415562 2022-02-22 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-23 04:21:09 Antarctica
2679052 2679052 2022-02-21 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-22 04:21:01 Antarctica
504917 504917 2022-02-20 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-21 04:21:05 Antarctica
1178369 1178369 2022-02-19 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-20 04:21:00 Antarctica
1427937 1427937 2022-02-18 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-19 04:21:11 Antarctica
2496899 2496899 2022-02-17 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-18 04:21:04 Antarctica
2318102 2318102 2022-02-16 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-17 04:20:56 Antarctica
2840747 2840747 2022-02-15 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-16 04:21:10 Antarctica
954218 954218 2022-02-14 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-15 04:21:09 Antarctica
2655881 2655881 2022-02-13 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-14 04:20:51 Antarctica
1213076 1213076 2022-02-12 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-13 04:21:00 Antarctica
1939952 1939952 2022-02-11 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-12 04:21:06 Antarctica
1510815 1510815 2022-02-10 Antarctica       11 0 0   -71.9499 23.346999999999998 2022-02-11 04:21:09 Antarctica

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]);
Powered by Datasette · Queries took 263.144ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette