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 = "Nagaland" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436073 | 3436073 | 2020-07-11 | India | Nagaland | 748 | 0 | 313 | 435 | 26.06702 | 94.470302 | 2020-07-12 04:34:30 | Nagaland, India | ||
3237571 | 3237571 | 2020-07-10 | India | Nagaland | 732 | 0 | 304 | 428 | 26.06702 | 94.470302 | 2020-07-11 04:34:26 | Nagaland, India | ||
1005556 | 1005556 | 2020-07-09 | India | Nagaland | 673 | 0 | 304 | 369 | 26.06702 | 94.470302 | 2020-07-10 04:34:24 | Nagaland, India | ||
2222772 | 2222772 | 2020-07-08 | India | Nagaland | 657 | 0 | 304 | 353 | 26.06702 | 94.470302 | 2020-07-09 04:34:23 | Nagaland, India | ||
887381 | 887381 | 2020-07-07 | India | Nagaland | 625 | 0 | 243 | 382 | 26.06702 | 94.470302 | 2020-07-08 05:33:48 | Nagaland, India | ||
2684941 | 2684941 | 2020-07-06 | India | Nagaland | 625 | 0 | 243 | 382 | 26.06702 | 94.470302 | 2020-07-07 04:34:00 | Nagaland, India | ||
415406 | 415406 | 2020-07-05 | India | Nagaland | 590 | 0 | 231 | 359 | 26.06702 | 94.470302 | 2020-07-06 04:33:57 | Nagaland, India | ||
529968 | 529968 | 2020-07-04 | India | Nagaland | 563 | 0 | 228 | 335 | 26.06702 | 94.470302 | 2020-07-05 04:33:46 | Nagaland, India | ||
2234629 | 2234629 | 2020-07-03 | India | Nagaland | 539 | 0 | 228 | 311 | 26.06702 | 94.470302 | 2020-07-04 04:33:51 | Nagaland, India | ||
3045423 | 3045423 | 2020-07-02 | India | Nagaland | 501 | 0 | 182 | 319 | 26.06702 | 94.470302 | 2020-07-03 04:33:54 | Nagaland, India | ||
303114 | 303114 | 2020-07-01 | India | Nagaland | 459 | 0 | 168 | 291 | 26.06702 | 94.470302 | 2020-07-02 04:33:46 | Nagaland, India | ||
2974492 | 2974492 | 2020-06-30 | India | Nagaland | 459 | 0 | 168 | 291 | 26.06702 | 94.470302 | 2020-07-01 04:33:52 | Nagaland, India | ||
2632969 | 2632969 | 2020-06-29 | India | Nagaland | 434 | 0 | 168 | 266 | 26.06702 | 94.470302 | 2020-06-30 04:33:48 | Nagaland, India | ||
2306532 | 2306532 | 2020-06-28 | India | Nagaland | 415 | 0 | 164 | 251 | 26.06702 | 94.470302 | 2020-06-29 04:33:44 | Nagaland, India | ||
2039867 | 2039867 | 2020-06-27 | India | Nagaland | 387 | 0 | 164 | 223 | 26.06702 | 94.470302 | 2020-06-28 04:34:04 | Nagaland, India | ||
1136148 | 1136148 | 2020-06-26 | India | Nagaland | 371 | 0 | 162 | 209 | 26.06702 | 94.470302 | 2020-06-27 04:33:35 | Nagaland, India | ||
2625135 | 2625135 | 2020-06-25 | India | Nagaland | 355 | 0 | 160 | 195 | 26.06702 | 94.470302 | 2020-06-26 04:33:43 | Nagaland, India | ||
2700775 | 2700775 | 2020-06-24 | India | Nagaland | 347 | 0 | 148 | 199 | 26.06702 | 94.470302 | 2020-06-25 05:26:54 | Nagaland, India | ||
1522460 | 1522460 | 2020-06-23 | India | Nagaland | 330 | 0 | 141 | 189 | 26.06702 | 94.470302 | 2020-06-24 04:33:28 | Nagaland, India | ||
1510654 | 1510654 | 2020-06-22 | India | Nagaland | 280 | 0 | 141 | 139 | 26.06702 | 94.470302 | 2020-06-23 04:33:22 | Nagaland, India | ||
3249393 | 3249393 | 2020-06-21 | India | Nagaland | 211 | 0 | 141 | 70 | 26.06702 | 94.470302 | 2020-06-22 04:33:20 | Nagaland, India | ||
2437986 | 2437986 | 2020-06-20 | India | Nagaland | 201 | 0 | 138 | 63 | 26.06702 | 94.470302 | 2020-06-21 04:33:19 | Nagaland, India | ||
1691564 | 1691564 | 2020-06-19 | India | Nagaland | 198 | 0 | 125 | 73 | 26.06702 | 94.470302 | 2020-06-20 04:33:19 | Nagaland, India | ||
3682713 | 3682713 | 2020-06-18 | India | Nagaland | 193 | 0 | 103 | 90 | 26.06702 | 94.470302 | 2020-06-19 04:33:17 | Nagaland, India | ||
1195916 | 1195916 | 2020-06-17 | India | Nagaland | 193 | 0 | 103 | 90 | 26.06702 | 94.470302 | 2020-06-18 04:33:18 | Nagaland, India | ||
2386679 | 2386679 | 2020-06-16 | India | Nagaland | 179 | 0 | 92 | 87 | 26.06702 | 94.470302 | 2020-06-17 04:33:21 | Nagaland, India | ||
287242 | 287242 | 2020-06-15 | India | Nagaland | 177 | 0 | 92 | 85 | 26.06702 | 94.470302 | 2020-06-16 04:33:09 | Nagaland, India | ||
1837193 | 1837193 | 2020-06-14 | India | Nagaland | 163 | 0 | 76 | 87 | 26.06702 | 94.470302 | 2020-06-15 03:33:14 | Nagaland, India | ||
3061245 | 3061245 | 2020-06-13 | India | Nagaland | 156 | 0 | 49 | 107 | 26.06702 | 94.470302 | 2020-06-14 03:33:15 | Nagaland, India | ||
737565 | 737565 | 2020-06-12 | India | Nagaland | 128 | 0 | 22 | 106 | 26.06702 | 94.470302 | 2020-06-13 03:33:14 | Nagaland, India | ||
1273535 | 1273535 | 2020-06-11 | India | Nagaland | 128 | 0 | 22 | 106 | 26.06702 | 94.470302 | 2020-06-12 05:09:52 | Nagaland, India | ||
2863978 | 2863978 | 2020-06-10 | India | Nagaland | 127 | 0 | 10 | 117 | 26.06702 | 94.470302 | 2020-06-11 03:33:41 | Nagaland, 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]);