daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

933 rows where country_or_region = "India" and province_or_state = "Gujarat" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Gujarat · 933 ✖

country_or_region 1

  • India · 933 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-29 India Gujarat     1277564 11043 0   22.694884 71.590923 2022-12-30 04:21:04 Gujarat, India
2022-12-28 India Gujarat     1277557 11043 0   22.694884 71.590923 2022-12-29 04:21:01 Gujarat, India
2022-12-27 India Gujarat     1277551 11043 0   22.694884 71.590923 2022-12-28 04:21:04 Gujarat, India
2022-12-26 India Gujarat     1277548 11043 0   22.694884 71.590923 2022-12-27 04:21:07 Gujarat, India
2022-12-25 India Gujarat     1277541 11043 0   22.694884 71.590923 2022-12-26 04:21:06 Gujarat, India
2022-12-24 India Gujarat     1277538 11043 0   22.694884 71.590923 2022-12-25 04:21:04 Gujarat, India
2022-12-23 India Gujarat     1277529 11043 0   22.694884 71.590923 2022-12-24 04:21:02 Gujarat, India
2022-12-22 India Gujarat     1277526 11043 0   22.694884 71.590923 2022-12-23 04:21:04 Gujarat, India
2022-12-21 India Gujarat     1277520 11043 0   22.694884 71.590923 2022-12-22 04:20:56 Gujarat, India
2022-12-20 India Gujarat     1277515 11043 0   22.694884 71.590923 2022-12-21 04:21:03 Gujarat, India
2022-12-19 India Gujarat     1277513 11043 0   22.694884 71.590923 2022-12-20 04:21:04 Gujarat, India
2022-12-18 India Gujarat     1277512 11043 0   22.694884 71.590923 2022-12-19 04:21:03 Gujarat, India
2022-12-17 India Gujarat     1277511 11043 0   22.694884 71.590923 2022-12-18 04:21:03 Gujarat, India
2022-12-16 India Gujarat     1277508 11043 0   22.694884 71.590923 2022-12-17 04:21:04 Gujarat, India
2022-12-15 India Gujarat     1277504 11043 0   22.694884 71.590923 2022-12-16 04:21:01 Gujarat, India
2022-12-14 India Gujarat     1277502 11043 0   22.694884 71.590923 2022-12-15 04:20:58 Gujarat, India
2022-12-13 India Gujarat     1277499 11043 0   22.694884 71.590923 2022-12-14 04:21:04 Gujarat, India
2022-12-12 India Gujarat     1277497 11043 0   22.694884 71.590923 2022-12-13 04:21:01 Gujarat, India
2022-12-11 India Gujarat     1277491 11043 0   22.694884 71.590923 2022-12-12 04:21:01 Gujarat, India
2022-12-10 India Gujarat     1277491 11043 0   22.694884 71.590923 2022-12-11 04:20:50 Gujarat, India
2022-12-09 India Gujarat     1277489 11043 0   22.694884 71.590923 2022-12-10 04:21:02 Gujarat, India
2022-12-08 India Gujarat     1277486 11043 0   22.694884 71.590923 2022-12-09 04:21:05 Gujarat, India
2022-12-07 India Gujarat     1277481 11043 0   22.694884 71.590923 2022-12-08 04:21:07 Gujarat, India
2022-12-06 India Gujarat     1277476 11043 0   22.694884 71.590923 2022-12-07 04:20:58 Gujarat, India
2022-12-05 India Gujarat     1277467 11043 0   22.694884 71.590923 2022-12-06 04:21:03 Gujarat, India
2022-12-04 India Gujarat     1277464 11043 0   22.694884 71.590923 2022-12-05 04:20:58 Gujarat, India
2022-12-03 India Gujarat     1277462 11043 0   22.694884 71.590923 2022-12-04 04:20:56 Gujarat, India
2022-12-02 India Gujarat     1277459 11043 0   22.694884 71.590923 2022-12-03 04:21:02 Gujarat, India
2022-12-01 India Gujarat     1277456 11043 0   22.694884 71.590923 2022-12-02 04:21:07 Gujarat, India
2022-11-30 India Gujarat     1277446 11043 0   22.694884 71.590923 2022-12-01 04:21:03 Gujarat, India
2022-11-29 India Gujarat     1277437 11043 0   22.694884 71.590923 2022-11-30 04:21:07 Gujarat, India
2022-11-28 India Gujarat     1277431 11043 0   22.694884 71.590923 2022-11-29 04:21:05 Gujarat, India
2022-11-27 India Gujarat     1277426 11043 0   22.694884 71.590923 2022-11-28 04:21:02 Gujarat, India
2022-11-26 India Gujarat     1277422 11043 0   22.694884 71.590923 2022-11-27 04:21:05 Gujarat, India
2022-11-25 India Gujarat     1277417 11043 0   22.694884 71.590923 2022-11-26 04:21:11 Gujarat, India
2022-11-24 India Gujarat     1277408 11043 0   22.694884 71.590923 2022-11-25 04:21:06 Gujarat, India
2022-11-23 India Gujarat     1277401 11042 0   22.694884 71.590923 2022-11-24 04:21:09 Gujarat, India
2022-11-22 India Gujarat     1277393 11042 0   22.694884 71.590923 2022-11-23 04:21:06 Gujarat, India
2022-11-21 India Gujarat     1277379 11042 0   22.694884 71.590923 2022-11-22 04:20:47 Gujarat, India
2022-11-20 India Gujarat     1277364 11042 0   22.694884 71.590923 2022-11-21 04:21:05 Gujarat, India
2022-11-19 India Gujarat     1277353 11042 0   22.694884 71.590923 2022-11-20 04:21:08 Gujarat, India
2022-11-18 India Gujarat     1277335 11042 0   22.694884 71.590923 2022-11-19 04:21:14 Gujarat, India
2022-11-17 India Gujarat     1277323 11042 0   22.694884 71.590923 2022-11-18 04:21:15 Gujarat, India
2022-11-16 India Gujarat     1277307 11041 0   22.694884 71.590923 2022-11-17 04:21:11 Gujarat, India
2022-11-15 India Gujarat     1277282 11041 0   22.694884 71.590923 2022-11-16 04:21:09 Gujarat, India
2022-11-14 India Gujarat     1277266 11041 0   22.694884 71.590923 2022-11-15 04:21:16 Gujarat, India
2022-11-13 India Gujarat     1277250 11040 0   22.694884 71.590923 2022-11-14 04:21:09 Gujarat, India
2022-11-12 India Gujarat     1277227 11040 0   22.694884 71.590923 2022-11-13 04:21:14 Gujarat, India
2022-11-11 India Gujarat     1277198 11040 0   22.694884 71.590923 2022-11-12 04:20:41 Gujarat, India
2022-11-10 India Gujarat     1277162 11040 0   22.694884 71.590923 2022-11-11 04:21:22 Gujarat, India
2022-11-09 India Gujarat     1277046 11040 0   22.694884 71.590923 2022-11-10 04:21:16 Gujarat, India
2022-11-08 India Gujarat     1277046 11040 0   22.694884 71.590923 2022-11-09 04:21:22 Gujarat, India
2022-11-07 India Gujarat     1277046 11040 0   22.694884 71.590923 2022-11-08 04:21:21 Gujarat, India
2022-11-06 India Gujarat     1277046 11040 0   22.694884 71.590923 2022-11-07 04:21:26 Gujarat, India
2022-11-05 India Gujarat     1277019 11040 0   22.694884 71.590923 2022-11-06 04:21:24 Gujarat, India
2022-11-04 India Gujarat     1276978 11039 0   22.694884 71.590923 2022-11-05 04:21:52 Gujarat, India
2022-11-03 India Gujarat     1276932 11039 0   22.694884 71.590923 2022-11-04 04:22:11 Gujarat, India
2022-11-02 India Gujarat     1276896 11039 0   22.694884 71.590923 2022-11-03 04:22:05 Gujarat, India
2022-11-01 India Gujarat     1276839 11039 0   22.694884 71.590923 2022-11-02 04:22:09 Gujarat, India
2022-10-31 India Gujarat     1276790 11039 0   22.694884 71.590923 2022-11-01 04:22:36 Gujarat, India
2022-10-30 India Gujarat     1276743 11039 0   22.694884 71.590923 2022-10-31 04:21:36 Gujarat, India
2022-10-29 India Gujarat     1276702 11039 0   22.694884 71.590923 2022-10-30 04:22:14 Gujarat, India
2022-10-28 India Gujarat     1276662 11039 0   22.694884 71.590923 2022-10-29 04:21:13 Gujarat, India
2022-10-27 India Gujarat     1276632 11038 0   22.694884 71.590923 2022-10-28 04:22:31 Gujarat, India
2022-10-26 India Gujarat     1276615 11038 0   22.694884 71.590923 2022-10-27 04:22:01 Gujarat, India
2022-10-25 India Gujarat     1276600 11038 0   22.694884 71.590923 2022-10-26 04:22:19 Gujarat, India
2022-10-24 India Gujarat     1276573 11038 0   22.694884 71.590923 2022-10-25 04:21:53 Gujarat, India
2022-10-23 India Gujarat     1276531 11038 0   22.694884 71.590923 2022-10-24 04:22:29 Gujarat, India
2022-10-22 India Gujarat     1276440 11038 0   22.694884 71.590923 2022-10-23 04:22:46 Gujarat, India
2022-10-21 India Gujarat     1276378 11038 0   22.694884 71.590923 2022-10-22 04:22:53 Gujarat, India
2022-10-20 India Gujarat     1276307 11038 0   22.694884 71.590923 2022-10-21 04:22:23 Gujarat, India
2022-10-19 India Gujarat     1276244 11038 0   22.694884 71.590923 2022-10-20 04:22:59 Gujarat, India
2022-10-18 India Gujarat     1276182 11038 0   22.694884 71.590923 2022-10-19 04:22:26 Gujarat, India
2022-10-17 India Gujarat     1276125 11038 0   22.694884 71.590923 2022-10-18 04:22:42 Gujarat, India
2022-10-16 India Gujarat     1276078 11037 0   22.694884 71.590923 2022-10-17 04:20:31 Gujarat, India
2022-10-15 India Gujarat     1276018 11037 0   22.694884 71.590923 2022-10-16 04:22:39 Gujarat, India
2022-10-14 India Gujarat     1275950 11037 0   22.694884 71.590923 2022-10-15 04:22:00 Gujarat, India
2022-10-13 India Gujarat     1275879 11037 0   22.694884 71.590923 2022-10-14 04:22:28 Gujarat, India
2022-10-12 India Gujarat     1275785 11037 0   22.694884 71.590923 2022-10-13 04:22:39 Gujarat, India
2022-10-11 India Gujarat     1275674 11037 0   22.694884 71.590923 2022-10-12 04:22:51 Gujarat, India
2022-10-10 India Gujarat     1275566 11037 0   22.694884 71.590923 2022-10-11 04:23:05 Gujarat, India
2022-10-09 India Gujarat     1275498 11036 0   22.694884 71.590923 2022-10-10 04:22:32 Gujarat, India
2022-10-08 India Gujarat     1275410 11036 0   22.694884 71.590923 2022-10-09 04:21:16 Gujarat, India
2022-10-07 India Gujarat     1275323 11036 0   22.694884 71.590923 2022-10-08 04:22:56 Gujarat, India
2022-10-06 India Gujarat     1275223 11035 0   22.694884 71.590923 2022-10-07 04:23:08 Gujarat, India
2022-10-05 India Gujarat     1275154 11035 0   22.694884 71.590923 2022-10-06 04:21:22 Gujarat, India
2022-10-04 India Gujarat     1275069 11035 0   22.694884 71.590923 2022-10-05 04:23:06 Gujarat, India
2022-10-03 India Gujarat     1274989 11035 0   22.694884 71.590923 2022-10-04 04:22:55 Gujarat, India
2022-10-02 India Gujarat     1274927 11035 0   22.694884 71.590923 2022-10-03 04:23:11 Gujarat, India
2022-10-01 India Gujarat     1274842 11034 0   22.694884 71.590923 2022-10-02 04:21:23 Gujarat, India
2022-09-30 India Gujarat     1274751 11034 0   22.694884 71.590923 2022-10-01 04:23:01 Gujarat, India
2022-09-29 India Gujarat     1274666 11034 0   22.694884 71.590923 2022-09-30 04:23:09 Gujarat, India
2022-09-28 India Gujarat     1274552 11034 0   22.694884 71.590923 2022-09-29 04:22:34 Gujarat, India
2022-09-27 India Gujarat     1274459 11034 0   22.694884 71.590923 2022-09-28 04:23:01 Gujarat, India
2022-09-26 India Gujarat     1274363 11033 0   22.694884 71.590923 2022-09-27 04:23:01 Gujarat, India
2022-09-25 India Gujarat     1274278 11032 0   22.694884 71.590923 2022-09-26 04:20:52 Gujarat, India
2022-09-24 India Gujarat     1274176 11032 0   22.694884 71.590923 2022-09-25 04:23:31 Gujarat, India
2022-09-23 India Gujarat     1274036 11031 0   22.694884 71.590923 2022-09-24 04:21:40 Gujarat, India
2022-09-22 India Gujarat     1273911 11029 0   22.694884 71.590923 2022-09-23 04:23:13 Gujarat, India
2022-09-21 India Gujarat     1273787 11028 0   22.694884 71.590923 2022-09-22 04:22:56 Gujarat, India

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;