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 = "Maharashtra" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436040 | 3436040 | 2020-07-11 | India | Maharashtra | 246600 | 10116 | 136985 | 99499 | 19.449759 | 76.108221 | 2020-07-12 04:34:30 | Maharashtra, India | ||
3237538 | 3237538 | 2020-07-10 | India | Maharashtra | 238461 | 9893 | 132625 | 95943 | 19.449759 | 76.108221 | 2020-07-11 04:34:26 | Maharashtra, India | ||
1005523 | 1005523 | 2020-07-09 | India | Maharashtra | 230599 | 9667 | 127259 | 93673 | 19.449759 | 76.108221 | 2020-07-10 04:34:24 | Maharashtra, India | ||
2222739 | 2222739 | 2020-07-08 | India | Maharashtra | 223724 | 9448 | 123192 | 91084 | 19.449759 | 76.108221 | 2020-07-09 04:34:23 | Maharashtra, India | ||
887348 | 887348 | 2020-07-07 | India | Maharashtra | 217121 | 9250 | 118558 | 89313 | 19.449759 | 76.108221 | 2020-07-08 05:33:48 | Maharashtra, India | ||
2684908 | 2684908 | 2020-07-06 | India | Maharashtra | 211987 | 9026 | 115262 | 87699 | 19.449759 | 76.108221 | 2020-07-07 04:34:00 | Maharashtra, India | ||
415373 | 415373 | 2020-07-05 | India | Maharashtra | 206619 | 8822 | 111740 | 86057 | 19.449759 | 76.108221 | 2020-07-06 04:33:57 | Maharashtra, India | ||
529935 | 529935 | 2020-07-04 | India | Maharashtra | 200064 | 8671 | 108082 | 83311 | 19.449759 | 76.108221 | 2020-07-05 04:33:46 | Maharashtra, India | ||
2234596 | 2234596 | 2020-07-03 | India | Maharashtra | 192990 | 8376 | 104687 | 79927 | 19.449759 | 76.108221 | 2020-07-04 04:33:51 | Maharashtra, India | ||
3045390 | 3045390 | 2020-07-02 | India | Maharashtra | 186626 | 8178 | 101172 | 77276 | 19.449759 | 76.108221 | 2020-07-03 04:33:54 | Maharashtra, India | ||
303081 | 303081 | 2020-07-01 | India | Maharashtra | 180298 | 8053 | 93154 | 79091 | 19.449759 | 76.108221 | 2020-07-02 04:33:46 | Maharashtra, India | ||
2974459 | 2974459 | 2020-06-30 | India | Maharashtra | 174761 | 7855 | 90911 | 75995 | 19.449759 | 76.108221 | 2020-07-01 04:33:52 | Maharashtra, India | ||
2632936 | 2632936 | 2020-06-29 | India | Maharashtra | 169883 | 7610 | 88960 | 73313 | 19.449759 | 76.108221 | 2020-06-30 04:33:48 | Maharashtra, India | ||
2306499 | 2306499 | 2020-06-28 | India | Maharashtra | 164626 | 7429 | 86575 | 70622 | 19.449759 | 76.108221 | 2020-06-29 04:33:44 | Maharashtra, India | ||
2039834 | 2039834 | 2020-06-27 | India | Maharashtra | 159133 | 7273 | 84245 | 67615 | 19.449759 | 76.108221 | 2020-06-28 04:34:04 | Maharashtra, India | ||
1136115 | 1136115 | 2020-06-26 | India | Maharashtra | 152765 | 7106 | 79815 | 65844 | 19.449759 | 76.108221 | 2020-06-27 04:33:35 | Maharashtra, India | ||
2625102 | 2625102 | 2020-06-25 | India | Maharashtra | 147741 | 6931 | 77453 | 63357 | 19.449759 | 76.108221 | 2020-06-26 04:33:43 | Maharashtra, India | ||
2700742 | 2700742 | 2020-06-24 | India | Maharashtra | 142900 | 6739 | 73792 | 62369 | 19.449759 | 76.108221 | 2020-06-25 05:26:54 | Maharashtra, India | ||
1522427 | 1522427 | 2020-06-23 | India | Maharashtra | 139010 | 6531 | 69631 | 62848 | 19.449759 | 76.108221 | 2020-06-24 04:33:28 | Maharashtra, India | ||
1510621 | 1510621 | 2020-06-22 | India | Maharashtra | 135796 | 6283 | 67706 | 61807 | 19.449759 | 76.108221 | 2020-06-23 04:33:22 | Maharashtra, India | ||
3249360 | 3249360 | 2020-06-21 | India | Maharashtra | 132075 | 6170 | 65744 | 60161 | 19.449759 | 76.108221 | 2020-06-22 04:33:20 | Maharashtra, India | ||
2437953 | 2437953 | 2020-06-20 | India | Maharashtra | 128205 | 5984 | 64153 | 58068 | 19.449759 | 76.108221 | 2020-06-21 04:33:19 | Maharashtra, India | ||
1691531 | 1691531 | 2020-06-19 | India | Maharashtra | 124331 | 5893 | 62773 | 55665 | 19.449759 | 76.108221 | 2020-06-20 04:33:19 | Maharashtra, India | ||
3682680 | 3682680 | 2020-06-18 | India | Maharashtra | 120504 | 5751 | 60838 | 53915 | 19.449759 | 76.108221 | 2020-06-19 04:33:17 | Maharashtra, India | ||
1195883 | 1195883 | 2020-06-17 | India | Maharashtra | 116752 | 5651 | 59166 | 51935 | 19.449759 | 76.108221 | 2020-06-18 04:33:18 | Maharashtra, India | ||
2386646 | 2386646 | 2020-06-16 | India | Maharashtra | 113445 | 5537 | 57851 | 50057 | 19.449759 | 76.108221 | 2020-06-17 04:33:21 | Maharashtra, India | ||
287209 | 287209 | 2020-06-15 | India | Maharashtra | 110744 | 4128 | 56049 | 50567 | 19.449759 | 76.108221 | 2020-06-16 04:33:09 | Maharashtra, India | ||
1837160 | 1837160 | 2020-06-14 | India | Maharashtra | 104568 | 3830 | 49346 | 51392 | 19.449759 | 76.108221 | 2020-06-15 03:33:14 | Maharashtra, India | ||
3061212 | 3061212 | 2020-06-13 | India | Maharashtra | 101141 | 3717 | 47796 | 49628 | 19.449759 | 76.108221 | 2020-06-14 03:33:15 | Maharashtra, India | ||
737532 | 737532 | 2020-06-12 | India | Maharashtra | 97648 | 3590 | 46078 | 47980 | 19.449759 | 76.108221 | 2020-06-13 03:33:14 | Maharashtra, India | ||
1273502 | 1273502 | 2020-06-11 | India | Maharashtra | 97648 | 3590 | 46078 | 47980 | 19.449759 | 76.108221 | 2020-06-12 05:09:52 | Maharashtra, India | ||
2863945 | 2863945 | 2020-06-10 | India | Maharashtra | 90787 | 3289 | 42638 | 44860 | 19.449759 | 76.108221 | 2020-06-11 03:33:41 | Maharashtra, 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]);