johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Punjab" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
277 | 277 | 2021-12-02 | India | Punjab | 603352 | 16606 | 0 | 30.841465000000003 | 75.40879 | 2021-12-03 04:23:05 | Punjab, India | |||
4293 | 4293 | 2021-10-28 | India | Punjab | 602320 | 16556 | 0 | 30.841465000000003 | 75.40879 | 2021-10-29 04:22:03 | Punjab, India | |||
8295 | 8295 | 2020-10-25 | India | Punjab | 131055 | 4117 | 122721 | 4217 | 30.841465000000003 | 75.40879 | 2020-10-26 04:25:02 | Punjab, India | ||
12303 | 12303 | 2021-01-26 | India | Punjab | 172218 | 5571 | 164541 | 2106 | 30.841465000000003 | 75.40879 | 2021-01-27 05:23:41 | Punjab, India | ||
16318 | 16318 | 2021-09-18 | India | Punjab | 601236 | 16467 | 0 | 30.841465000000003 | 75.40879 | 2021-09-19 04:21:34 | Punjab, India | |||
20333 | 20333 | 2021-05-28 | India | Punjab | 559795 | 14180 | 500651 | 44964 | 30.841465000000003 | 75.40879 | 2021-05-29 04:20:41 | Punjab, India | ||
24348 | 24348 | 2022-03-20 | India | Punjab | 758931 | 17737 | 0 | 30.841465000000003 | 75.40879 | 2022-03-21 04:20:50 | Punjab, India | |||
28363 | 28363 | 2021-11-11 | India | Punjab | 602695 | 16570 | 0 | 30.841465000000003 | 75.40879 | 2021-11-12 04:22:01 | Punjab, India | |||
32379 | 32379 | 2021-08-25 | India | Punjab | 600378 | 16358 | 0 | 30.841465000000003 | 75.40879 | 2021-08-26 04:21:28 | Punjab, India | |||
36393 | 36393 | 2021-04-12 | India | Punjab | 276223 | 7559 | 240798 | 27866 | 30.841465000000003 | 75.40879 | 2021-04-13 04:20:37 | Punjab, India | ||
43655 | 43655 | 2021-11-02 | India | Punjab | 602434 | 16561 | 0 | 30.841465000000003 | 75.40879 | 2021-11-03 06:22:09 | Punjab, India | |||
50754 | 50754 | 2021-05-29 | India | Punjab | 562831 | 14305 | 506349 | 42177 | 30.841465000000003 | 75.40879 | 2021-05-30 04:20:55 | Punjab, India | ||
54768 | 54768 | 2021-03-07 | India | Punjab | 188391 | 5927 | 174967 | 7497 | 30.841465000000003 | 75.40879 | 2021-03-08 05:24:48 | Punjab, India | ||
62083 | 62083 | 2020-07-23 | India | Punjab | 11739 | 277 | 7741 | 3721 | 30.841465000000003 | 75.40879 | 2020-07-24 05:30:40 | Punjab, India | ||
63009 | 63009 | 2022-11-12 | India | Punjab | 785280 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-13 04:21:14 | Punjab, India | |||
67024 | 67024 | 2021-09-01 | India | Punjab | 600651 | 16434 | 0 | 30.841465000000003 | 75.40879 | 2021-09-02 04:21:15 | Punjab, India | |||
71038 | 71038 | 2022-02-07 | India | Punjab | 752635 | 17469 | 0 | 30.841465000000003 | 75.40879 | 2022-02-08 04:21:15 | Punjab, India | |||
75052 | 75052 | 2020-12-03 | India | Punjab | 154064 | 4862 | 141478 | 7724 | 30.841465000000003 | 75.40879 | 2020-12-04 05:27:27 | Punjab, India | ||
79051 | 79051 | 2020-10-14 | India | Punjab | 125760 | 3925 | 114075 | 7760 | 30.841465000000003 | 75.40879 | 2020-10-15 04:24:28 | Punjab, India | ||
83058 | 83058 | 2021-05-25 | India | Punjab | 548231 | 13642 | 481462 | 53127 | 30.841465000000003 | 75.40879 | 2021-05-26 04:20:35 | Punjab, India | ||
87072 | 87072 | 2021-11-09 | India | Punjab | 602616 | 16566 | 0 | 30.841465000000003 | 75.40879 | 2021-11-10 04:21:38 | Punjab, India | |||
91089 | 91089 | 2022-07-23 | India | Punjab | 770237 | 17800 | 0 | 30.841465 | 75.40879 | 2022-07-24 04:20:47 | Punjab, India | |||
98435 | 98435 | 2020-08-04 | India | Punjab | 19015 | 462 | 12491 | 6062 | 30.841465000000003 | 75.40879 | 2020-08-05 04:34:43 | Punjab, India | ||
99273 | 99273 | 2022-01-14 | India | Punjab | 649736 | 16731 | 0 | 30.841465000000003 | 75.40879 | 2022-01-15 04:21:07 | Punjab, India | |||
103289 | 103289 | 2021-08-15 | India | Punjab | 599942 | 16342 | 0 | 30.841465000000003 | 75.40879 | 2021-08-16 04:21:31 | Punjab, India | |||
107414 | 107414 | 2021-06-19 | India | Punjab | 591762 | 15802 | 567883 | 8077 | 30.841465000000003 | 75.40879 | 2021-06-20 04:21:48 | Punjab, India | ||
114699 | 114699 | 2022-09-06 | India | Punjab | 780990 | 17904 | 0 | 30.841465 | 75.40879 | 2022-09-07 04:20:59 | Punjab, India | |||
122027 | 122027 | 2020-07-19 | India | Punjab | 10100 | 254 | 6535 | 3311 | 30.841465000000003 | 75.40879 | 2020-07-20 05:34:40 | Punjab, India | ||
122667 | 122667 | 2020-11-18 | India | Punjab | 143395 | 4541 | 132917 | 5937 | 30.841465000000003 | 75.40879 | 2020-11-19 05:25:23 | Punjab, India | ||
126680 | 126680 | 2022-01-09 | India | Punjab | 621419 | 16675 | 0 | 30.841465000000003 | 75.40879 | 2022-01-10 04:22:07 | Punjab, India | |||
130697 | 130697 | 2022-10-04 | India | Punjab | 784660 | 17917 | 0 | 30.841465 | 75.40879 | 2022-10-05 04:23:06 | Punjab, India | |||
137918 | 137918 | 2021-12-04 | India | Punjab | 603410 | 16607 | 0 | 30.841465000000003 | 75.40879 | 2021-12-05 04:22:25 | Punjab, India | |||
141935 | 141935 | 2022-07-09 | India | Punjab | 764513 | 17784 | 0 | 30.841465 | 75.40879 | 2022-07-10 04:20:54 | Punjab, India | |||
145935 | 145935 | 2020-08-15 | India | Punjab | 30041 | 771 | 18863 | 10407 | 30.841465000000003 | 75.40879 | 2020-08-16 04:27:42 | Punjab, India | ||
149931 | 149931 | 2021-11-29 | India | Punjab | 603258 | 16599 | 0 | 30.841465000000003 | 75.40879 | 2021-11-30 04:22:53 | Punjab, India | |||
153946 | 153946 | 2021-01-08 | India | Punjab | 168187 | 5422 | 159790 | 2975 | 30.841465000000003 | 75.40879 | 2021-01-09 05:22:18 | Punjab, India | ||
157960 | 157960 | 2022-03-29 | India | Punjab | 759094 | 17741 | 0 | 30.841465000000003 | 75.40879 | 2022-03-30 04:20:45 | Punjab, India | |||
161975 | 161975 | 2021-11-19 | India | Punjab | 602943 | 16580 | 0 | 30.841465000000003 | 75.40879 | 2021-11-20 04:22:17 | Punjab, India | |||
165992 | 165992 | 2022-06-21 | India | Punjab | 761487 | 17759 | 0 | 30.841465 | 75.40879 | 2022-06-22 04:20:54 | Punjab, India | |||
170007 | 170007 | 2021-04-16 | India | Punjab | 290707 | 7772 | 252190 | 30745 | 30.841465000000003 | 75.40879 | 2021-04-17 04:20:40 | Punjab, India | ||
177345 | 177345 | 2020-07-27 | India | Punjab | 13769 | 318 | 9064 | 4387 | 30.841465000000003 | 75.40879 | 2020-07-28 04:58:43 | Punjab, India | ||
177989 | 177989 | 2021-09-02 | India | Punjab | 600715 | 16435 | 0 | 30.841465000000003 | 75.40879 | 2021-09-03 04:21:20 | Punjab, India | |||
182003 | 182003 | 2021-02-21 | India | Punjab | 178459 | 5754 | 169686 | 3019 | 30.841465000000003 | 75.40879 | 2021-02-22 05:24:21 | Punjab, India | ||
186018 | 186018 | 2022-02-13 | India | Punjab | 755561 | 17596 | 0 | 30.841465000000003 | 75.40879 | 2022-02-14 04:20:51 | Punjab, India | |||
190032 | 190032 | 2021-01-11 | India | Punjab | 169225 | 5447 | 160920 | 2858 | 30.841465000000003 | 75.40879 | 2021-01-12 05:22:15 | Punjab, India | ||
194030 | 194030 | 2020-08-31 | India | Punjab | 53992 | 1453 | 37027 | 15512 | 30.841465000000003 | 75.40879 | 2020-09-01 04:28:31 | Punjab, India | ||
198206 | 198206 | 2022-10-19 | India | Punjab | 784989 | 17919 | 0 | 30.841465 | 75.40879 | 2022-10-20 04:22:59 | Punjab, India | |||
202219 | 202219 | 2020-12-25 | India | Punjab | 164821 | 5269 | 154845 | 4707 | 30.841465000000003 | 75.40879 | 2020-12-26 05:22:28 | Punjab, India | ||
206217 | 206217 | 2020-08-19 | India | Punjab | 36084 | 921 | 22703 | 12460 | 30.841465000000003 | 75.40879 | 2020-08-20 04:27:43 | Punjab, India | ||
210203 | 210203 | 2020-10-29 | India | Punjab | 132727 | 4168 | 124293 | 4266 | 30.841465000000003 | 75.40879 | 2020-10-30 04:24:49 | Punjab, India | ||
217927 | 217927 | 2022-12-26 | India | Punjab | 785414 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-27 04:21:07 | Punjab, India | |||
221943 | 221943 | 2022-05-09 | India | Punjab | 759930 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-10 04:20:50 | Punjab, India | |||
229174 | 229174 | 2022-05-31 | India | Punjab | 760356 | 17752 | 0 | 30.841465 | 75.40879 | 2022-06-01 04:20:55 | Punjab, India | |||
233190 | 233190 | 2022-02-11 | India | Punjab | 754812 | 17575 | 0 | 30.841465000000003 | 75.40879 | 2022-02-12 04:21:06 | Punjab, India | |||
237204 | 237204 | 2021-01-18 | India | Punjab | 170729 | 5509 | 162762 | 2458 | 30.841465000000003 | 75.40879 | 2021-01-19 05:22:15 | Punjab, India | ||
241218 | 241218 | 2021-04-02 | India | Punjab | 245768 | 6983 | 213327 | 25458 | 30.841465000000003 | 75.40879 | 2021-04-03 04:20:44 | Punjab, India | ||
245232 | 245232 | 2021-08-17 | India | Punjab | 600008 | 16345 | 0 | 30.841465000000003 | 75.40879 | 2021-08-18 04:21:35 | Punjab, India | |||
249246 | 249246 | 2021-09-04 | India | Punjab | 600780 | 16439 | 0 | 30.841465000000003 | 75.40879 | 2021-09-05 04:21:33 | Punjab, India | |||
253261 | 253261 | 2022-09-08 | India | Punjab | 783755 | 17905 | 0 | 30.841465 | 75.40879 | 2022-09-09 04:21:11 | Punjab, India | |||
257277 | 257277 | 2022-12-10 | India | Punjab | 785371 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-11 04:20:50 | Punjab, India | |||
261480 | 261480 | 2022-03-15 | India | Punjab | 758793 | 17736 | 0 | 30.841465000000003 | 75.40879 | 2022-03-16 04:20:50 | Punjab, India | |||
272118 | 272118 | 2020-11-10 | India | Punjab | 138485 | 4358 | 129089 | 5038 | 30.841465000000003 | 75.40879 | 2020-11-11 05:25:30 | Punjab, India | ||
276130 | 276130 | 2021-11-03 | India | Punjab | 602466 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-04 04:22:20 | Punjab, India | |||
280146 | 280146 | 2021-02-24 | India | Punjab | 179819 | 5786 | 170435 | 3598 | 30.841465000000003 | 75.40879 | 2021-02-25 05:24:57 | Punjab, India | ||
287308 | 287308 | 2020-06-15 | India | Punjab | 3267 | 71 | 2443 | 753 | 30.841465000000003 | 75.40879 | 2020-06-16 04:33:09 | Punjab, India | ||
287943 | 287943 | 2021-10-31 | India | Punjab | 602401 | 16559 | 0 | 30.841465000000003 | 75.40879 | 2021-11-01 04:22:01 | Punjab, India | |||
291960 | 291960 | 2022-11-15 | India | Punjab | 785300 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-16 04:21:09 | Punjab, India | |||
295975 | 295975 | 2021-07-15 | India | Punjab | 598027 | 16212 | 580483 | 1332 | 30.841465000000003 | 75.40879 | 2021-07-16 04:21:22 | Punjab, India | ||
303180 | 303180 | 2020-07-01 | India | Punjab | 5668 | 149 | 3867 | 1652 | 30.841465000000003 | 75.40879 | 2020-07-02 04:33:46 | Punjab, India | ||
303816 | 303816 | 2022-04-16 | India | Punjab | 759248 | 17743 | 0 | 30.841465000000003 | 75.40879 | 2022-04-17 04:20:59 | Punjab, India | |||
307832 | 307832 | 2022-12-13 | India | Punjab | 785374 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-14 04:21:04 | Punjab, India | |||
311848 | 311848 | 2022-11-13 | India | Punjab | 785291 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-14 04:21:09 | Punjab, India | |||
315864 | 315864 | 2022-02-12 | India | Punjab | 755234 | 17585 | 0 | 30.841465000000003 | 75.40879 | 2022-02-13 04:21:00 | Punjab, India | |||
319880 | 319880 | 2022-10-30 | India | Punjab | 785160 | 17920 | 0 | 30.841465 | 75.40879 | 2022-10-31 04:21:36 | Punjab, India | |||
327122 | 327122 | 2020-07-20 | India | Punjab | 10510 | 262 | 7118 | 3130 | 30.841465000000003 | 75.40879 | 2020-07-21 04:38:46 | Punjab, India | ||
327854 | 327854 | 2022-12-27 | India | Punjab | 785423 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-28 04:21:04 | Punjab, India | |||
331869 | 331869 | 2021-08-04 | India | Punjab | 599266 | 16299 | 582494 | 473 | 30.841465000000003 | 75.40879 | 2021-08-05 04:21:51 | Punjab, India | ||
335884 | 335884 | 2022-03-18 | India | Punjab | 758894 | 17737 | 0 | 30.841465000000003 | 75.40879 | 2022-03-19 04:20:47 | Punjab, India | |||
340238 | 340238 | 2021-02-03 | India | Punjab | 173861 | 5628 | 166103 | 2130 | 30.841465000000003 | 75.40879 | 2021-02-04 05:22:26 | Punjab, India | ||
344238 | 344238 | 2020-09-14 | India | Punjab | 79679 | 2356 | 57536 | 19787 | 30.841465000000003 | 75.40879 | 2020-09-15 03:22:50 | Punjab, India | ||
348244 | 348244 | 2022-12-14 | India | Punjab | 785374 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-15 04:20:58 | Punjab, India | |||
352259 | 352259 | 2021-03-11 | India | Punjab | 193345 | 5996 | 177280 | 10069 | 30.841465000000003 | 75.40879 | 2021-03-12 05:26:50 | Punjab, India | ||
356274 | 356274 | 2022-03-11 | India | Punjab | 758643 | 17723 | 0 | 30.841465000000003 | 75.40879 | 2022-03-12 04:20:50 | Punjab, India | |||
360290 | 360290 | 2022-05-07 | India | Punjab | 759882 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-08 04:20:49 | Punjab, India | |||
367528 | 367528 | 2020-07-16 | India | Punjab | 9094 | 230 | 6277 | 2587 | 30.841465000000003 | 75.40879 | 2020-07-17 04:34:50 | Punjab, India | ||
371500 | 371500 | 2020-08-08 | India | Punjab | 22928 | 562 | 14880 | 7486 | 30.841465000000003 | 75.40879 | 2020-08-09 04:34:54 | Punjab, India | ||
372144 | 372144 | 2022-09-13 | India | Punjab | 784005 | 17906 | 0 | 30.841465 | 75.40879 | 2022-09-14 04:20:44 | Punjab, India | |||
376145 | 376145 | 2020-11-06 | India | Punjab | 136481 | 4295 | 127304 | 4882 | 30.841465000000003 | 75.40879 | 2020-11-07 05:24:52 | Punjab, India | ||
380156 | 380156 | 2021-04-30 | India | Punjab | 370973 | 9022 | 306153 | 55798 | 30.841465000000003 | 75.40879 | 2021-05-01 04:20:47 | Punjab, India | ||
384171 | 384171 | 2022-09-23 | India | Punjab | 784425 | 17911 | 0 | 30.841465 | 75.40879 | 2022-09-24 04:21:40 | Punjab, India | |||
388186 | 388186 | 2021-04-04 | India | Punjab | 251460 | 7083 | 219063 | 25314 | 30.841465000000003 | 75.40879 | 2021-04-05 04:20:35 | Punjab, India | ||
392198 | 392198 | 2020-11-27 | India | Punjab | 150086 | 4737 | 137630 | 7719 | 30.841465000000003 | 75.40879 | 2020-11-28 05:25:50 | Punjab, India | ||
396212 | 396212 | 2022-10-07 | India | Punjab | 784721 | 17917 | 0 | 30.841465 | 75.40879 | 2022-10-08 04:22:56 | Punjab, India | |||
400227 | 400227 | 2021-06-29 | India | Punjab | 595351 | 16033 | 575971 | 3347 | 30.841465000000003 | 75.40879 | 2021-06-30 04:21:41 | Punjab, India | ||
404241 | 404241 | 2021-12-07 | India | Punjab | 603556 | 16612 | 0 | 30.841465000000003 | 75.40879 | 2021-12-08 04:22:46 | Punjab, India | |||
408257 | 408257 | 2021-07-28 | India | Punjab | 598947 | 16286 | 582102 | 559 | 30.841465000000003 | 75.40879 | 2021-07-29 04:21:33 | Punjab, India | ||
415472 | 415472 | 2020-07-05 | India | Punjab | 6283 | 164 | 4408 | 1711 | 30.841465000000003 | 75.40879 | 2020-07-06 04:33:57 | Punjab, India | ||
419283 | 419283 | 2022-09-18 | India | Punjab | 784215 | 17910 | 0 | 30.841465 | 75.40879 | 2022-09-19 04:21:49 | Punjab, India | |||
423298 | 423298 | 2021-10-10 | India | Punjab | 601876 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-11 04:21:31 | Punjab, India | |||
427299 | 427299 | 2020-09-07 | India | Punjab | 65583 | 1923 | 47020 | 16640 | 30.841465000000003 | 75.40879 | 2020-09-08 04:28:25 | Punjab, 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]);