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 = "Chandigarh" sorted by day descending

✎ View and edit SQL

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

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

province_or_state 1

  • Chandigarh · 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 Chandigarh     99348 1181 0   30.733839 76.768278 2022-12-30 04:21:04 Chandigarh, India
2022-12-28 India Chandigarh     99348 1181 0   30.733839 76.768278 2022-12-29 04:21:01 Chandigarh, India
2022-12-27 India Chandigarh     99346 1181 0   30.733839 76.768278 2022-12-28 04:21:04 Chandigarh, India
2022-12-26 India Chandigarh     99345 1181 0   30.733839 76.768278 2022-12-27 04:21:07 Chandigarh, India
2022-12-25 India Chandigarh     99344 1181 0   30.733839 76.768278 2022-12-26 04:21:06 Chandigarh, India
2022-12-24 India Chandigarh     99343 1181 0   30.733839 76.768278 2022-12-25 04:21:04 Chandigarh, India
2022-12-23 India Chandigarh     99343 1181 0   30.733839 76.768278 2022-12-24 04:21:02 Chandigarh, India
2022-12-22 India Chandigarh     99343 1181 0   30.733839 76.768278 2022-12-23 04:21:04 Chandigarh, India
2022-12-21 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-22 04:20:56 Chandigarh, India
2022-12-20 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-21 04:21:03 Chandigarh, India
2022-12-19 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-20 04:21:04 Chandigarh, India
2022-12-18 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-19 04:21:03 Chandigarh, India
2022-12-17 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-18 04:21:03 Chandigarh, India
2022-12-16 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-17 04:21:04 Chandigarh, India
2022-12-15 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-16 04:21:01 Chandigarh, India
2022-12-14 India Chandigarh     99342 1181 0   30.733839 76.768278 2022-12-15 04:20:58 Chandigarh, India
2022-12-13 India Chandigarh     99340 1181 0   30.733839 76.768278 2022-12-14 04:21:04 Chandigarh, India
2022-12-12 India Chandigarh     99340 1181 0   30.733839 76.768278 2022-12-13 04:21:01 Chandigarh, India
2022-12-11 India Chandigarh     99340 1181 0   30.733839 76.768278 2022-12-12 04:21:01 Chandigarh, India
2022-12-10 India Chandigarh     99340 1181 0   30.733839 76.768278 2022-12-11 04:20:50 Chandigarh, India
2022-12-09 India Chandigarh     99340 1181 0   30.733839 76.768278 2022-12-10 04:21:02 Chandigarh, India
2022-12-08 India Chandigarh     99340 1181 0   30.733839 76.768278 2022-12-09 04:21:05 Chandigarh, India
2022-12-07 India Chandigarh     99339 1181 0   30.733839 76.768278 2022-12-08 04:21:07 Chandigarh, India
2022-12-06 India Chandigarh     99338 1181 0   30.733839 76.768278 2022-12-07 04:20:58 Chandigarh, India
2022-12-05 India Chandigarh     99338 1181 0   30.733839 76.768278 2022-12-06 04:21:03 Chandigarh, India
2022-12-04 India Chandigarh     99338 1181 0   30.733839 76.768278 2022-12-05 04:20:58 Chandigarh, India
2022-12-03 India Chandigarh     99337 1181 0   30.733839 76.768278 2022-12-04 04:20:56 Chandigarh, India
2022-12-02 India Chandigarh     99337 1181 0   30.733839 76.768278 2022-12-03 04:21:02 Chandigarh, India
2022-12-01 India Chandigarh     99337 1181 0   30.733839 76.768278 2022-12-02 04:21:07 Chandigarh, India
2022-11-30 India Chandigarh     99337 1181 0   30.733839 76.768278 2022-12-01 04:21:03 Chandigarh, India
2022-11-29 India Chandigarh     99337 1181 0   30.733839 76.768278 2022-11-30 04:21:07 Chandigarh, India
2022-11-28 India Chandigarh     99336 1181 0   30.733839 76.768278 2022-11-29 04:21:05 Chandigarh, India
2022-11-27 India Chandigarh     99336 1181 0   30.733839 76.768278 2022-11-28 04:21:02 Chandigarh, India
2022-11-26 India Chandigarh     99335 1181 0   30.733839 76.768278 2022-11-27 04:21:05 Chandigarh, India
2022-11-25 India Chandigarh     99333 1181 0   30.733839 76.768278 2022-11-26 04:21:11 Chandigarh, India
2022-11-24 India Chandigarh     99333 1181 0   30.733839 76.768278 2022-11-25 04:21:06 Chandigarh, India
2022-11-23 India Chandigarh     99332 1181 0   30.733839 76.768278 2022-11-24 04:21:09 Chandigarh, India
2022-11-22 India Chandigarh     99330 1181 0   30.733839 76.768278 2022-11-23 04:21:06 Chandigarh, India
2022-11-21 India Chandigarh     99329 1181 0   30.733839 76.768278 2022-11-22 04:20:47 Chandigarh, India
2022-11-20 India Chandigarh     99329 1181 0   30.733839 76.768278 2022-11-21 04:21:05 Chandigarh, India
2022-11-19 India Chandigarh     99328 1181 0   30.733839 76.768278 2022-11-20 04:21:08 Chandigarh, India
2022-11-18 India Chandigarh     99328 1181 0   30.733839 76.768278 2022-11-19 04:21:14 Chandigarh, India
2022-11-17 India Chandigarh     99325 1181 0   30.733839 76.768278 2022-11-18 04:21:15 Chandigarh, India
2022-11-16 India Chandigarh     99324 1181 0   30.733839 76.768278 2022-11-17 04:21:11 Chandigarh, India
2022-11-15 India Chandigarh     99324 1181 0   30.733839 76.768278 2022-11-16 04:21:09 Chandigarh, India
2022-11-14 India Chandigarh     99324 1181 0   30.733839 76.768278 2022-11-15 04:21:16 Chandigarh, India
2022-11-13 India Chandigarh     99323 1181 0   30.733839 76.768278 2022-11-14 04:21:09 Chandigarh, India
2022-11-12 India Chandigarh     99323 1181 0   30.733839 76.768278 2022-11-13 04:21:14 Chandigarh, India
2022-11-11 India Chandigarh     99322 1181 0   30.733839 76.768278 2022-11-12 04:20:41 Chandigarh, India
2022-11-10 India Chandigarh     99319 1181 0   30.733839 76.768278 2022-11-11 04:21:22 Chandigarh, India
2022-11-09 India Chandigarh     99318 1181 0   30.733839 76.768278 2022-11-10 04:21:16 Chandigarh, India
2022-11-08 India Chandigarh     99318 1181 0   30.733839 76.768278 2022-11-09 04:21:22 Chandigarh, India
2022-11-07 India Chandigarh     99318 1181 0   30.733839 76.768278 2022-11-08 04:21:21 Chandigarh, India
2022-11-06 India Chandigarh     99318 1181 0   30.733839 76.768278 2022-11-07 04:21:26 Chandigarh, India
2022-11-05 India Chandigarh     99317 1181 0   30.733839 76.768278 2022-11-06 04:21:24 Chandigarh, India
2022-11-04 India Chandigarh     99316 1181 0   30.733839 76.768278 2022-11-05 04:21:52 Chandigarh, India
2022-11-03 India Chandigarh     99312 1181 0   30.733839 76.768278 2022-11-04 04:22:11 Chandigarh, India
2022-11-02 India Chandigarh     99305 1181 0   30.733839 76.768278 2022-11-03 04:22:05 Chandigarh, India
2022-11-01 India Chandigarh     99299 1181 0   30.733839 76.768278 2022-11-02 04:22:09 Chandigarh, India
2022-10-31 India Chandigarh     99299 1181 0   30.733839 76.768278 2022-11-01 04:22:36 Chandigarh, India
2022-10-30 India Chandigarh     99299 1181 0   30.733839 76.768278 2022-10-31 04:21:36 Chandigarh, India
2022-10-29 India Chandigarh     99297 1181 0   30.733839 76.768278 2022-10-30 04:22:14 Chandigarh, India
2022-10-28 India Chandigarh     99295 1181 0   30.733839 76.768278 2022-10-29 04:21:13 Chandigarh, India
2022-10-27 India Chandigarh     99291 1181 0   30.733839 76.768278 2022-10-28 04:22:31 Chandigarh, India
2022-10-26 India Chandigarh     99289 1181 0   30.733839 76.768278 2022-10-27 04:22:01 Chandigarh, India
2022-10-25 India Chandigarh     99289 1181 0   30.733839 76.768278 2022-10-26 04:22:19 Chandigarh, India
2022-10-24 India Chandigarh     99288 1181 0   30.733839 76.768278 2022-10-25 04:21:53 Chandigarh, India
2022-10-23 India Chandigarh     99287 1181 0   30.733839 76.768278 2022-10-24 04:22:29 Chandigarh, India
2022-10-22 India Chandigarh     99287 1181 0   30.733839 76.768278 2022-10-23 04:22:46 Chandigarh, India
2022-10-21 India Chandigarh     99286 1181 0   30.733839 76.768278 2022-10-22 04:22:53 Chandigarh, India
2022-10-20 India Chandigarh     99282 1181 0   30.733839 76.768278 2022-10-21 04:22:23 Chandigarh, India
2022-10-19 India Chandigarh     99280 1181 0   30.733839 76.768278 2022-10-20 04:22:59 Chandigarh, India
2022-10-18 India Chandigarh     99274 1181 0   30.733839 76.768278 2022-10-19 04:22:26 Chandigarh, India
2022-10-17 India Chandigarh     99270 1181 0   30.733839 76.768278 2022-10-18 04:22:42 Chandigarh, India
2022-10-16 India Chandigarh     99269 1181 0   30.733839 76.768278 2022-10-17 04:20:31 Chandigarh, India
2022-10-15 India Chandigarh     99264 1181 0   30.733839 76.768278 2022-10-16 04:22:39 Chandigarh, India
2022-10-14 India Chandigarh     99260 1181 0   30.733839 76.768278 2022-10-15 04:22:00 Chandigarh, India
2022-10-13 India Chandigarh     99257 1181 0   30.733839 76.768278 2022-10-14 04:22:28 Chandigarh, India
2022-10-12 India Chandigarh     99253 1181 0   30.733839 76.768278 2022-10-13 04:22:39 Chandigarh, India
2022-10-11 India Chandigarh     99248 1181 0   30.733839 76.768278 2022-10-12 04:22:51 Chandigarh, India
2022-10-10 India Chandigarh     99244 1181 0   30.733839 76.768278 2022-10-11 04:23:05 Chandigarh, India
2022-10-09 India Chandigarh     99241 1181 0   30.733839 76.768278 2022-10-10 04:22:32 Chandigarh, India
2022-10-08 India Chandigarh     99238 1181 0   30.733839 76.768278 2022-10-09 04:21:16 Chandigarh, India
2022-10-07 India Chandigarh     99235 1181 0   30.733839 76.768278 2022-10-08 04:22:56 Chandigarh, India
2022-10-06 India Chandigarh     99225 1181 0   30.733839 76.768278 2022-10-07 04:23:08 Chandigarh, India
2022-10-05 India Chandigarh     99221 1181 0   30.733839 76.768278 2022-10-06 04:21:22 Chandigarh, India
2022-10-04 India Chandigarh     99216 1181 0   30.733839 76.768278 2022-10-05 04:23:06 Chandigarh, India
2022-10-03 India Chandigarh     99211 1181 0   30.733839 76.768278 2022-10-04 04:22:55 Chandigarh, India
2022-10-02 India Chandigarh     99211 1181 0   30.733839 76.768278 2022-10-03 04:23:11 Chandigarh, India
2022-10-01 India Chandigarh     99206 1181 0   30.733839 76.768278 2022-10-02 04:21:23 Chandigarh, India
2022-09-30 India Chandigarh     99205 1181 0   30.733839 76.768278 2022-10-01 04:23:01 Chandigarh, India
2022-09-29 India Chandigarh     99201 1181 0   30.733839 76.768278 2022-09-30 04:23:09 Chandigarh, India
2022-09-28 India Chandigarh     99196 1181 0   30.733839 76.768278 2022-09-29 04:22:34 Chandigarh, India
2022-09-27 India Chandigarh     99191 1181 0   30.733839 76.768278 2022-09-28 04:23:01 Chandigarh, India
2022-09-26 India Chandigarh     99188 1181 0   30.733839 76.768278 2022-09-27 04:23:01 Chandigarh, India
2022-09-25 India Chandigarh     99185 1181 0   30.733839 76.768278 2022-09-26 04:20:52 Chandigarh, India
2022-09-24 India Chandigarh     99181 1181 0   30.733839 76.768278 2022-09-25 04:23:31 Chandigarh, India
2022-09-23 India Chandigarh     99175 1181 0   30.733839 76.768278 2022-09-24 04:21:40 Chandigarh, India
2022-09-22 India Chandigarh     99162 1181 0   30.733839 76.768278 2022-09-23 04:23:13 Chandigarh, India
2022-09-21 India Chandigarh     99160 1181 0   30.733839 76.768278 2022-09-22 04:22:56 Chandigarh, 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;