johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Chile" and province_or_state = "Tarapaca" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687260 | 3687260 | 2022-01-13 | Chile | Tarapaca | 50704 | 834 | 0 | -19.9232 | -69.5132 | 2022-01-14 04:21:54 | Tarapaca, Chile | |||
3612844 | 3612844 | 2022-01-12 | Chile | Tarapaca | 49882 | 832 | 0 | -19.9232 | -69.5132 | 2022-01-13 08:00:09 | Tarapaca, Chile | |||
1113369 | 1113369 | 2022-01-11 | Chile | Tarapaca | 49271 | 832 | 0 | -19.9232 | -69.5132 | 2022-01-12 04:21:44 | Tarapaca, Chile | |||
1692097 | 1692097 | 2022-01-10 | Chile | Tarapaca | 48628 | 832 | 0 | -19.9232 | -69.5132 | 2022-01-11 04:22:01 | Tarapaca, Chile | |||
126512 | 126512 | 2022-01-09 | Chile | Tarapaca | 47976 | 832 | 0 | -19.9232 | -69.5132 | 2022-01-10 04:22:07 | Tarapaca, Chile | |||
1215347 | 1215347 | 2022-01-08 | Chile | Tarapaca | 47450 | 831 | 0 | -19.9232 | -69.5132 | 2022-01-09 04:21:46 | Tarapaca, Chile | |||
1389440 | 1389440 | 2022-01-07 | Chile | Tarapaca | 46896 | 830 | 0 | -19.9232 | -69.5132 | 2022-01-08 04:21:53 | Tarapaca, Chile | |||
2609827 | 2609827 | 2022-01-06 | Chile | Tarapaca | 46450 | 830 | 0 | -19.9232 | -69.5132 | 2022-01-07 04:22:09 | Tarapaca, Chile | |||
1281769 | 1281769 | 2022-01-05 | Chile | Tarapaca | 46096 | 830 | 0 | -19.9232 | -69.5132 | 2022-01-06 04:22:09 | Tarapaca, Chile | |||
1285785 | 1285785 | 2022-01-04 | Chile | Tarapaca | 45881 | 830 | 0 | -19.9232 | -69.5132 | 2022-01-05 04:21:59 | Tarapaca, Chile | |||
1700129 | 1700129 | 2022-01-03 | Chile | Tarapaca | 45790 | 830 | 0 | -19.9232 | -69.5132 | 2022-01-04 04:22:17 | Tarapaca, Chile | |||
3519212 | 3519212 | 2022-01-02 | Chile | Tarapaca | 45663 | 829 | 0 | -19.9232 | -69.5132 | 2022-01-03 02:22:25 | Tarapaca, Chile | |||
2167342 | 2167342 | 2022-01-01 | Chile | Tarapaca | 45371 | 829 | 0 | -19.9232 | -69.5132 | 2022-01-02 04:20:52 | Tarapaca, Chile | |||
2776773 | 2776773 | 2021-12-31 | Chile | Tarapaca | 45165 | 829 | 0 | -19.9232 | -69.5132 | 2022-01-01 04:22:14 | Tarapaca, Chile | |||
3998430 | 3998430 | 2021-12-30 | Chile | Tarapaca | 44997 | 829 | 0 | -19.9232 | -69.5132 | 2021-12-31 04:21:50 | Tarapaca, Chile | |||
1668237 | 1668237 | 2021-12-29 | Chile | Tarapaca | 44893 | 828 | 0 | -19.9232 | -69.5132 | 2021-12-30 04:21:25 | Tarapaca, Chile | |||
1432346 | 1432346 | 2021-12-28 | Chile | Tarapaca | 44825 | 828 | 0 | -19.9232 | -69.5132 | 2021-12-29 03:21:43 | Tarapaca, Chile | |||
730307 | 730307 | 2021-12-27 | Chile | Tarapaca | 44792 | 828 | 0 | -19.9232 | -69.5132 | 2021-12-28 04:21:47 | Tarapaca, Chile | |||
2111479 | 2111479 | 2021-12-26 | Chile | Tarapaca | 44765 | 828 | 0 | -19.9232 | -69.5132 | 2021-12-27 04:21:58 | Tarapaca, Chile | |||
3604851 | 3604851 | 2021-12-25 | Chile | Tarapaca | 44742 | 828 | 0 | -19.9232 | -69.5132 | 2021-12-26 04:21:50 | Tarapaca, Chile | |||
2963169 | 2963169 | 2021-12-24 | Chile | Tarapaca | 44709 | 828 | 0 | -19.9232 | -69.5132 | 2021-12-25 04:21:37 | Tarapaca, Chile | |||
3816201 | 3816201 | 2021-12-23 | Chile | Tarapaca | 44686 | 827 | 0 | -19.9232 | -69.5132 | 2021-12-24 04:21:34 | Tarapaca, Chile | |||
798209 | 798209 | 2021-12-22 | Chile | Tarapaca | 44660 | 825 | 0 | -19.9232 | -69.5132 | 2021-12-23 04:21:21 | Tarapaca, Chile | |||
3828249 | 3828249 | 2021-12-21 | Chile | Tarapaca | 44641 | 825 | 0 | -19.9232 | -69.5132 | 2021-12-22 04:21:54 | Tarapaca, Chile | |||
1254552 | 1254552 | 2021-12-20 | Chile | Tarapaca | 44620 | 825 | 0 | -19.9232 | -69.5132 | 2021-12-21 03:21:27 | Tarapaca, Chile | |||
2903495 | 2903495 | 2021-12-19 | Chile | Tarapaca | 44601 | 825 | 0 | -19.9232 | -69.5132 | 2021-12-20 04:21:43 | Tarapaca, Chile | |||
1258568 | 1258568 | 2021-12-18 | Chile | Tarapaca | 44568 | 825 | 0 | -19.9232 | -69.5132 | 2021-12-19 04:21:11 | Tarapaca, Chile | |||
2398596 | 2398596 | 2021-12-17 | Chile | Tarapaca | 44540 | 824 | 0 | -19.9232 | -69.5132 | 2021-12-18 02:22:20 | Tarapaca, Chile | |||
1716134 | 1716134 | 2021-12-16 | Chile | Tarapaca | 44503 | 822 | 0 | -19.9232 | -69.5132 | 2021-12-17 04:22:14 | Tarapaca, Chile | |||
3495968 | 3495968 | 2021-12-15 | Chile | Tarapaca | 44488 | 821 | 0 | -19.9232 | -69.5132 | 2021-12-16 04:22:11 | Tarapaca, Chile | |||
2087753 | 2087753 | 2021-12-14 | Chile | Tarapaca | 44459 | 821 | 0 | -19.9232 | -69.5132 | 2021-12-15 03:22:16 | Tarapaca, Chile | |||
782170 | 782170 | 2021-12-13 | Chile | Tarapaca | 44441 | 821 | 0 | -19.9232 | -69.5132 | 2021-12-14 04:22:38 | Tarapaca, Chile | |||
1660205 | 1660205 | 2021-12-12 | Chile | Tarapaca | 44409 | 820 | 0 | -19.9232 | -69.5132 | 2021-12-13 04:22:02 | Tarapaca, Chile | |||
1664221 | 1664221 | 2021-12-11 | Chile | Tarapaca | 44393 | 819 | 0 | -19.9232 | -69.5132 | 2021-12-12 04:22:12 | Tarapaca, Chile | |||
3655373 | 3655373 | 2021-12-10 | Chile | Tarapaca | 44355 | 818 | 0 | -19.9232 | -69.5132 | 2021-12-11 04:22:45 | Tarapaca, Chile | |||
1077704 | 1077704 | 2021-12-09 | Chile | Tarapaca | 44355 | 818 | 0 | -19.9232 | -69.5132 | 2021-12-10 04:22:28 | Tarapaca, Chile | |||
550553 | 550553 | 2021-12-08 | Chile | Tarapaca | 44334 | 817 | 0 | -19.9232 | -69.5132 | 2021-12-09 04:22:49 | Tarapaca, Chile | |||
404073 | 404073 | 2021-12-07 | Chile | Tarapaca | 44298 | 817 | 0 | -19.9232 | -69.5132 | 2021-12-08 04:22:46 | Tarapaca, Chile | |||
1030155 | 1030155 | 2021-12-06 | Chile | Tarapaca | 44273 | 817 | 0 | -19.9232 | -69.5132 | 2021-12-07 04:22:34 | Tarapaca, Chile | |||
1740318 | 1740318 | 2021-12-05 | Chile | Tarapaca | 44251 | 816 | 0 | -19.9232 | -69.5132 | 2021-12-06 04:22:34 | Tarapaca, Chile | |||
137750 | 137750 | 2021-12-04 | Chile | Tarapaca | 44229 | 816 | 0 | -19.9232 | -69.5132 | 2021-12-05 04:22:25 | Tarapaca, Chile | |||
2195403 | 2195403 | 2021-12-03 | Chile | Tarapaca | 44204 | 816 | 0 | -19.9232 | -69.5132 | 2021-12-04 04:22:18 | Tarapaca, Chile | |||
109 | 109 | 2021-12-02 | Chile | Tarapaca | 44182 | 816 | 0 | -19.9232 | -69.5132 | 2021-12-03 04:23:05 | Tarapaca, Chile | |||
1144708 | 1144708 | 2021-12-01 | Chile | Tarapaca | 44127 | 816 | 0 | -19.9232 | -69.5132 | 2021-12-02 04:22:37 | Tarapaca, Chile | |||
3401220 | 3401220 | 2021-11-30 | Chile | Tarapaca | 44102 | 816 | 0 | -19.9232 | -69.5132 | 2021-12-01 04:22:29 | Tarapaca, Chile | |||
149763 | 149763 | 2021-11-29 | Chile | Tarapaca | 44079 | 816 | 0 | -19.9232 | -69.5132 | 2021-11-30 04:22:53 | Tarapaca, Chile | |||
1231409 | 1231409 | 2021-11-28 | Chile | Tarapaca | 44047 | 816 | 0 | -19.9232 | -69.5132 | 2021-11-29 04:22:30 | Tarapaca, Chile | |||
1358116 | 1358116 | 2021-11-27 | Chile | Tarapaca | 44009 | 816 | 0 | -19.9232 | -69.5132 | 2021-11-28 04:22:43 | Tarapaca, Chile | |||
758107 | 758107 | 2021-11-26 | Chile | Tarapaca | 43951 | 815 | 0 | -19.9232 | -69.5132 | 2021-11-27 04:22:45 | Tarapaca, Chile | |||
1802524 | 1802524 | 2021-11-25 | Chile | Tarapaca | 43884 | 815 | 0 | -19.9232 | -69.5132 | 2021-11-26 04:22:33 | Tarapaca, Chile | |||
903958 | 903958 | 2021-11-24 | Chile | Tarapaca | 43818 | 814 | 0 | -19.9232 | -69.5132 | 2021-11-25 04:22:33 | Tarapaca, Chile | |||
3069808 | 3069808 | 2021-11-23 | Chile | Tarapaca | 43730 | 814 | 0 | -19.9232 | -69.5132 | 2021-11-24 04:22:14 | Tarapaca, Chile | |||
3748906 | 3748906 | 2021-11-22 | Chile | Tarapaca | 43668 | 814 | 0 | -19.9232 | -69.5132 | 2021-11-23 04:22:39 | Tarapaca, Chile | |||
1014113 | 1014113 | 2021-11-21 | Chile | Tarapaca | 43625 | 813 | 0 | -19.9232 | -69.5132 | 2021-11-22 04:22:20 | Tarapaca, Chile | |||
722277 | 722277 | 2021-11-20 | Chile | Tarapaca | 43559 | 813 | 0 | -19.9232 | -69.5132 | 2021-11-21 04:22:13 | Tarapaca, Chile | |||
161807 | 161807 | 2021-11-19 | Chile | Tarapaca | 43497 | 812 | 0 | -19.9232 | -69.5132 | 2021-11-20 04:22:17 | Tarapaca, Chile | |||
3288694 | 3288694 | 2021-11-18 | Chile | Tarapaca | 43383 | 812 | 0 | -19.9232 | -69.5132 | 2021-11-19 04:21:40 | Tarapaca, Chile | |||
447150 | 447150 | 2021-11-17 | Chile | Tarapaca | 43310 | 812 | 0 | -19.9232 | -69.5132 | 2021-11-18 04:21:33 | Tarapaca, Chile | |||
3342400 | 3342400 | 2021-11-16 | Chile | Tarapaca | 43256 | 812 | 0 | -19.9232 | -69.5132 | 2021-11-17 04:21:48 | Tarapaca, Chile | |||
2287236 | 2287236 | 2021-11-15 | Chile | Tarapaca | 43219 | 812 | 0 | -19.9232 | -69.5132 | 2021-11-16 04:21:10 | Tarapaca, Chile | |||
1322010 | 1322010 | 2021-11-14 | Chile | Tarapaca | 43186 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-15 04:21:36 | Tarapaca, Chile | |||
686136 | 686136 | 2021-11-13 | Chile | Tarapaca | 43126 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-14 04:21:31 | Tarapaca, Chile | |||
714245 | 714245 | 2021-11-12 | Chile | Tarapaca | 43062 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-13 04:21:38 | Tarapaca, Chile | |||
28195 | 28195 | 2021-11-11 | Chile | Tarapaca | 42970 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-12 04:22:01 | Tarapaca, Chile | |||
2844634 | 2844634 | 2021-11-10 | Chile | Tarapaca | 42907 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-11 04:21:45 | Tarapaca, Chile | |||
86904 | 86904 | 2021-11-09 | Chile | Tarapaca | 42866 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-10 04:21:38 | Tarapaca, Chile | |||
3639332 | 3639332 | 2021-11-08 | Chile | Tarapaca | 42820 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-09 04:21:36 | Tarapaca, Chile | |||
2000440 | 2000440 | 2021-11-07 | Chile | Tarapaca | 42773 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-08 04:21:43 | Tarapaca, Chile | |||
495431 | 495431 | 2021-11-06 | Chile | Tarapaca | 42737 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-07 04:21:53 | Tarapaca, Chile | |||
3121286 | 3121286 | 2021-11-05 | Chile | Tarapaca | 42677 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-06 04:21:51 | Tarapaca, Chile | |||
698184 | 698184 | 2021-11-04 | Chile | Tarapaca | 42647 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-05 04:21:54 | Tarapaca, Chile | |||
275962 | 275962 | 2021-11-03 | Chile | Tarapaca | 42612 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-04 04:22:20 | Tarapaca, Chile | |||
43487 | 43487 | 2021-11-02 | Chile | Tarapaca | 42595 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-03 06:22:09 | Tarapaca, Chile | |||
3511183 | 3511183 | 2021-11-01 | Chile | Tarapaca | 42557 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-02 04:22:03 | Tarapaca, Chile | |||
287775 | 287775 | 2021-10-31 | Chile | Tarapaca | 42524 | 811 | 0 | -19.9232 | -69.5132 | 2021-11-01 04:22:01 | Tarapaca, Chile | |||
2720781 | 2720781 | 2021-10-30 | Chile | Tarapaca | 42467 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-31 04:22:08 | Tarapaca, Chile | |||
566883 | 566883 | 2021-10-29 | Chile | Tarapaca | 42447 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-30 04:22:03 | Tarapaca, Chile | |||
4125 | 4125 | 2021-10-28 | Chile | Tarapaca | 42379 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-29 04:22:03 | Tarapaca, Chile | |||
534515 | 534515 | 2021-10-27 | Chile | Tarapaca | 42342 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-28 04:22:08 | Tarapaca, Chile | |||
3491952 | 3491952 | 2021-10-26 | Chile | Tarapaca | 42302 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-27 04:22:32 | Tarapaca, Chile | |||
3793674 | 3793674 | 2021-10-25 | Chile | Tarapaca | 42264 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-26 04:22:09 | Tarapaca, Chile | |||
682120 | 682120 | 2021-10-24 | Chile | Tarapaca | 42234 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-25 04:22:31 | Tarapaca, Chile | |||
770128 | 770128 | 2021-10-23 | Chile | Tarapaca | 42205 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-24 04:21:22 | Tarapaca, Chile | |||
653775 | 653775 | 2021-10-22 | Chile | Tarapaca | 42156 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-23 04:21:32 | Tarapaca, Chile | |||
2123522 | 2123522 | 2021-10-21 | Chile | Tarapaca | 42110 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-22 04:21:14 | Tarapaca, Chile | |||
443134 | 443134 | 2021-10-20 | Chile | Tarapaca | 42073 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-21 04:21:18 | Tarapaca, Chile | |||
597453 | 597453 | 2021-10-19 | Chile | Tarapaca | 42061 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-20 04:21:00 | Tarapaca, Chile | |||
2043630 | 2043630 | 2021-10-18 | Chile | Tarapaca | 42025 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-19 04:20:54 | Tarapaca, Chile | |||
1908991 | 1908991 | 2021-10-17 | Chile | Tarapaca | 41998 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-18 04:21:10 | Tarapaca, Chile | |||
934580 | 934580 | 2021-10-16 | Chile | Tarapaca | 41955 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-17 04:21:29 | Tarapaca, Chile | |||
2943135 | 2943135 | 2021-10-15 | Chile | Tarapaca | 41910 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-16 04:21:15 | Tarapaca, Chile | |||
491415 | 491415 | 2021-10-14 | Chile | Tarapaca | 41888 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-15 04:21:26 | Tarapaca, Chile | |||
633703 | 633703 | 2021-10-13 | Chile | Tarapaca | 41867 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-14 04:21:29 | Tarapaca, Chile | |||
1491381 | 1491381 | 2021-10-12 | Chile | Tarapaca | 41830 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-13 04:20:51 | Tarapaca, Chile | |||
3007114 | 3007114 | 2021-10-11 | Chile | Tarapaca | 41810 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-12 04:21:09 | Tarapaca, Chile | |||
423130 | 423130 | 2021-10-10 | Chile | Tarapaca | 41777 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-11 04:21:31 | Tarapaca, Chile | |||
2875987 | 2875987 | 2021-10-09 | Chile | Tarapaca | 41761 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-10 04:21:38 | Tarapaca, Chile | |||
2959153 | 2959153 | 2021-10-08 | Chile | Tarapaca | 41723 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-09 04:21:34 | Tarapaca, Chile | |||
467191 | 467191 | 2021-10-07 | Chile | Tarapaca | 41706 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-08 04:21:25 | Tarapaca, Chile | |||
2458571 | 2458571 | 2021-10-06 | Chile | Tarapaca | 41663 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-07 04:21:36 | Tarapaca, Chile |
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]);