johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "West Bengal" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
286 | 286 | 2021-12-02 | India | West Bengal | 1617408 | 19510 | 0 | 23.814082 | 87.979803 | 2021-12-03 04:23:05 | West Bengal, India | |||
4302 | 4302 | 2021-10-28 | India | West Bengal | 1590032 | 19105 | 0 | 23.814082 | 87.979803 | 2021-10-29 04:22:03 | West Bengal, India | |||
8304 | 8304 | 2020-10-25 | India | West Bengal | 349701 | 6487 | 306197 | 37017 | 23.814082 | 87.979803 | 2020-10-26 04:25:02 | West Bengal, India | ||
12312 | 12312 | 2021-01-26 | India | West Bengal | 568650 | 10131 | 552491 | 6028 | 23.814082 | 87.979803 | 2021-01-27 05:23:41 | West Bengal, India | ||
16327 | 16327 | 2021-09-18 | India | West Bengal | 1561014 | 18641 | 0 | 23.814082 | 87.979803 | 2021-09-19 04:21:34 | West Bengal, India | |||
20342 | 20342 | 2021-05-28 | India | West Bengal | 1343442 | 15120 | 1218516 | 109806 | 23.814082 | 87.979803 | 2021-05-29 04:20:41 | West Bengal, India | ||
24357 | 24357 | 2022-03-20 | India | West Bengal | 2016815 | 21194 | 0 | 23.814082 | 87.979803 | 2022-03-21 04:20:50 | West Bengal, India | |||
28372 | 28372 | 2021-11-11 | India | West Bengal | 1601586 | 19280 | 0 | 23.814082 | 87.979803 | 2021-11-12 04:22:01 | West Bengal, India | |||
32388 | 32388 | 2021-08-25 | India | West Bengal | 1544817 | 18393 | 0 | 23.814082 | 87.979803 | 2021-08-26 04:21:28 | West Bengal, India | |||
36402 | 36402 | 2021-04-12 | India | West Bengal | 619407 | 10414 | 582462 | 26531 | 23.814082 | 87.979803 | 2021-04-13 04:20:37 | West Bengal, India | ||
43664 | 43664 | 2021-11-02 | India | West Bengal | 1594495 | 19160 | 0 | 23.814082 | 87.979803 | 2021-11-03 06:22:09 | West Bengal, India | |||
50763 | 50763 | 2021-05-29 | India | West Bengal | 1354956 | 15268 | 1237290 | 102398 | 23.814082 | 87.979803 | 2021-05-30 04:20:55 | West Bengal, India | ||
54777 | 54777 | 2021-03-07 | India | West Bengal | 576623 | 10278 | 563182 | 3163 | 23.814082 | 87.979803 | 2021-03-08 05:24:48 | West Bengal, India | ||
62213 | 62213 | 2020-07-23 | India | West Bengal | 51757 | 1255 | 31656 | 18846 | 23.814082 | 87.979803 | 2020-07-24 05:30:40 | West Bengal, India | ||
63018 | 63018 | 2022-11-12 | India | West Bengal | 2118321 | 21531 | 0 | 23.814082 | 87.979803 | 2022-11-13 04:21:14 | West Bengal, India | |||
67033 | 67033 | 2021-09-01 | India | West Bengal | 1549283 | 18459 | 0 | 23.814082 | 87.979803 | 2021-09-02 04:21:15 | West Bengal, India | |||
71047 | 71047 | 2022-02-07 | India | West Bengal | 2006513 | 20852 | 0 | 23.814082 | 87.979803 | 2022-02-08 04:21:15 | West Bengal, India | |||
75061 | 75061 | 2020-12-03 | India | West Bengal | 493316 | 8576 | 460634 | 24106 | 23.814082 | 87.979803 | 2020-12-04 05:27:27 | West Bengal, India | ||
79060 | 79060 | 2020-10-14 | India | West Bengal | 305697 | 5808 | 268384 | 31505 | 23.814082 | 87.979803 | 2020-10-15 04:24:28 | West Bengal, India | ||
83067 | 83067 | 2021-05-25 | India | West Bengal | 1301978 | 14674 | 1160928 | 126376 | 23.814082 | 87.979803 | 2021-05-26 04:20:35 | West Bengal, India | ||
87081 | 87081 | 2021-11-09 | India | West Bengal | 1599879 | 19252 | 0 | 23.814082 | 87.979803 | 2021-11-10 04:21:38 | West Bengal, India | |||
91098 | 91098 | 2022-07-23 | India | West Bengal | 2083572 | 21314 | 0 | 23.814082 | 87.979803 | 2022-07-24 04:20:47 | West Bengal, India | |||
98575 | 98575 | 2020-08-04 | India | West Bengal | 80984 | 1785 | 56884 | 22315 | 23.814082 | 87.979803 | 2020-08-05 04:34:43 | West Bengal, India | ||
99282 | 99282 | 2022-01-14 | India | West Bengal | 1863697 | 20013 | 0 | 23.814082 | 87.979803 | 2022-01-15 04:21:07 | West Bengal, India | |||
103298 | 103298 | 2021-08-15 | India | West Bengal | 1538563 | 18303 | 0 | 23.814082 | 87.979803 | 2021-08-16 04:21:31 | West Bengal, India | |||
107423 | 107423 | 2021-06-19 | India | West Bengal | 1479523 | 17295 | 1439215 | 23013 | 23.814082 | 87.979803 | 2021-06-20 04:21:48 | West Bengal, India | ||
114708 | 114708 | 2022-09-06 | India | West Bengal | 2108188 | 21477 | 0 | 23.814082 | 87.979803 | 2022-09-07 04:20:59 | West Bengal, India | |||
122166 | 122166 | 2020-07-19 | India | West Bengal | 42487 | 1112 | 24883 | 16492 | 23.814082 | 87.979803 | 2020-07-20 05:34:40 | West Bengal, India | ||
122676 | 122676 | 2020-11-18 | India | West Bengal | 441885 | 7820 | 407769 | 26296 | 23.814082 | 87.979803 | 2020-11-19 05:25:23 | West Bengal, India | ||
126689 | 126689 | 2022-01-09 | India | West Bengal | 1755046 | 19901 | 0 | 23.814082 | 87.979803 | 2022-01-10 04:22:07 | West Bengal, India | |||
130706 | 130706 | 2022-10-04 | India | West Bengal | 2115134 | 21510 | 0 | 23.814082 | 87.979803 | 2022-10-05 04:23:06 | West Bengal, India | |||
137927 | 137927 | 2021-12-04 | India | West Bengal | 1618016 | 19523 | 0 | 23.814082 | 87.979803 | 2021-12-05 04:22:25 | West Bengal, India | |||
141944 | 141944 | 2022-07-09 | India | West Bengal | 2048749 | 21239 | 0 | 23.814082 | 87.979803 | 2022-07-10 04:20:54 | West Bengal, India | |||
145944 | 145944 | 2020-08-15 | India | West Bengal | 113432 | 2377 | 83836 | 27219 | 23.814082 | 87.979803 | 2020-08-16 04:27:42 | West Bengal, India | ||
149940 | 149940 | 2021-11-29 | India | West Bengal | 1615378 | 19473 | 0 | 23.814082 | 87.979803 | 2021-11-30 04:22:53 | West Bengal, India | |||
153955 | 153955 | 2021-01-08 | India | West Bengal | 558173 | 9881 | 539816 | 8476 | 23.814082 | 87.979803 | 2021-01-09 05:22:18 | West Bengal, India | ||
157969 | 157969 | 2022-03-29 | India | West Bengal | 2017278 | 21197 | 0 | 23.814082 | 87.979803 | 2022-03-30 04:20:45 | West Bengal, India | |||
161984 | 161984 | 2021-11-19 | India | West Bengal | 1608393 | 19364 | 0 | 23.814082 | 87.979803 | 2021-11-20 04:22:17 | West Bengal, India | |||
166001 | 166001 | 2022-06-21 | India | West Bengal | 2022547 | 21210 | 0 | 23.814082 | 87.979803 | 2022-06-22 04:20:54 | West Bengal, India | |||
170016 | 170016 | 2021-04-16 | India | West Bengal | 643795 | 10506 | 592242 | 41047 | 23.814082 | 87.979803 | 2021-04-17 04:20:40 | West Bengal, India | ||
177484 | 177484 | 2020-07-27 | India | West Bengal | 60830 | 1411 | 39917 | 19502 | 23.814082 | 87.979803 | 2020-07-28 04:58:43 | West Bengal, India | ||
177998 | 177998 | 2021-09-02 | India | West Bengal | 1549978 | 18472 | 0 | 23.814082 | 87.979803 | 2021-09-03 04:21:20 | West Bengal, India | |||
182012 | 182012 | 2021-02-21 | India | West Bengal | 573762 | 10249 | 559988 | 3525 | 23.814082 | 87.979803 | 2021-02-22 05:24:21 | West Bengal, India | ||
186027 | 186027 | 2022-02-13 | India | West Bengal | 2010901 | 21017 | 0 | 23.814082 | 87.979803 | 2022-02-14 04:20:51 | West Bengal, India | |||
190041 | 190041 | 2021-01-11 | India | West Bengal | 561321 | 9957 | 543826 | 7538 | 23.814082 | 87.979803 | 2021-01-12 05:22:15 | West Bengal, India | ||
194039 | 194039 | 2020-08-31 | India | West Bengal | 162778 | 3228 | 134270 | 25280 | 23.814082 | 87.979803 | 2020-09-01 04:28:31 | West Bengal, India | ||
198215 | 198215 | 2022-10-19 | India | West Bengal | 2117304 | 21525 | 0 | 23.814082 | 87.979803 | 2022-10-20 04:22:59 | West Bengal, India | |||
202228 | 202228 | 2020-12-25 | India | West Bengal | 544755 | 9536 | 520470 | 14749 | 23.814082 | 87.979803 | 2020-12-26 05:22:28 | West Bengal, India | ||
206226 | 206226 | 2020-08-19 | India | West Bengal | 125922 | 2581 | 95663 | 27678 | 23.814082 | 87.979803 | 2020-08-20 04:27:43 | West Bengal, India | ||
210212 | 210212 | 2020-10-29 | India | West Bengal | 365692 | 6725 | 321873 | 37094 | 23.814082 | 87.979803 | 2020-10-30 04:24:49 | West Bengal, India | ||
217936 | 217936 | 2022-12-26 | India | West Bengal | 2118589 | 21532 | 0 | 23.814082 | 87.979803 | 2022-12-27 04:21:07 | West Bengal, India | |||
221952 | 221952 | 2022-05-09 | India | West Bengal | 2018600 | 21203 | 0 | 23.814082 | 87.979803 | 2022-05-10 04:20:50 | West Bengal, India | |||
229183 | 229183 | 2022-05-31 | India | West Bengal | 2019405 | 21204 | 0 | 23.814082 | 87.979803 | 2022-06-01 04:20:55 | West Bengal, India | |||
233199 | 233199 | 2022-02-11 | India | West Bengal | 2009717 | 20965 | 0 | 23.814082 | 87.979803 | 2022-02-12 04:21:06 | West Bengal, India | |||
237213 | 237213 | 2021-01-18 | India | West Bengal | 565661 | 10063 | 548705 | 6893 | 23.814082 | 87.979803 | 2021-01-19 05:22:15 | West Bengal, India | ||
241227 | 241227 | 2021-04-02 | India | West Bengal | 589922 | 10335 | 571895 | 7692 | 23.814082 | 87.979803 | 2021-04-03 04:20:44 | West Bengal, India | ||
245241 | 245241 | 2021-08-17 | India | West Bengal | 1539612 | 18318 | 0 | 23.814082 | 87.979803 | 2021-08-18 04:21:35 | West Bengal, India | |||
249255 | 249255 | 2021-09-04 | India | West Bengal | 1551364 | 18491 | 0 | 23.814082 | 87.979803 | 2021-09-05 04:21:33 | West Bengal, India | |||
253270 | 253270 | 2022-09-08 | India | West Bengal | 2108623 | 21480 | 0 | 23.814082 | 87.979803 | 2022-09-09 04:21:11 | West Bengal, India | |||
257286 | 257286 | 2022-12-10 | India | West Bengal | 2118520 | 21531 | 0 | 23.814082 | 87.979803 | 2022-12-11 04:20:50 | West Bengal, India | |||
261489 | 261489 | 2022-03-15 | India | West Bengal | 2016516 | 21189 | 0 | 23.814082 | 87.979803 | 2022-03-16 04:20:50 | West Bengal, India | |||
272127 | 272127 | 2020-11-10 | India | West Bengal | 413112 | 7403 | 372265 | 33444 | 23.814082 | 87.979803 | 2020-11-11 05:25:30 | West Bengal, India | ||
276139 | 276139 | 2021-11-03 | India | West Bengal | 1595414 | 19174 | 0 | 23.814082 | 87.979803 | 2021-11-04 04:22:20 | West Bengal, India | |||
280155 | 280155 | 2021-02-24 | India | West Bengal | 574301 | 10256 | 560668 | 3377 | 23.814082 | 87.979803 | 2021-02-25 05:24:57 | West Bengal, India | ||
287447 | 287447 | 2020-06-15 | India | West Bengal | 11494 | 485 | 5494 | 5515 | 23.814082 | 87.979803 | 2020-06-16 04:33:09 | West Bengal, India | ||
287952 | 287952 | 2021-10-31 | India | West Bengal | 1592908 | 19141 | 0 | 23.814082 | 87.979803 | 2021-11-01 04:22:01 | West Bengal, India | |||
291969 | 291969 | 2022-11-15 | India | West Bengal | 2118359 | 21531 | 0 | 23.814082 | 87.979803 | 2022-11-16 04:21:09 | West Bengal, India | |||
295984 | 295984 | 2021-07-15 | India | West Bengal | 1515599 | 17970 | 1483992 | 13637 | 23.814082 | 87.979803 | 2021-07-16 04:21:22 | West Bengal, India | ||
303319 | 303319 | 2020-07-01 | India | West Bengal | 19170 | 683 | 12528 | 5959 | 23.814082 | 87.979803 | 2020-07-02 04:33:46 | West Bengal, India | ||
303825 | 303825 | 2022-04-16 | India | West Bengal | 2017778 | 21200 | 0 | 23.814082 | 87.979803 | 2022-04-17 04:20:59 | West Bengal, India | |||
307841 | 307841 | 2022-12-13 | India | West Bengal | 2118529 | 21531 | 0 | 23.814082 | 87.979803 | 2022-12-14 04:21:04 | West Bengal, India | |||
311857 | 311857 | 2022-11-13 | India | West Bengal | 2118339 | 21531 | 0 | 23.814082 | 87.979803 | 2022-11-14 04:21:09 | West Bengal, India | |||
315873 | 315873 | 2022-02-12 | India | West Bengal | 2010389 | 20990 | 0 | 23.814082 | 87.979803 | 2022-02-13 04:21:00 | West Bengal, India | |||
319889 | 319889 | 2022-10-30 | India | West Bengal | 2117999 | 21527 | 0 | 23.814082 | 87.979803 | 2022-10-31 04:21:36 | West Bengal, India | |||
327261 | 327261 | 2020-07-20 | India | West Bengal | 44769 | 1147 | 26418 | 17204 | 23.814082 | 87.979803 | 2020-07-21 04:38:46 | West Bengal, India | ||
327863 | 327863 | 2022-12-27 | India | West Bengal | 2118597 | 21532 | 0 | 23.814082 | 87.979803 | 2022-12-28 04:21:04 | West Bengal, India | |||
331878 | 331878 | 2021-08-04 | India | West Bengal | 1530850 | 18180 | 1501925 | 10745 | 23.814082 | 87.979803 | 2021-08-05 04:21:51 | West Bengal, India | ||
335893 | 335893 | 2022-03-18 | India | West Bengal | 2016737 | 21193 | 0 | 23.814082 | 87.979803 | 2022-03-19 04:20:47 | West Bengal, India | |||
340247 | 340247 | 2021-02-03 | India | West Bengal | 570581 | 10195 | 555190 | 5196 | 23.814082 | 87.979803 | 2021-02-04 05:22:26 | West Bengal, India | ||
344247 | 344247 | 2020-09-14 | India | West Bengal | 202708 | 3945 | 175139 | 23624 | 23.814082 | 87.979803 | 2020-09-15 03:22:50 | West Bengal, India | ||
348253 | 348253 | 2022-12-14 | India | West Bengal | 2118535 | 21531 | 0 | 23.814082 | 87.979803 | 2022-12-15 04:20:58 | West Bengal, India | |||
352268 | 352268 | 2021-03-11 | India | West Bengal | 577511 | 10286 | 564115 | 3110 | 23.814082 | 87.979803 | 2021-03-12 05:26:50 | West Bengal, India | ||
356283 | 356283 | 2022-03-11 | India | West Bengal | 2016298 | 21186 | 0 | 23.814082 | 87.979803 | 2022-03-12 04:20:50 | West Bengal, India | |||
360299 | 360299 | 2022-05-07 | India | West Bengal | 2018528 | 21203 | 0 | 23.814082 | 87.979803 | 2022-05-08 04:20:49 | West Bengal, India | |||
367667 | 367667 | 2020-07-16 | India | West Bengal | 36117 | 1023 | 21415 | 13679 | 23.814082 | 87.979803 | 2020-07-17 04:34:50 | West Bengal, India | ||
371640 | 371640 | 2020-08-08 | India | West Bengal | 92615 | 2005 | 65124 | 25486 | 23.814082 | 87.979803 | 2020-08-09 04:34:54 | West Bengal, India | ||
372153 | 372153 | 2022-09-13 | India | West Bengal | 2109677 | 21484 | 0 | 23.814082 | 87.979803 | 2022-09-14 04:20:44 | West Bengal, India | |||
376154 | 376154 | 2020-11-06 | India | West Bengal | 397466 | 7177 | 354732 | 35557 | 23.814082 | 87.979803 | 2020-11-07 05:24:52 | West Bengal, India | ||
380165 | 380165 | 2021-04-30 | India | West Bengal | 828366 | 11344 | 703398 | 113624 | 23.814082 | 87.979803 | 2021-05-01 04:20:47 | West Bengal, India | ||
384180 | 384180 | 2022-09-23 | India | West Bengal | 2112558 | 21494 | 0 | 23.814082 | 87.979803 | 2022-09-24 04:21:40 | West Bengal, India | |||
388195 | 388195 | 2021-04-04 | India | West Bengal | 593615 | 10344 | 573118 | 10153 | 23.814082 | 87.979803 | 2021-04-05 04:20:35 | West Bengal, India | ||
392207 | 392207 | 2020-11-27 | India | West Bengal | 473987 | 8270 | 441100 | 24617 | 23.814082 | 87.979803 | 2020-11-28 05:25:50 | West Bengal, India | ||
396221 | 396221 | 2022-10-07 | India | West Bengal | 2115445 | 21513 | 0 | 23.814082 | 87.979803 | 2022-10-08 04:22:56 | West Bengal, India | |||
400236 | 400236 | 2021-06-29 | India | West Bengal | 1498305 | 17679 | 1459510 | 21116 | 23.814082 | 87.979803 | 2021-06-30 04:21:41 | West Bengal, India | ||
404250 | 404250 | 2021-12-07 | India | West Bengal | 1620229 | 19562 | 0 | 23.814082 | 87.979803 | 2021-12-08 04:22:46 | West Bengal, India | |||
408266 | 408266 | 2021-07-28 | India | West Bengal | 1525773 | 18109 | 1496294 | 11370 | 23.814082 | 87.979803 | 2021-07-29 04:21:33 | West Bengal, India | ||
415610 | 415610 | 2020-07-05 | India | West Bengal | 22126 | 757 | 14711 | 6658 | 23.814082 | 87.979803 | 2020-07-06 04:33:57 | West Bengal, India | ||
419292 | 419292 | 2022-09-18 | India | West Bengal | 2111057 | 21489 | 0 | 23.814082 | 87.979803 | 2022-09-19 04:21:49 | West Bengal, India | |||
423307 | 423307 | 2021-10-10 | India | West Bengal | 1576337 | 18905 | 0 | 23.814082 | 87.979803 | 2021-10-11 04:21:31 | West Bengal, India | |||
427308 | 427308 | 2020-09-07 | India | West Bengal | 183865 | 3620 | 157029 | 23216 | 23.814082 | 87.979803 | 2020-09-08 04:28:25 | West Bengal, 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]);