johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Haryana" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435945 | 3435945 | 2020-07-11 | India | Haryana | 20582 | 297 | 15394 | 4891 | 29.20004 | 76.332824 | 2020-07-12 04:34:30 | Haryana, India | ||
3237443 | 3237443 | 2020-07-10 | India | Haryana | 19934 | 290 | 14904 | 4740 | 29.20004 | 76.332824 | 2020-07-11 04:34:26 | Haryana, India | ||
1005428 | 1005428 | 2020-07-09 | India | Haryana | 19369 | 287 | 14510 | 4572 | 29.20004 | 76.332824 | 2020-07-10 04:34:24 | Haryana, India | ||
2222644 | 2222644 | 2020-07-08 | India | Haryana | 18690 | 282 | 14106 | 4302 | 29.20004 | 76.332824 | 2020-07-09 04:34:23 | Haryana, India | ||
887253 | 887253 | 2020-07-07 | India | Haryana | 17999 | 279 | 13645 | 4075 | 29.20004 | 76.332824 | 2020-07-08 05:33:48 | Haryana, India | ||
2684813 | 2684813 | 2020-07-06 | India | Haryana | 17504 | 276 | 13335 | 3893 | 29.20004 | 76.332824 | 2020-07-07 04:34:00 | Haryana, India | ||
415278 | 415278 | 2020-07-05 | India | Haryana | 17005 | 265 | 12944 | 3796 | 29.20004 | 76.332824 | 2020-07-06 04:33:57 | Haryana, India | ||
529840 | 529840 | 2020-07-04 | India | Haryana | 16548 | 260 | 12257 | 4031 | 29.20004 | 76.332824 | 2020-07-05 04:33:46 | Haryana, India | ||
2234501 | 2234501 | 2020-07-03 | India | Haryana | 16003 | 255 | 11691 | 4057 | 29.20004 | 76.332824 | 2020-07-04 04:33:51 | Haryana, India | ||
3045295 | 3045295 | 2020-07-02 | India | Haryana | 15509 | 251 | 11019 | 4239 | 29.20004 | 76.332824 | 2020-07-03 04:33:54 | Haryana, India | ||
302986 | 302986 | 2020-07-01 | India | Haryana | 14941 | 240 | 10499 | 4202 | 29.20004 | 76.332824 | 2020-07-02 04:33:46 | Haryana, India | ||
2974364 | 2974364 | 2020-06-30 | India | Haryana | 14548 | 236 | 9972 | 4340 | 29.20004 | 76.332824 | 2020-07-01 04:33:52 | Haryana, India | ||
2632841 | 2632841 | 2020-06-29 | India | Haryana | 14210 | 232 | 9502 | 4476 | 29.20004 | 76.332824 | 2020-06-30 04:33:48 | Haryana, India | ||
2306404 | 2306404 | 2020-06-28 | India | Haryana | 13829 | 223 | 8917 | 4689 | 29.20004 | 76.332824 | 2020-06-29 04:33:44 | Haryana, India | ||
2039739 | 2039739 | 2020-06-27 | India | Haryana | 13427 | 218 | 8472 | 4737 | 29.20004 | 76.332824 | 2020-06-28 04:34:04 | Haryana, India | ||
1136020 | 1136020 | 2020-06-26 | India | Haryana | 12884 | 211 | 8016 | 4657 | 29.20004 | 76.332824 | 2020-06-27 04:33:35 | Haryana, India | ||
2625007 | 2625007 | 2020-06-25 | India | Haryana | 12463 | 198 | 7380 | 4885 | 29.20004 | 76.332824 | 2020-06-26 04:33:43 | Haryana, India | ||
2700647 | 2700647 | 2020-06-24 | India | Haryana | 12010 | 188 | 6925 | 4897 | 29.20004 | 76.332824 | 2020-06-25 05:26:54 | Haryana, India | ||
1522332 | 1522332 | 2020-06-23 | India | Haryana | 11520 | 178 | 6498 | 4844 | 29.20004 | 76.332824 | 2020-06-24 04:33:28 | Haryana, India | ||
1510526 | 1510526 | 2020-06-22 | India | Haryana | 11025 | 169 | 5916 | 4940 | 29.20004 | 76.332824 | 2020-06-23 04:33:22 | Haryana, India | ||
3249265 | 3249265 | 2020-06-21 | India | Haryana | 10635 | 160 | 5557 | 4918 | 29.20004 | 76.332824 | 2020-06-22 04:33:20 | Haryana, India | ||
2437858 | 2437858 | 2020-06-20 | India | Haryana | 10223 | 149 | 5128 | 4946 | 29.20004 | 76.332824 | 2020-06-21 04:33:19 | Haryana, India | ||
1691436 | 1691436 | 2020-06-19 | India | Haryana | 9743 | 144 | 4889 | 4710 | 29.20004 | 76.332824 | 2020-06-20 04:33:19 | Haryana, India | ||
3682585 | 3682585 | 2020-06-18 | India | Haryana | 9218 | 134 | 4556 | 4528 | 29.20004 | 76.332824 | 2020-06-19 04:33:17 | Haryana, India | ||
1195788 | 1195788 | 2020-06-17 | India | Haryana | 8832 | 130 | 3952 | 4750 | 29.20004 | 76.332824 | 2020-06-18 04:33:18 | Haryana, India | ||
2386551 | 2386551 | 2020-06-16 | India | Haryana | 8272 | 118 | 3748 | 4406 | 29.20004 | 76.332824 | 2020-06-17 04:33:21 | Haryana, India | ||
287114 | 287114 | 2020-06-15 | India | Haryana | 7722 | 100 | 3565 | 4057 | 29.20004 | 76.332824 | 2020-06-16 04:33:09 | Haryana, India | ||
1837065 | 1837065 | 2020-06-14 | India | Haryana | 6749 | 78 | 2803 | 3868 | 29.20004 | 76.332824 | 2020-06-15 03:33:14 | Haryana, India | ||
3061117 | 3061117 | 2020-06-13 | India | Haryana | 6334 | 70 | 2475 | 3789 | 29.20004 | 76.332824 | 2020-06-14 03:33:15 | Haryana, India | ||
737437 | 737437 | 2020-06-12 | India | Haryana | 5968 | 64 | 2260 | 3644 | 29.20004 | 76.332824 | 2020-06-13 03:33:14 | Haryana, India | ||
1273407 | 1273407 | 2020-06-11 | India | Haryana | 5968 | 64 | 2260 | 3644 | 29.20004 | 76.332824 | 2020-06-12 05:09:52 | Haryana, India | ||
2863850 | 2863850 | 2020-06-10 | India | Haryana | 5209 | 45 | 2134 | 3030 | 29.20004 | 76.332824 | 2020-06-11 03:33:41 | Haryana, 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]);