johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where country_or_region = "India", deaths = 919 and province_or_state = "Tripura" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1436536 | 1436536 | 2022-03-28 | India | Tripura | 100873 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-29 04:20:46 | Tripura, India | |||
876217 | 876217 | 2022-03-27 | India | Tripura | 100872 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-28 04:20:33 | Tripura, India | |||
2163500 | 2163500 | 2022-03-26 | India | Tripura | 100871 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-27 04:20:47 | Tripura, India | |||
1720436 | 1720436 | 2022-03-25 | India | Tripura | 100871 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-26 04:20:23 | Tripura, India | |||
1468053 | 1468053 | 2022-03-24 | India | Tripura | 100871 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-25 04:20:46 | Tripura, India | |||
3022227 | 3022227 | 2022-03-23 | India | Tripura | 100871 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-24 04:20:43 | Tripura, India | |||
1905149 | 1905149 | 2022-03-22 | India | Tripura | 100871 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-23 04:20:48 | Tripura, India | |||
3238280 | 3238280 | 2022-03-21 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-22 04:20:54 | Tripura, India | |||
24353 | 24353 | 2022-03-20 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-21 04:20:50 | Tripura, India | |||
1656363 | 1656363 | 2022-03-19 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-20 04:20:45 | Tripura, India | |||
335889 | 335889 | 2022-03-18 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-19 04:20:47 | Tripura, India | |||
694342 | 694342 | 2022-03-17 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-18 04:20:55 | Tripura, India | |||
2319285 | 2319285 | 2022-03-16 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-17 04:20:56 | Tripura, India | |||
261485 | 261485 | 2022-03-15 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-16 04:20:50 | Tripura, India | |||
2263844 | 2263844 | 2022-03-14 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-15 04:20:47 | Tripura, India | |||
3627910 | 3627910 | 2022-03-13 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-14 04:20:46 | Tripura, India | |||
950818 | 950818 | 2022-03-12 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-13 04:20:49 | Tripura, India | |||
356279 | 356279 | 2022-03-11 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-12 04:20:50 | Tripura, India | |||
1865431 | 1865431 | 2022-03-10 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-11 04:20:50 | Tripura, India | |||
2140126 | 2140126 | 2022-03-09 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-10 04:20:48 | Tripura, India | |||
919637 | 919637 | 2022-03-08 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-09 04:20:59 | Tripura, India | |||
1547924 | 1547924 | 2022-03-07 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-08 04:20:54 | Tripura, India | |||
2199593 | 2199593 | 2022-03-06 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-07 04:20:47 | Tripura, India | |||
2092050 | 2092050 | 2022-03-05 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-06 04:20:49 | Tripura, India | |||
2665750 | 2665750 | 2022-03-04 | India | Tripura | 100868 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-05 04:21:10 | Tripura, India | |||
1644315 | 1644315 | 2022-03-03 | India | Tripura | 100866 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-04 04:21:09 | Tripura, India | |||
2525318 | 2525318 | 2022-03-02 | India | Tripura | 100865 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-03 04:21:01 | Tripura, India | |||
1992612 | 1992612 | 2022-03-01 | India | Tripura | 100863 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-02 04:21:07 | Tripura, India | |||
942786 | 942786 | 2022-02-28 | India | Tripura | 100862 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-01 04:21:09 | Tripura, India | |||
2732977 | 2732977 | 2022-02-27 | India | Tripura | 100860 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-28 04:21:05 | Tripura, India | |||
3046130 | 3046130 | 2022-02-26 | India | Tripura | 100860 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-27 04:21:04 | Tripura, India | |||
574785 | 574785 | 2022-02-25 | India | Tripura | 100859 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-26 04:21:12 | Tripura, India | |||
1511361 | 1511361 | 2022-02-24 | India | Tripura | 100858 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-25 04:21:11 | Tripura, India | |||
1057802 | 1057802 | 2022-02-23 | India | Tripura | 100856 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-24 04:21:14 | Tripura, India | |||
2446725 | 2446725 | 2022-02-22 | India | Tripura | 100852 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-23 04:21:09 | Tripura, India | |||
3718138 | 3718138 | 2022-02-21 | India | Tripura | 100848 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-22 04:21:01 | Tripura, India | |||
3911972 | 3911972 | 2022-02-20 | India | Tripura | 100839 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-21 04:21:05 | Tripura, India | |||
3875530 | 3875530 | 2022-02-19 | India | Tripura | 100838 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-20 04:21:00 | Tripura, India | |||
3855786 | 3855786 | 2022-02-18 | India | Tripura | 100833 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-19 04:21:11 | Tripura, India | |||
1298005 | 1298005 | 2022-02-17 | India | Tripura | 100827 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-18 04:21:04 | Tripura, India | |||
3820391 | 3820391 | 2022-02-16 | India | Tripura | 100817 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-17 04:20:56 | Tripura, India | |||
3671605 | 3671605 | 2022-02-15 | India | Tripura | 100813 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-16 04:21:10 | Tripura, India | |||
2641706 | 2641706 | 2022-02-14 | India | Tripura | 100803 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-15 04:21:09 | Tripura, India | |||
186023 | 186023 | 2022-02-13 | India | Tripura | 100794 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-14 04:20:51 | Tripura, India | |||
315869 | 315869 | 2022-02-12 | India | Tripura | 100790 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-13 04:21:00 | Tripura, India | |||
233195 | 233195 | 2022-02-11 | India | Tripura | 100778 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-12 04:21:06 | Tripura, India | |||
1464037 | 1464037 | 2022-02-10 | India | Tripura | 100761 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-11 04:21:09 | Tripura, India | |||
3073998 | 3073998 | 2022-02-09 | India | Tripura | 100739 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-10 04:21:14 | Tripura, India | |||
1362305 | 1362305 | 2022-02-08 | India | Tripura | 100715 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-09 04:21:04 | Tripura, India | |||
71043 | 71043 | 2022-02-07 | India | Tripura | 100697 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-08 04:21:15 | Tripura, 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]);