johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where deaths = 38048 and province_or_state = "Tamil Nadu" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2485952 | 2485952 | 2022-11-16 | India | Tamil Nadu | 3593651 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-17 04:21:11 | Tamil Nadu, India | |||
291963 | 291963 | 2022-11-15 | India | Tamil Nadu | 3593586 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-16 04:21:09 | Tamil Nadu, India | |||
3596993 | 3596993 | 2022-11-14 | India | Tamil Nadu | 3593519 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-15 04:21:16 | Tamil Nadu, India | |||
311851 | 311851 | 2022-11-13 | India | Tamil Nadu | 3593447 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-14 04:21:09 | Tamil Nadu, India | |||
63012 | 63012 | 2022-11-12 | India | Tamil Nadu | 3593371 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-13 04:21:14 | Tamil Nadu, India | |||
2927174 | 2927174 | 2022-11-11 | India | Tamil Nadu | 3593291 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-12 04:20:41 | Tamil Nadu, India | |||
2506010 | 2506010 | 2022-11-10 | India | Tamil Nadu | 3593207 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-11 04:21:22 | Tamil Nadu, India | |||
2430885 | 2430885 | 2022-11-09 | India | Tamil Nadu | 3592810 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-10 04:21:16 | Tamil Nadu, India | |||
479541 | 479541 | 2022-11-08 | India | Tamil Nadu | 3592810 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-09 04:21:22 | Tamil Nadu, India | |||
2438691 | 2438691 | 2022-11-07 | India | Tamil Nadu | 3592810 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-08 04:21:21 | Tamil Nadu, India | |||
1049789 | 1049789 | 2022-11-06 | India | Tamil Nadu | 3592810 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-07 04:21:26 | Tamil Nadu, India | |||
617813 | 617813 | 2022-11-05 | India | Tamil Nadu | 3592696 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-06 04:21:24 | Tamil Nadu, India | |||
1022317 | 1022317 | 2022-11-04 | India | Tamil Nadu | 3592577 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-05 04:21:52 | Tamil Nadu, India | |||
431308 | 431308 | 2022-11-03 | India | Tamil Nadu | 3592454 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-04 04:22:11 | Tamil Nadu, India | |||
849550 | 849550 | 2022-11-02 | India | Tamil Nadu | 3592326 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-03 04:22:05 | Tamil Nadu, India | |||
710401 | 710401 | 2022-11-01 | India | Tamil Nadu | 3592187 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-02 04:22:09 | Tamil Nadu, India | |||
3284850 | 3284850 | 2022-10-31 | India | Tamil Nadu | 3592043 | 38048 | 0 | 11.006091 | 78.400624 | 2022-11-01 04:22:36 | Tamil Nadu, India | |||
319883 | 319883 | 2022-10-30 | India | Tamil Nadu | 3591891 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-31 04:21:36 | Tamil Nadu, India | |||
912159 | 912159 | 2022-10-29 | India | Tamil Nadu | 3591733 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-30 04:22:14 | Tamil Nadu, India | |||
1366428 | 1366428 | 2022-10-28 | India | Tamil Nadu | 3591571 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-29 04:21:13 | Tamil Nadu, India | |||
3038283 | 3038283 | 2022-10-27 | India | Tamil Nadu | 3591405 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-28 04:22:31 | Tamil Nadu, India | |||
538703 | 538703 | 2022-10-26 | India | Tamil Nadu | 3591226 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-27 04:22:01 | Tamil Nadu, India | |||
1830104 | 1830104 | 2022-10-25 | India | Tamil Nadu | 3591043 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-26 04:22:19 | Tamil Nadu, India | |||
794365 | 794365 | 2022-10-24 | India | Tamil Nadu | 3590856 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-25 04:21:53 | Tamil Nadu, India | |||
3276820 | 3276820 | 2022-10-23 | India | Tamil Nadu | 3590658 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-24 04:22:29 | Tamil Nadu, India | |||
2267858 | 2267858 | 2022-10-22 | India | Tamil Nadu | 3590452 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-23 04:22:46 | Tamil Nadu, India | |||
1592158 | 1592158 | 2022-10-21 | India | Tamil Nadu | 3590238 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-22 04:22:53 | Tamil Nadu, India | |||
2271874 | 2271874 | 2022-10-20 | India | Tamil Nadu | 3590016 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-21 04:22:23 | Tamil Nadu, India | |||
198209 | 198209 | 2022-10-19 | India | Tamil Nadu | 3589781 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-20 04:22:59 | Tamil Nadu, India | |||
2756870 | 2756870 | 2022-10-18 | India | Tamil Nadu | 3589537 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-19 04:22:26 | Tamil Nadu, India | |||
2024704 | 2024704 | 2022-10-17 | India | Tamil Nadu | 3589284 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-18 04:22:42 | Tamil Nadu, India | |||
2159482 | 2159482 | 2022-10-16 | India | Tamil Nadu | 3589013 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-17 04:20:31 | Tamil Nadu, India | |||
515679 | 515679 | 2022-10-15 | India | Tamil Nadu | 3588734 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-16 04:22:39 | Tamil Nadu, India | |||
2032736 | 2032736 | 2022-10-14 | India | Tamil Nadu | 3588449 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-15 04:22:00 | Tamil Nadu, India | |||
3753424 | 3753424 | 2022-10-13 | India | Tamil Nadu | 3588157 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-14 04:22:28 | Tamil Nadu, India | |||
3214249 | 3214249 | 2022-10-12 | India | Tamil Nadu | 3587861 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-13 04:22:39 | Tamil Nadu, India | |||
3250098 | 3250098 | 2022-10-11 | India | Tamil Nadu | 3587559 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-12 04:22:51 | Tamil Nadu, India | |||
2967357 | 2967357 | 2022-10-10 | India | Tamil Nadu | 3587255 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-11 04:23:05 | Tamil Nadu, India | |||
3097393 | 3097393 | 2022-10-09 | India | Tamil Nadu | 3586926 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-10 04:22:32 | Tamil Nadu, India | |||
4002618 | 4002618 | 2022-10-08 | India | Tamil Nadu | 3586584 | 38048 | 0 | 11.006091 | 78.400624 | 2022-10-09 04:21:16 | Tamil Nadu, India |
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]);