daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Kerala" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | India | Kerala | 6789398 | 71023 | 0 | 10.450898 | 76.405749 | 2022-09-21 04:23:22 | Kerala, India | |||
2022-09-19 | India | Kerala | 6787915 | 71004 | 0 | 10.450898 | 76.405749 | 2022-09-20 04:22:48 | Kerala, India | |||
2022-09-18 | India | Kerala | 6786094 | 70998 | 0 | 10.450898 | 76.405749 | 2022-09-19 04:21:49 | Kerala, India | |||
2022-09-17 | India | Kerala | 6784044 | 70990 | 0 | 10.450898 | 76.405749 | 2022-09-18 04:22:50 | Kerala, India | |||
2022-09-16 | India | Kerala | 6781833 | 70968 | 0 | 10.450898 | 76.405749 | 2022-09-17 04:20:19 | Kerala, India | |||
2022-09-15 | India | Kerala | 6779622 | 70953 | 0 | 10.450898 | 76.405749 | 2022-09-16 04:21:19 | Kerala, India | |||
2022-09-14 | India | Kerala | 6777195 | 70949 | 0 | 10.450898 | 76.405749 | 2022-09-15 04:21:02 | Kerala, India | |||
2022-09-13 | India | Kerala | 6774646 | 70928 | 0 | 10.450898 | 76.405749 | 2022-09-14 04:20:44 | Kerala, India | |||
2022-09-12 | India | Kerala | 6772995 | 70915 | 0 | 10.450898 | 76.405749 | 2022-09-13 04:20:57 | Kerala, India | |||
2022-09-11 | India | Kerala | 6771229 | 70908 | 0 | 10.450898 | 76.405749 | 2022-09-12 04:20:58 | Kerala, India | |||
2022-09-10 | India | Kerala | 6769332 | 70904 | 0 | 10.450898 | 76.405749 | 2022-09-11 04:20:50 | Kerala, India | |||
2022-09-09 | India | Kerala | 6768190 | 70900 | 0 | 10.450898 | 76.405749 | 2022-09-10 04:21:10 | Kerala, India | |||
2022-09-08 | India | Kerala | 6767036 | 70898 | 0 | 10.450898 | 76.405749 | 2022-09-09 04:21:11 | Kerala, India | |||
2022-09-07 | India | Kerala | 6765407 | 70885 | 0 | 10.450898 | 76.405749 | 2022-09-08 04:21:02 | Kerala, India | |||
2022-09-06 | India | Kerala | 6763720 | 70871 | 0 | 10.450898 | 76.405749 | 2022-09-07 04:20:59 | Kerala, India | |||
2022-09-05 | India | Kerala | 6762566 | 70859 | 0 | 10.450898 | 76.405749 | 2022-09-06 04:21:02 | Kerala, India | |||
2022-09-04 | India | Kerala | 6761424 | 70857 | 0 | 10.450898 | 76.405749 | 2022-09-05 04:21:01 | Kerala, India | |||
2022-09-03 | India | Kerala | 6760118 | 70850 | 0 | 10.450898 | 76.405749 | 2022-09-04 04:21:22 | Kerala, India | |||
2022-09-02 | India | Kerala | 6758702 | 70845 | 0 | 10.450898 | 76.405749 | 2022-09-03 04:21:04 | Kerala, India | |||
2022-09-01 | India | Kerala | 6757419 | 70834 | 0 | 10.450898 | 76.405749 | 2022-09-02 04:21:07 | Kerala, India | |||
2022-08-31 | India | Kerala | 6755943 | 70831 | 0 | 10.450898 | 76.405749 | 2022-09-01 04:21:03 | Kerala, India | |||
2022-08-30 | India | Kerala | 6752218 | 70808 | 0 | 10.450898 | 76.405749 | 2022-08-31 04:20:57 | Kerala, India | |||
2022-08-29 | India | Kerala | 6752218 | 70808 | 0 | 10.450898 | 76.405749 | 2022-08-30 04:21:03 | Kerala, India | |||
2022-08-28 | India | Kerala | 6752218 | 70808 | 0 | 10.450898 | 76.405749 | 2022-08-29 04:21:06 | Kerala, India | |||
2022-08-27 | India | Kerala | 6751095 | 70791 | 0 | 10.450898 | 76.405749 | 2022-08-28 04:21:02 | Kerala, India | |||
2022-08-26 | India | Kerala | 6749675 | 70763 | 0 | 10.450898 | 76.405749 | 2022-08-27 04:20:57 | Kerala, India | |||
2022-08-25 | India | Kerala | 6748557 | 70759 | 0 | 10.450898 | 76.405749 | 2022-08-26 04:21:02 | Kerala, India | |||
2022-08-24 | India | Kerala | 6747371 | 70728 | 0 | 10.450898 | 76.405749 | 2022-08-25 04:21:13 | Kerala, India | |||
2022-08-23 | India | Kerala | 6746217 | 70723 | 0 | 10.450898 | 76.405749 | 2022-08-24 04:20:46 | Kerala, India | |||
2022-08-22 | India | Kerala | 6745310 | 70719 | 0 | 10.450898 | 76.405749 | 2022-08-23 04:20:56 | Kerala, India | |||
2022-08-21 | India | Kerala | 6744387 | 70713 | 0 | 10.450898 | 76.405749 | 2022-08-22 04:20:38 | Kerala, India | |||
2022-08-20 | India | Kerala | 6743298 | 70703 | 0 | 10.450898 | 76.405749 | 2022-08-21 04:20:44 | Kerala, India | |||
2022-08-19 | India | Kerala | 6742241 | 70694 | 0 | 10.450898 | 76.405749 | 2022-08-20 04:21:01 | Kerala, India | |||
2022-08-18 | India | Kerala | 6741148 | 70688 | 0 | 10.450898 | 76.405749 | 2022-08-19 04:20:54 | Kerala, India | |||
2022-08-17 | India | Kerala | 6739909 | 70679 | 0 | 10.450898 | 76.405749 | 2022-08-18 04:21:11 | Kerala, India | |||
2022-08-16 | India | Kerala | 6738758 | 70650 | 0 | 10.450898 | 76.405749 | 2022-08-17 04:20:59 | Kerala, India | |||
2022-08-15 | India | Kerala | 6738154 | 70644 | 0 | 10.450898 | 76.405749 | 2022-08-16 04:20:58 | Kerala, India | |||
2022-08-14 | India | Kerala | 6737396 | 70643 | 0 | 10.450898 | 76.405749 | 2022-08-15 04:20:59 | Kerala, India | |||
2022-08-13 | India | Kerala | 6736389 | 70638 | 0 | 10.450898 | 76.405749 | 2022-08-14 04:20:55 | Kerala, India | |||
2022-08-12 | India | Kerala | 6735308 | 70626 | 0 | 10.450898 | 76.405749 | 2022-08-13 04:20:52 | Kerala, India | |||
2022-08-11 | India | Kerala | 6734188 | 70602 | 0 | 10.450898 | 76.405749 | 2022-08-12 04:20:54 | Kerala, India | |||
2022-08-10 | India | Kerala | 6732976 | 70592 | 0 | 10.450898 | 76.405749 | 2022-08-11 04:20:49 | Kerala, India | |||
2022-08-09 | India | Kerala | 6731659 | 70588 | 0 | 10.450898 | 76.405749 | 2022-08-10 04:20:57 | Kerala, India | |||
2022-08-08 | India | Kerala | 6730762 | 70582 | 0 | 10.450898 | 76.405749 | 2022-08-09 04:20:34 | Kerala, India | |||
2022-08-07 | India | Kerala | 6728697 | 70557 | 0 | 10.450898 | 76.405749 | 2022-08-08 04:21:08 | Kerala, India | |||
2022-08-06 | India | Kerala | 6728697 | 70557 | 0 | 10.450898 | 76.405749 | 2022-08-07 04:20:54 | Kerala, India | |||
2022-08-05 | India | Kerala | 6727584 | 70548 | 0 | 10.450898 | 76.405749 | 2022-08-06 04:20:56 | Kerala, India | |||
2022-08-04 | India | Kerala | 6726281 | 70536 | 0 | 10.450898 | 76.405749 | 2022-08-05 04:20:52 | Kerala, India | |||
2022-08-03 | India | Kerala | 6724917 | 70509 | 0 | 10.450898 | 76.405749 | 2022-08-04 04:20:58 | Kerala, India | |||
2022-08-02 | India | Kerala | 6723468 | 70493 | 0 | 10.450898 | 76.405749 | 2022-08-03 04:20:59 | Kerala, India | |||
2022-08-01 | India | Kerala | 6722411 | 70481 | 0 | 10.450898 | 76.405749 | 2022-08-02 04:20:53 | Kerala, India | |||
2022-07-31 | India | Kerala | 6721090 | 70474 | 0 | 10.450898 | 76.405749 | 2022-08-01 04:21:03 | Kerala, India | |||
2022-07-30 | India | Kerala | 6719451 | 70459 | 0 | 10.450898 | 76.405749 | 2022-07-31 04:21:02 | Kerala, India | |||
2022-07-29 | India | Kerala | 6717856 | 70451 | 0 | 10.450898 | 76.405749 | 2022-07-30 04:20:42 | Kerala, India | |||
2022-07-28 | India | Kerala | 6714410 | 70424 | 0 | 10.450898 | 76.405749 | 2022-07-29 04:20:45 | Kerala, India | |||
2022-07-27 | India | Kerala | 6714410 | 70425 | 0 | 10.450898 | 76.405749 | 2022-07-28 04:20:56 | Kerala, India | |||
2022-07-26 | India | Kerala | 6712280 | 70412 | 0 | 10.450898 | 76.405749 | 2022-07-27 04:21:04 | Kerala, India | |||
2022-07-25 | India | Kerala | 6710792 | 70393 | 0 | 10.450898 | 76.405749 | 2022-07-26 04:20:58 | Kerala, India | |||
2022-07-24 | India | Kerala | 6709092 | 70386 | 0 | 10.450898 | 76.405749 | 2022-07-25 04:20:51 | Kerala, India | |||
2022-07-23 | India | Kerala | 6707071 | 70373 | 0 | 10.450898 | 76.405749 | 2022-07-24 04:20:47 | Kerala, India | |||
2022-07-22 | India | Kerala | 6704819 | 70366 | 0 | 10.450898 | 76.405749 | 2022-07-23 04:20:53 | Kerala, India | |||
2022-07-21 | India | Kerala | 6702342 | 70334 | 0 | 10.450898 | 76.405749 | 2022-07-22 04:21:15 | Kerala, India | |||
2022-07-20 | India | Kerala | 6699680 | 70312 | 0 | 10.450898 | 76.405749 | 2022-07-21 04:21:10 | Kerala, India | |||
2022-07-19 | India | Kerala | 6697013 | 70295 | 0 | 10.450898 | 76.405749 | 2022-07-20 04:20:59 | Kerala, India | |||
2022-07-18 | India | Kerala | 6695156 | 70284 | 0 | 10.450898 | 76.405749 | 2022-07-19 04:20:58 | Kerala, India | |||
2022-07-17 | India | Kerala | 6693008 | 70279 | 0 | 10.450898 | 76.405749 | 2022-07-18 04:20:59 | Kerala, India | |||
2022-07-16 | India | Kerala | 6690404 | 70250 | 0 | 10.450898 | 76.405749 | 2022-07-17 04:21:15 | Kerala, India | |||
2022-07-15 | India | Kerala | 6687533 | 70233 | 0 | 10.450898 | 76.405749 | 2022-07-16 04:21:05 | Kerala, India | |||
2022-07-14 | India | Kerala | 6684554 | 70206 | 0 | 10.450898 | 76.405749 | 2022-07-15 04:20:53 | Kerala, India | |||
2022-07-13 | India | Kerala | 6681317 | 70186 | 0 | 10.450898 | 76.405749 | 2022-07-14 04:20:57 | Kerala, India | |||
2022-07-12 | India | Kerala | 6677772 | 70170 | 0 | 10.450898 | 76.405749 | 2022-07-13 04:20:58 | Kerala, India | |||
2022-07-11 | India | Kerala | 6675561 | 70153 | 0 | 10.450898 | 76.405749 | 2022-07-12 04:20:51 | Kerala, India | |||
2022-07-10 | India | Kerala | 6673029 | 70150 | 0 | 10.450898 | 76.405749 | 2022-07-11 04:20:46 | Kerala, India | |||
2022-07-09 | India | Kerala | 6670145 | 70132 | 0 | 10.450898 | 76.405749 | 2022-07-10 04:20:54 | Kerala, India | |||
2022-07-08 | India | Kerala | 6666959 | 70108 | 0 | 10.450898 | 76.405749 | 2022-07-09 04:20:59 | Kerala, India | |||
2022-07-07 | India | Kerala | 6663649 | 70089 | 0 | 10.450898 | 76.405749 | 2022-07-08 04:20:56 | Kerala, India | |||
2022-07-06 | India | Kerala | 6659988 | 70073 | 0 | 10.450898 | 76.405749 | 2022-07-07 04:20:55 | Kerala, India | |||
2022-07-05 | India | Kerala | 6655875 | 70054 | 0 | 10.450898 | 76.405749 | 2022-07-06 04:20:58 | Kerala, India | |||
2022-07-04 | India | Kerala | 6653272 | 70048 | 0 | 10.450898 | 76.405749 | 2022-07-05 04:20:45 | Kerala, India | |||
2022-07-03 | India | Kerala | 6649950 | 70046 | 0 | 10.450898 | 76.405749 | 2022-07-04 04:20:54 | Kerala, India | |||
2022-07-02 | India | Kerala | 6646308 | 70037 | 0 | 10.450898 | 76.405749 | 2022-07-03 04:20:59 | Kerala, India | |||
2022-07-01 | India | Kerala | 6642709 | 70023 | 0 | 10.450898 | 76.405749 | 2022-07-02 04:21:16 | Kerala, India | |||
2022-06-30 | India | Kerala | 6638805 | 70008 | 0 | 10.450898 | 76.405749 | 2022-07-01 04:21:10 | Kerala, India | |||
2022-06-29 | India | Kerala | 6634722 | 69993 | 0 | 10.450898 | 76.405749 | 2022-06-30 04:21:01 | Kerala, India | |||
2022-06-28 | India | Kerala | 6630263 | 69976 | 0 | 10.450898 | 76.405749 | 2022-06-29 04:20:59 | Kerala, India | |||
2022-06-27 | India | Kerala | 6627270 | 69964 | 0 | 10.450898 | 76.405749 | 2022-06-28 04:20:58 | Kerala, India | |||
2022-06-26 | India | Kerala | 6624064 | 69951 | 0 | 10.450898 | 76.405749 | 2022-06-27 04:21:00 | Kerala, India | |||
2022-06-25 | India | Kerala | 6620686 | 69945 | 0 | 10.450898 | 76.405749 | 2022-06-26 04:21:02 | Kerala, India | |||
2022-06-24 | India | Kerala | 6616588 | 69935 | 0 | 10.450898 | 76.405749 | 2022-06-25 04:20:57 | Kerala, India | |||
2022-06-23 | India | Kerala | 6612607 | 69924 | 0 | 10.450898 | 76.405749 | 2022-06-24 04:20:58 | Kerala, India | |||
2022-06-22 | India | Kerala | 6608717 | 69917 | 0 | 10.450898 | 76.405749 | 2022-06-23 04:20:55 | Kerala, India | |||
2022-06-21 | India | Kerala | 6604493 | 69897 | 0 | 10.450898 | 76.405749 | 2022-06-22 04:20:54 | Kerala, India | |||
2022-06-20 | India | Kerala | 6601884 | 69889 | 0 | 10.450898 | 76.405749 | 2022-06-21 04:20:56 | Kerala, India | |||
2022-06-19 | India | Kerala | 6599098 | 69884 | 0 | 10.450898 | 76.405749 | 2022-06-20 04:21:01 | Kerala, India | |||
2022-06-18 | India | Kerala | 6595722 | 69873 | 0 | 10.450898 | 76.405749 | 2022-06-19 04:20:51 | Kerala, India | |||
2022-06-17 | India | Kerala | 6592469 | 69866 | 0 | 10.450898 | 76.405749 | 2022-06-18 04:21:10 | Kerala, India | |||
2022-06-16 | India | Kerala | 6589307 | 69853 | 0 | 10.450898 | 76.405749 | 2022-06-17 04:20:56 | Kerala, India | |||
2022-06-15 | India | Kerala | 6585888 | 69845 | 0 | 10.450898 | 76.405749 | 2022-06-16 04:20:55 | Kerala, India | |||
2022-06-14 | India | Kerala | 6582400 | 69842 | 0 | 10.450898 | 76.405749 | 2022-06-15 04:20:54 | Kerala, India | |||
2022-06-13 | India | Kerala | 6580411 | 69835 | 0 | 10.450898 | 76.405749 | 2022-06-14 04:20:52 | Kerala, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;