daily_reports (view)
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, active, last_update, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | India | West Bengal | 1617408 | 19510 | 0 | 23.814082 | 87.979803 | 2021-12-03 04:23:05 | West Bengal, India | |||
2021-10-28 | India | West Bengal | 1590032 | 19105 | 0 | 23.814082 | 87.979803 | 2021-10-29 04:22:03 | West Bengal, India | |||
2020-10-25 | India | West Bengal | 349701 | 6487 | 306197 | 37017 | 23.814082 | 87.979803 | 2020-10-26 04:25:02 | West Bengal, India | ||
2021-01-26 | India | West Bengal | 568650 | 10131 | 552491 | 6028 | 23.814082 | 87.979803 | 2021-01-27 05:23:41 | West Bengal, India | ||
2021-09-18 | India | West Bengal | 1561014 | 18641 | 0 | 23.814082 | 87.979803 | 2021-09-19 04:21:34 | West Bengal, India | |||
2021-05-28 | India | West Bengal | 1343442 | 15120 | 1218516 | 109806 | 23.814082 | 87.979803 | 2021-05-29 04:20:41 | West Bengal, India | ||
2022-03-20 | India | West Bengal | 2016815 | 21194 | 0 | 23.814082 | 87.979803 | 2022-03-21 04:20:50 | West Bengal, India | |||
2021-11-11 | India | West Bengal | 1601586 | 19280 | 0 | 23.814082 | 87.979803 | 2021-11-12 04:22:01 | West Bengal, India | |||
2021-08-25 | India | West Bengal | 1544817 | 18393 | 0 | 23.814082 | 87.979803 | 2021-08-26 04:21:28 | West Bengal, India | |||
2021-04-12 | India | West Bengal | 619407 | 10414 | 582462 | 26531 | 23.814082 | 87.979803 | 2021-04-13 04:20:37 | West Bengal, India | ||
2021-11-02 | India | West Bengal | 1594495 | 19160 | 0 | 23.814082 | 87.979803 | 2021-11-03 06:22:09 | West Bengal, India | |||
2021-05-29 | India | West Bengal | 1354956 | 15268 | 1237290 | 102398 | 23.814082 | 87.979803 | 2021-05-30 04:20:55 | West Bengal, India | ||
2021-03-07 | India | West Bengal | 576623 | 10278 | 563182 | 3163 | 23.814082 | 87.979803 | 2021-03-08 05:24:48 | West Bengal, India | ||
2020-07-23 | India | West Bengal | 51757 | 1255 | 31656 | 18846 | 23.814082 | 87.979803 | 2020-07-24 05:30:40 | West Bengal, India | ||
2022-11-12 | India | West Bengal | 2118321 | 21531 | 0 | 23.814082 | 87.979803 | 2022-11-13 04:21:14 | West Bengal, India | |||
2021-09-01 | India | West Bengal | 1549283 | 18459 | 0 | 23.814082 | 87.979803 | 2021-09-02 04:21:15 | West Bengal, India | |||
2022-02-07 | India | West Bengal | 2006513 | 20852 | 0 | 23.814082 | 87.979803 | 2022-02-08 04:21:15 | West Bengal, India | |||
2020-12-03 | India | West Bengal | 493316 | 8576 | 460634 | 24106 | 23.814082 | 87.979803 | 2020-12-04 05:27:27 | West Bengal, India | ||
2020-10-14 | India | West Bengal | 305697 | 5808 | 268384 | 31505 | 23.814082 | 87.979803 | 2020-10-15 04:24:28 | West Bengal, India | ||
2021-05-25 | India | West Bengal | 1301978 | 14674 | 1160928 | 126376 | 23.814082 | 87.979803 | 2021-05-26 04:20:35 | West Bengal, India | ||
2021-11-09 | India | West Bengal | 1599879 | 19252 | 0 | 23.814082 | 87.979803 | 2021-11-10 04:21:38 | West Bengal, India | |||
2022-07-23 | India | West Bengal | 2083572 | 21314 | 0 | 23.814082 | 87.979803 | 2022-07-24 04:20:47 | West Bengal, India | |||
2020-08-04 | India | West Bengal | 80984 | 1785 | 56884 | 22315 | 23.814082 | 87.979803 | 2020-08-05 04:34:43 | West Bengal, India | ||
2022-01-14 | India | West Bengal | 1863697 | 20013 | 0 | 23.814082 | 87.979803 | 2022-01-15 04:21:07 | West Bengal, India | |||
2021-08-15 | India | West Bengal | 1538563 | 18303 | 0 | 23.814082 | 87.979803 | 2021-08-16 04:21:31 | West Bengal, India | |||
2021-06-19 | India | West Bengal | 1479523 | 17295 | 1439215 | 23013 | 23.814082 | 87.979803 | 2021-06-20 04:21:48 | West Bengal, India | ||
2022-09-06 | India | West Bengal | 2108188 | 21477 | 0 | 23.814082 | 87.979803 | 2022-09-07 04:20:59 | West Bengal, India | |||
2020-07-19 | India | West Bengal | 42487 | 1112 | 24883 | 16492 | 23.814082 | 87.979803 | 2020-07-20 05:34:40 | West Bengal, India | ||
2020-11-18 | India | West Bengal | 441885 | 7820 | 407769 | 26296 | 23.814082 | 87.979803 | 2020-11-19 05:25:23 | West Bengal, India | ||
2022-01-09 | India | West Bengal | 1755046 | 19901 | 0 | 23.814082 | 87.979803 | 2022-01-10 04:22:07 | West Bengal, India | |||
2022-10-04 | India | West Bengal | 2115134 | 21510 | 0 | 23.814082 | 87.979803 | 2022-10-05 04:23:06 | West Bengal, India | |||
2021-12-04 | India | West Bengal | 1618016 | 19523 | 0 | 23.814082 | 87.979803 | 2021-12-05 04:22:25 | West Bengal, India | |||
2022-07-09 | India | West Bengal | 2048749 | 21239 | 0 | 23.814082 | 87.979803 | 2022-07-10 04:20:54 | West Bengal, India | |||
2020-08-15 | India | West Bengal | 113432 | 2377 | 83836 | 27219 | 23.814082 | 87.979803 | 2020-08-16 04:27:42 | West Bengal, India | ||
2021-11-29 | India | West Bengal | 1615378 | 19473 | 0 | 23.814082 | 87.979803 | 2021-11-30 04:22:53 | West Bengal, India | |||
2021-01-08 | India | West Bengal | 558173 | 9881 | 539816 | 8476 | 23.814082 | 87.979803 | 2021-01-09 05:22:18 | West Bengal, India | ||
2022-03-29 | India | West Bengal | 2017278 | 21197 | 0 | 23.814082 | 87.979803 | 2022-03-30 04:20:45 | West Bengal, India | |||
2021-11-19 | India | West Bengal | 1608393 | 19364 | 0 | 23.814082 | 87.979803 | 2021-11-20 04:22:17 | West Bengal, India | |||
2022-06-21 | India | West Bengal | 2022547 | 21210 | 0 | 23.814082 | 87.979803 | 2022-06-22 04:20:54 | West Bengal, India | |||
2021-04-16 | India | West Bengal | 643795 | 10506 | 592242 | 41047 | 23.814082 | 87.979803 | 2021-04-17 04:20:40 | West Bengal, India | ||
2020-07-27 | India | West Bengal | 60830 | 1411 | 39917 | 19502 | 23.814082 | 87.979803 | 2020-07-28 04:58:43 | West Bengal, India | ||
2021-09-02 | India | West Bengal | 1549978 | 18472 | 0 | 23.814082 | 87.979803 | 2021-09-03 04:21:20 | West Bengal, India | |||
2021-02-21 | India | West Bengal | 573762 | 10249 | 559988 | 3525 | 23.814082 | 87.979803 | 2021-02-22 05:24:21 | West Bengal, India | ||
2022-02-13 | India | West Bengal | 2010901 | 21017 | 0 | 23.814082 | 87.979803 | 2022-02-14 04:20:51 | West Bengal, India | |||
2021-01-11 | India | West Bengal | 561321 | 9957 | 543826 | 7538 | 23.814082 | 87.979803 | 2021-01-12 05:22:15 | West Bengal, India | ||
2020-08-31 | India | West Bengal | 162778 | 3228 | 134270 | 25280 | 23.814082 | 87.979803 | 2020-09-01 04:28:31 | West Bengal, India | ||
2022-10-19 | India | West Bengal | 2117304 | 21525 | 0 | 23.814082 | 87.979803 | 2022-10-20 04:22:59 | West Bengal, India | |||
2020-12-25 | India | West Bengal | 544755 | 9536 | 520470 | 14749 | 23.814082 | 87.979803 | 2020-12-26 05:22:28 | West Bengal, India | ||
2020-08-19 | India | West Bengal | 125922 | 2581 | 95663 | 27678 | 23.814082 | 87.979803 | 2020-08-20 04:27:43 | West Bengal, India | ||
2020-10-29 | India | West Bengal | 365692 | 6725 | 321873 | 37094 | 23.814082 | 87.979803 | 2020-10-30 04:24:49 | West Bengal, India | ||
2022-12-26 | India | West Bengal | 2118589 | 21532 | 0 | 23.814082 | 87.979803 | 2022-12-27 04:21:07 | West Bengal, India | |||
2022-05-09 | India | West Bengal | 2018600 | 21203 | 0 | 23.814082 | 87.979803 | 2022-05-10 04:20:50 | West Bengal, India | |||
2022-05-31 | India | West Bengal | 2019405 | 21204 | 0 | 23.814082 | 87.979803 | 2022-06-01 04:20:55 | West Bengal, India | |||
2022-02-11 | India | West Bengal | 2009717 | 20965 | 0 | 23.814082 | 87.979803 | 2022-02-12 04:21:06 | West Bengal, India | |||
2021-01-18 | India | West Bengal | 565661 | 10063 | 548705 | 6893 | 23.814082 | 87.979803 | 2021-01-19 05:22:15 | West Bengal, India | ||
2021-04-02 | India | West Bengal | 589922 | 10335 | 571895 | 7692 | 23.814082 | 87.979803 | 2021-04-03 04:20:44 | West Bengal, India | ||
2021-08-17 | India | West Bengal | 1539612 | 18318 | 0 | 23.814082 | 87.979803 | 2021-08-18 04:21:35 | West Bengal, India | |||
2021-09-04 | India | West Bengal | 1551364 | 18491 | 0 | 23.814082 | 87.979803 | 2021-09-05 04:21:33 | West Bengal, India | |||
2022-09-08 | India | West Bengal | 2108623 | 21480 | 0 | 23.814082 | 87.979803 | 2022-09-09 04:21:11 | West Bengal, India | |||
2022-12-10 | India | West Bengal | 2118520 | 21531 | 0 | 23.814082 | 87.979803 | 2022-12-11 04:20:50 | West Bengal, India | |||
2022-03-15 | India | West Bengal | 2016516 | 21189 | 0 | 23.814082 | 87.979803 | 2022-03-16 04:20:50 | West Bengal, India | |||
2020-11-10 | India | West Bengal | 413112 | 7403 | 372265 | 33444 | 23.814082 | 87.979803 | 2020-11-11 05:25:30 | West Bengal, India | ||
2021-11-03 | India | West Bengal | 1595414 | 19174 | 0 | 23.814082 | 87.979803 | 2021-11-04 04:22:20 | West Bengal, India | |||
2021-02-24 | India | West Bengal | 574301 | 10256 | 560668 | 3377 | 23.814082 | 87.979803 | 2021-02-25 05:24:57 | West Bengal, India | ||
2020-06-15 | India | West Bengal | 11494 | 485 | 5494 | 5515 | 23.814082 | 87.979803 | 2020-06-16 04:33:09 | West Bengal, India | ||
2021-10-31 | India | West Bengal | 1592908 | 19141 | 0 | 23.814082 | 87.979803 | 2021-11-01 04:22:01 | West Bengal, India | |||
2022-11-15 | India | West Bengal | 2118359 | 21531 | 0 | 23.814082 | 87.979803 | 2022-11-16 04:21:09 | West Bengal, India | |||
2021-07-15 | India | West Bengal | 1515599 | 17970 | 1483992 | 13637 | 23.814082 | 87.979803 | 2021-07-16 04:21:22 | West Bengal, India | ||
2020-07-01 | India | West Bengal | 19170 | 683 | 12528 | 5959 | 23.814082 | 87.979803 | 2020-07-02 04:33:46 | West Bengal, India | ||
2022-04-16 | India | West Bengal | 2017778 | 21200 | 0 | 23.814082 | 87.979803 | 2022-04-17 04:20:59 | West Bengal, India | |||
2022-12-13 | India | West Bengal | 2118529 | 21531 | 0 | 23.814082 | 87.979803 | 2022-12-14 04:21:04 | West Bengal, India | |||
2022-11-13 | India | West Bengal | 2118339 | 21531 | 0 | 23.814082 | 87.979803 | 2022-11-14 04:21:09 | West Bengal, India | |||
2022-02-12 | India | West Bengal | 2010389 | 20990 | 0 | 23.814082 | 87.979803 | 2022-02-13 04:21:00 | West Bengal, India | |||
2022-10-30 | India | West Bengal | 2117999 | 21527 | 0 | 23.814082 | 87.979803 | 2022-10-31 04:21:36 | West Bengal, India | |||
2020-07-20 | India | West Bengal | 44769 | 1147 | 26418 | 17204 | 23.814082 | 87.979803 | 2020-07-21 04:38:46 | West Bengal, India | ||
2022-12-27 | India | West Bengal | 2118597 | 21532 | 0 | 23.814082 | 87.979803 | 2022-12-28 04:21:04 | West Bengal, India | |||
2021-08-04 | India | West Bengal | 1530850 | 18180 | 1501925 | 10745 | 23.814082 | 87.979803 | 2021-08-05 04:21:51 | West Bengal, India | ||
2022-03-18 | India | West Bengal | 2016737 | 21193 | 0 | 23.814082 | 87.979803 | 2022-03-19 04:20:47 | West Bengal, India | |||
2021-02-03 | India | West Bengal | 570581 | 10195 | 555190 | 5196 | 23.814082 | 87.979803 | 2021-02-04 05:22:26 | West Bengal, India | ||
2020-09-14 | India | West Bengal | 202708 | 3945 | 175139 | 23624 | 23.814082 | 87.979803 | 2020-09-15 03:22:50 | West Bengal, India | ||
2022-12-14 | India | West Bengal | 2118535 | 21531 | 0 | 23.814082 | 87.979803 | 2022-12-15 04:20:58 | West Bengal, India | |||
2021-03-11 | India | West Bengal | 577511 | 10286 | 564115 | 3110 | 23.814082 | 87.979803 | 2021-03-12 05:26:50 | West Bengal, India | ||
2022-03-11 | India | West Bengal | 2016298 | 21186 | 0 | 23.814082 | 87.979803 | 2022-03-12 04:20:50 | West Bengal, India | |||
2022-05-07 | India | West Bengal | 2018528 | 21203 | 0 | 23.814082 | 87.979803 | 2022-05-08 04:20:49 | West Bengal, India | |||
2020-07-16 | India | West Bengal | 36117 | 1023 | 21415 | 13679 | 23.814082 | 87.979803 | 2020-07-17 04:34:50 | West Bengal, India | ||
2020-08-08 | India | West Bengal | 92615 | 2005 | 65124 | 25486 | 23.814082 | 87.979803 | 2020-08-09 04:34:54 | West Bengal, India | ||
2022-09-13 | India | West Bengal | 2109677 | 21484 | 0 | 23.814082 | 87.979803 | 2022-09-14 04:20:44 | West Bengal, India | |||
2020-11-06 | India | West Bengal | 397466 | 7177 | 354732 | 35557 | 23.814082 | 87.979803 | 2020-11-07 05:24:52 | West Bengal, India | ||
2021-04-30 | India | West Bengal | 828366 | 11344 | 703398 | 113624 | 23.814082 | 87.979803 | 2021-05-01 04:20:47 | West Bengal, India | ||
2022-09-23 | India | West Bengal | 2112558 | 21494 | 0 | 23.814082 | 87.979803 | 2022-09-24 04:21:40 | West Bengal, India | |||
2021-04-04 | India | West Bengal | 593615 | 10344 | 573118 | 10153 | 23.814082 | 87.979803 | 2021-04-05 04:20:35 | West Bengal, India | ||
2020-11-27 | India | West Bengal | 473987 | 8270 | 441100 | 24617 | 23.814082 | 87.979803 | 2020-11-28 05:25:50 | West Bengal, India | ||
2022-10-07 | India | West Bengal | 2115445 | 21513 | 0 | 23.814082 | 87.979803 | 2022-10-08 04:22:56 | West Bengal, India | |||
2021-06-29 | India | West Bengal | 1498305 | 17679 | 1459510 | 21116 | 23.814082 | 87.979803 | 2021-06-30 04:21:41 | West Bengal, India | ||
2021-12-07 | India | West Bengal | 1620229 | 19562 | 0 | 23.814082 | 87.979803 | 2021-12-08 04:22:46 | West Bengal, India | |||
2021-07-28 | India | West Bengal | 1525773 | 18109 | 1496294 | 11370 | 23.814082 | 87.979803 | 2021-07-29 04:21:33 | West Bengal, India | ||
2020-07-05 | India | West Bengal | 22126 | 757 | 14711 | 6658 | 23.814082 | 87.979803 | 2020-07-06 04:33:57 | West Bengal, India | ||
2022-09-18 | India | West Bengal | 2111057 | 21489 | 0 | 23.814082 | 87.979803 | 2022-09-19 04:21:49 | West Bengal, India | |||
2021-10-10 | India | West Bengal | 1576337 | 18905 | 0 | 23.814082 | 87.979803 | 2021-10-11 04:21:31 | West Bengal, India | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;