johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
84 rows where country_or_region = "India", deaths = 280 and province_or_state = "Arunachal Pradesh" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3998573 | 3998573 | 2021-12-30 | India | Arunachal Pradesh | 55339 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-31 04:21:50 | Arunachal Pradesh, India | |||
1668380 | 1668380 | 2021-12-29 | India | Arunachal Pradesh | 55336 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-30 04:21:25 | Arunachal Pradesh, India | |||
1432489 | 1432489 | 2021-12-28 | India | Arunachal Pradesh | 55334 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-29 03:21:43 | Arunachal Pradesh, India | |||
730450 | 730450 | 2021-12-27 | India | Arunachal Pradesh | 55334 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-28 04:21:47 | Arunachal Pradesh, India | |||
2111622 | 2111622 | 2021-12-26 | India | Arunachal Pradesh | 55332 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-27 04:21:58 | Arunachal Pradesh, India | |||
3604994 | 3604994 | 2021-12-25 | India | Arunachal Pradesh | 55331 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-26 04:21:50 | Arunachal Pradesh, India | |||
2963312 | 2963312 | 2021-12-24 | India | Arunachal Pradesh | 55330 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-25 04:21:37 | Arunachal Pradesh, India | |||
3816344 | 3816344 | 2021-12-23 | India | Arunachal Pradesh | 55328 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-24 04:21:34 | Arunachal Pradesh, India | |||
798352 | 798352 | 2021-12-22 | India | Arunachal Pradesh | 55324 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-23 04:21:21 | Arunachal Pradesh, India | |||
3828392 | 3828392 | 2021-12-21 | India | Arunachal Pradesh | 55323 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-22 04:21:54 | Arunachal Pradesh, India | |||
1254695 | 1254695 | 2021-12-20 | India | Arunachal Pradesh | 55322 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-21 03:21:27 | Arunachal Pradesh, India | |||
2903638 | 2903638 | 2021-12-19 | India | Arunachal Pradesh | 55320 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-20 04:21:43 | Arunachal Pradesh, India | |||
1258711 | 1258711 | 2021-12-18 | India | Arunachal Pradesh | 55320 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-19 04:21:11 | Arunachal Pradesh, India | |||
2398739 | 2398739 | 2021-12-17 | India | Arunachal Pradesh | 55320 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-18 02:22:20 | Arunachal Pradesh, India | |||
1716277 | 1716277 | 2021-12-16 | India | Arunachal Pradesh | 55320 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-17 04:22:14 | Arunachal Pradesh, India | |||
3496111 | 3496111 | 2021-12-15 | India | Arunachal Pradesh | 55319 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-16 04:22:11 | Arunachal Pradesh, India | |||
2087896 | 2087896 | 2021-12-14 | India | Arunachal Pradesh | 55314 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-15 03:22:16 | Arunachal Pradesh, India | |||
782313 | 782313 | 2021-12-13 | India | Arunachal Pradesh | 55313 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-14 04:22:38 | Arunachal Pradesh, India | |||
1660348 | 1660348 | 2021-12-12 | India | Arunachal Pradesh | 55306 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-13 04:22:02 | Arunachal Pradesh, India | |||
1664364 | 1664364 | 2021-12-11 | India | Arunachal Pradesh | 55305 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-12 04:22:12 | Arunachal Pradesh, India | |||
3655516 | 3655516 | 2021-12-10 | India | Arunachal Pradesh | 55304 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-11 04:22:45 | Arunachal Pradesh, India | |||
1077847 | 1077847 | 2021-12-09 | India | Arunachal Pradesh | 55299 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-10 04:22:28 | Arunachal Pradesh, India | |||
550696 | 550696 | 2021-12-08 | India | Arunachal Pradesh | 55298 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-09 04:22:49 | Arunachal Pradesh, India | |||
404216 | 404216 | 2021-12-07 | India | Arunachal Pradesh | 55295 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-08 04:22:46 | Arunachal Pradesh, India | |||
1030298 | 1030298 | 2021-12-06 | India | Arunachal Pradesh | 55294 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-07 04:22:34 | Arunachal Pradesh, India | |||
1740461 | 1740461 | 2021-12-05 | India | Arunachal Pradesh | 55293 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-06 04:22:34 | Arunachal Pradesh, India | |||
137893 | 137893 | 2021-12-04 | India | Arunachal Pradesh | 55286 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-05 04:22:25 | Arunachal Pradesh, India | |||
2195546 | 2195546 | 2021-12-03 | India | Arunachal Pradesh | 55286 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-04 04:22:18 | Arunachal Pradesh, India | |||
252 | 252 | 2021-12-02 | India | Arunachal Pradesh | 55285 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-03 04:23:05 | Arunachal Pradesh, India | |||
1144851 | 1144851 | 2021-12-01 | India | Arunachal Pradesh | 55279 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-02 04:22:37 | Arunachal Pradesh, India | |||
3401363 | 3401363 | 2021-11-30 | India | Arunachal Pradesh | 55276 | 280 | 0 | 27.768456 | 96.384277 | 2021-12-01 04:22:29 | Arunachal Pradesh, India | |||
149906 | 149906 | 2021-11-29 | India | Arunachal Pradesh | 55273 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-30 04:22:53 | Arunachal Pradesh, India | |||
1231552 | 1231552 | 2021-11-28 | India | Arunachal Pradesh | 55269 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-29 04:22:30 | Arunachal Pradesh, India | |||
1358259 | 1358259 | 2021-11-27 | India | Arunachal Pradesh | 55269 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-28 04:22:43 | Arunachal Pradesh, India | |||
758250 | 758250 | 2021-11-26 | India | Arunachal Pradesh | 55260 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-27 04:22:45 | Arunachal Pradesh, India | |||
1802667 | 1802667 | 2021-11-25 | India | Arunachal Pradesh | 55258 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-26 04:22:33 | Arunachal Pradesh, India | |||
904101 | 904101 | 2021-11-24 | India | Arunachal Pradesh | 55257 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-25 04:22:33 | Arunachal Pradesh, India | |||
3069951 | 3069951 | 2021-11-23 | India | Arunachal Pradesh | 55255 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-24 04:22:14 | Arunachal Pradesh, India | |||
3749049 | 3749049 | 2021-11-22 | India | Arunachal Pradesh | 55251 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-23 04:22:39 | Arunachal Pradesh, India | |||
1014256 | 1014256 | 2021-11-21 | India | Arunachal Pradesh | 55247 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-22 04:22:20 | Arunachal Pradesh, India | |||
722420 | 722420 | 2021-11-20 | India | Arunachal Pradesh | 55246 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-21 04:22:13 | Arunachal Pradesh, India | |||
161950 | 161950 | 2021-11-19 | India | Arunachal Pradesh | 55243 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-20 04:22:17 | Arunachal Pradesh, India | |||
3288837 | 3288837 | 2021-11-18 | India | Arunachal Pradesh | 55242 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-19 04:21:40 | Arunachal Pradesh, India | |||
447293 | 447293 | 2021-11-17 | India | Arunachal Pradesh | 55232 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-18 04:21:33 | Arunachal Pradesh, India | |||
3342543 | 3342543 | 2021-11-16 | India | Arunachal Pradesh | 55230 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-17 04:21:48 | Arunachal Pradesh, India | |||
2287379 | 2287379 | 2021-11-15 | India | Arunachal Pradesh | 55222 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-16 04:21:10 | Arunachal Pradesh, India | |||
1322153 | 1322153 | 2021-11-14 | India | Arunachal Pradesh | 55220 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-15 04:21:36 | Arunachal Pradesh, India | |||
686279 | 686279 | 2021-11-13 | India | Arunachal Pradesh | 55216 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-14 04:21:31 | Arunachal Pradesh, India | |||
714388 | 714388 | 2021-11-12 | India | Arunachal Pradesh | 55212 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-13 04:21:38 | Arunachal Pradesh, India | |||
28338 | 28338 | 2021-11-11 | India | Arunachal Pradesh | 55208 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-12 04:22:01 | Arunachal Pradesh, India | |||
2844777 | 2844777 | 2021-11-10 | India | Arunachal Pradesh | 55202 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-11 04:21:45 | Arunachal Pradesh, India | |||
87047 | 87047 | 2021-11-09 | India | Arunachal Pradesh | 55197 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-10 04:21:38 | Arunachal Pradesh, India | |||
3639475 | 3639475 | 2021-11-08 | India | Arunachal Pradesh | 55190 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-09 04:21:36 | Arunachal Pradesh, India | |||
2000583 | 2000583 | 2021-11-07 | India | Arunachal Pradesh | 55180 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-08 04:21:43 | Arunachal Pradesh, India | |||
495574 | 495574 | 2021-11-06 | India | Arunachal Pradesh | 55180 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-07 04:21:53 | Arunachal Pradesh, India | |||
3121429 | 3121429 | 2021-11-05 | India | Arunachal Pradesh | 55176 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-06 04:21:51 | Arunachal Pradesh, India | |||
698327 | 698327 | 2021-11-04 | India | Arunachal Pradesh | 55174 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-05 04:21:54 | Arunachal Pradesh, India | |||
276105 | 276105 | 2021-11-03 | India | Arunachal Pradesh | 55174 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-04 04:22:20 | Arunachal Pradesh, India | |||
43630 | 43630 | 2021-11-02 | India | Arunachal Pradesh | 55167 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-03 06:22:09 | Arunachal Pradesh, India | |||
3511326 | 3511326 | 2021-11-01 | India | Arunachal Pradesh | 55161 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-02 04:22:03 | Arunachal Pradesh, India | |||
287918 | 287918 | 2021-10-31 | India | Arunachal Pradesh | 55155 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-01 04:22:01 | Arunachal Pradesh, India | |||
2720924 | 2720924 | 2021-10-30 | India | Arunachal Pradesh | 55154 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-31 04:22:08 | Arunachal Pradesh, India | |||
567026 | 567026 | 2021-10-29 | India | Arunachal Pradesh | 55143 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-30 04:22:03 | Arunachal Pradesh, India | |||
4268 | 4268 | 2021-10-28 | India | Arunachal Pradesh | 55134 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-29 04:22:03 | Arunachal Pradesh, India | |||
534658 | 534658 | 2021-10-27 | India | Arunachal Pradesh | 55120 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-28 04:22:08 | Arunachal Pradesh, India | |||
3492095 | 3492095 | 2021-10-26 | India | Arunachal Pradesh | 55114 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-27 04:22:32 | Arunachal Pradesh, India | |||
3793817 | 3793817 | 2021-10-25 | India | Arunachal Pradesh | 55105 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-26 04:22:09 | Arunachal Pradesh, India | |||
682263 | 682263 | 2021-10-24 | India | Arunachal Pradesh | 55089 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-25 04:22:31 | Arunachal Pradesh, India | |||
770271 | 770271 | 2021-10-23 | India | Arunachal Pradesh | 55089 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-24 04:21:22 | Arunachal Pradesh, India | |||
653918 | 653918 | 2021-10-22 | India | Arunachal Pradesh | 55075 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-23 04:21:32 | Arunachal Pradesh, India | |||
2123665 | 2123665 | 2021-10-21 | India | Arunachal Pradesh | 55065 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-22 04:21:14 | Arunachal Pradesh, India | |||
443277 | 443277 | 2021-10-20 | India | Arunachal Pradesh | 55043 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-21 04:21:18 | Arunachal Pradesh, India | |||
597596 | 597596 | 2021-10-19 | India | Arunachal Pradesh | 55031 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-20 04:21:00 | Arunachal Pradesh, India | |||
2043773 | 2043773 | 2021-10-18 | India | Arunachal Pradesh | 55014 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-19 04:20:54 | Arunachal Pradesh, India | |||
1909134 | 1909134 | 2021-10-17 | India | Arunachal Pradesh | 54987 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-18 04:21:10 | Arunachal Pradesh, India | |||
934723 | 934723 | 2021-10-16 | India | Arunachal Pradesh | 54980 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-17 04:21:29 | Arunachal Pradesh, India | |||
2943278 | 2943278 | 2021-10-15 | India | Arunachal Pradesh | 54964 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-16 04:21:15 | Arunachal Pradesh, India | |||
491558 | 491558 | 2021-10-14 | India | Arunachal Pradesh | 54958 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-15 04:21:26 | Arunachal Pradesh, India | |||
633846 | 633846 | 2021-10-13 | India | Arunachal Pradesh | 54954 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-14 04:21:29 | Arunachal Pradesh, India | |||
1491524 | 1491524 | 2021-10-12 | India | Arunachal Pradesh | 54942 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-13 04:20:51 | Arunachal Pradesh, India | |||
3007257 | 3007257 | 2021-10-11 | India | Arunachal Pradesh | 54924 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-12 04:21:09 | Arunachal Pradesh, India | |||
423273 | 423273 | 2021-10-10 | India | Arunachal Pradesh | 54900 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-11 04:21:31 | Arunachal Pradesh, India | |||
2876130 | 2876130 | 2021-10-09 | India | Arunachal Pradesh | 54881 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-10 04:21:38 | Arunachal Pradesh, India | |||
2959296 | 2959296 | 2021-10-08 | India | Arunachal Pradesh | 54865 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-09 04:21:34 | Arunachal Pradesh, 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]);