johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where country_or_region = "India", deaths = 0 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62019 | 62019 | 2020-07-23 | India | Nagaland | 1174 | 0 | 530 | 644 | 26.06702 | 94.470302 | 2020-07-24 05:30:40 | Nagaland, India | ||
844824 | 844824 | 2020-07-22 | India | Nagaland | 1084 | 0 | 486 | 598 | 26.06702 | 94.470302 | 2020-07-23 05:15:04 | Nagaland, India | ||
1707563 | 1707563 | 2020-07-21 | India | Nagaland | 1030 | 0 | 485 | 545 | 26.06702 | 94.470302 | 2020-07-22 04:34:42 | Nagaland, India | ||
327054 | 327054 | 2020-07-20 | India | Nagaland | 1021 | 0 | 484 | 537 | 26.06702 | 94.470302 | 2020-07-21 04:38:46 | Nagaland, India | ||
121959 | 121959 | 2020-07-19 | India | Nagaland | 988 | 0 | 445 | 543 | 26.06702 | 94.470302 | 2020-07-20 05:34:40 | Nagaland, India | ||
3205348 | 3205348 | 2020-07-18 | India | Nagaland | 978 | 0 | 432 | 546 | 26.06702 | 94.470302 | 2020-07-19 04:34:58 | Nagaland, India | ||
2708649 | 2708649 | 2020-07-17 | India | Nagaland | 956 | 0 | 405 | 551 | 26.06702 | 94.470302 | 2020-07-18 04:34:45 | Nagaland, India | ||
367462 | 367462 | 2020-07-16 | India | Nagaland | 916 | 0 | 391 | 525 | 26.06702 | 94.470302 | 2020-07-17 04:34:50 | Nagaland, India | ||
2748130 | 2748130 | 2020-07-15 | India | Nagaland | 902 | 0 | 348 | 554 | 26.06702 | 94.470302 | 2020-07-16 04:44:59 | Nagaland, India | ||
2158774 | 2158774 | 2020-07-14 | India | Nagaland | 896 | 0 | 346 | 550 | 26.06702 | 94.470302 | 2020-07-15 04:34:39 | Nagaland, India | ||
3491415 | 3491415 | 2020-07-13 | India | Nagaland | 845 | 0 | 340 | 505 | 26.06702 | 94.470302 | 2020-07-14 04:34:46 | Nagaland, India | ||
3737678 | 3737678 | 2020-07-12 | India | Nagaland | 774 | 0 | 327 | 447 | 26.06702 | 94.470302 | 2020-07-13 04:43:04 | Nagaland, India | ||
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]);