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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687428 | 3687428 | 2022-01-13 | India | Punjab | 636243 | 16702 | 0 | 30.841465000000003 | 75.40879 | 2022-01-14 04:21:54 | Punjab, India | |||
3613012 | 3613012 | 2022-01-12 | India | Punjab | 636243 | 16702 | 0 | 30.841465000000003 | 75.40879 | 2022-01-13 08:00:09 | Punjab, India | |||
1113537 | 1113537 | 2022-01-11 | India | Punjab | 625347 | 16683 | 0 | 30.841465000000003 | 75.40879 | 2022-01-12 04:21:44 | Punjab, India | |||
1692265 | 1692265 | 2022-01-10 | India | Punjab | 625347 | 16683 | 0 | 30.841465000000003 | 75.40879 | 2022-01-11 04:22:01 | Punjab, India | |||
126680 | 126680 | 2022-01-09 | India | Punjab | 621419 | 16675 | 0 | 30.841465000000003 | 75.40879 | 2022-01-10 04:22:07 | Punjab, India | |||
1215515 | 1215515 | 2022-01-08 | India | Punjab | 617536 | 16665 | 0 | 30.841465000000003 | 75.40879 | 2022-01-09 04:21:46 | Punjab, India | |||
1389608 | 1389608 | 2022-01-07 | India | Punjab | 613976 | 16663 | 0 | 30.841465000000003 | 75.40879 | 2022-01-08 04:21:53 | Punjab, India | |||
2609995 | 2609995 | 2022-01-06 | India | Punjab | 611102 | 16662 | 0 | 30.841465000000003 | 75.40879 | 2022-01-07 04:22:09 | Punjab, India | |||
1281937 | 1281937 | 2022-01-05 | India | Punjab | 608723 | 16657 | 0 | 30.841465000000003 | 75.40879 | 2022-01-06 04:22:09 | Punjab, India | |||
1285953 | 1285953 | 2022-01-04 | India | Punjab | 606927 | 16653 | 0 | 30.841465000000003 | 75.40879 | 2022-01-05 04:21:59 | Punjab, India | |||
1700297 | 1700297 | 2022-01-03 | India | Punjab | 605922 | 16651 | 0 | 30.841465000000003 | 75.40879 | 2022-01-04 04:22:17 | Punjab, India | |||
3519380 | 3519380 | 2022-01-02 | India | Punjab | 605509 | 16648 | 0 | 30.841465000000003 | 75.40879 | 2022-01-03 02:22:25 | Punjab, India | |||
2167510 | 2167510 | 2022-01-01 | India | Punjab | 605126 | 16645 | 0 | 30.841465000000003 | 75.40879 | 2022-01-02 04:20:52 | Punjab, India | |||
2776941 | 2776941 | 2021-12-31 | India | Punjab | 604810 | 16645 | 0 | 30.841465000000003 | 75.40879 | 2022-01-01 04:22:14 | Punjab, India | |||
3998598 | 3998598 | 2021-12-30 | India | Punjab | 604594 | 16644 | 0 | 30.841465000000003 | 75.40879 | 2021-12-31 04:21:50 | Punjab, India | |||
1668405 | 1668405 | 2021-12-29 | India | Punjab | 604428 | 16644 | 0 | 30.841465000000003 | 75.40879 | 2021-12-30 04:21:25 | Punjab, India | |||
1432514 | 1432514 | 2021-12-28 | India | Punjab | 604331 | 16642 | 0 | 30.841465000000003 | 75.40879 | 2021-12-29 03:21:43 | Punjab, India | |||
730475 | 730475 | 2021-12-27 | India | Punjab | 604279 | 16640 | 0 | 30.841465000000003 | 75.40879 | 2021-12-28 04:21:47 | Punjab, India | |||
2111647 | 2111647 | 2021-12-26 | India | Punjab | 604236 | 16638 | 0 | 30.841465000000003 | 75.40879 | 2021-12-27 04:21:58 | Punjab, India | |||
3605019 | 3605019 | 2021-12-25 | India | Punjab | 604187 | 16637 | 0 | 30.841465000000003 | 75.40879 | 2021-12-26 04:21:50 | Punjab, India | |||
2963337 | 2963337 | 2021-12-24 | India | Punjab | 604133 | 16636 | 0 | 30.841465000000003 | 75.40879 | 2021-12-25 04:21:37 | Punjab, India | |||
3816369 | 3816369 | 2021-12-23 | India | Punjab | 604092 | 16636 | 0 | 30.841465000000003 | 75.40879 | 2021-12-24 04:21:34 | Punjab, India | |||
798377 | 798377 | 2021-12-22 | India | Punjab | 604058 | 16635 | 0 | 30.841465000000003 | 75.40879 | 2021-12-23 04:21:21 | Punjab, India | |||
3828417 | 3828417 | 2021-12-21 | India | Punjab | 604008 | 16633 | 0 | 30.841465000000003 | 75.40879 | 2021-12-22 04:21:54 | Punjab, India | |||
1254720 | 1254720 | 2021-12-20 | India | Punjab | 603986 | 16630 | 0 | 30.841465000000003 | 75.40879 | 2021-12-21 03:21:27 | Punjab, India | |||
2903663 | 2903663 | 2021-12-19 | India | Punjab | 603962 | 16629 | 0 | 30.841465000000003 | 75.40879 | 2021-12-20 04:21:43 | Punjab, India | |||
1258736 | 1258736 | 2021-12-18 | India | Punjab | 603892 | 16626 | 0 | 30.841465000000003 | 75.40879 | 2021-12-19 04:21:11 | Punjab, India | |||
2398764 | 2398764 | 2021-12-17 | India | Punjab | 603853 | 16625 | 0 | 30.841465000000003 | 75.40879 | 2021-12-18 02:22:20 | Punjab, India | |||
1716302 | 1716302 | 2021-12-16 | India | Punjab | 603853 | 16625 | 0 | 30.841465000000003 | 75.40879 | 2021-12-17 04:22:14 | Punjab, India | |||
3496136 | 3496136 | 2021-12-15 | India | Punjab | 603814 | 16623 | 0 | 30.841465000000003 | 75.40879 | 2021-12-16 04:22:11 | Punjab, India | |||
2087921 | 2087921 | 2021-12-14 | India | Punjab | 603780 | 16622 | 0 | 30.841465000000003 | 75.40879 | 2021-12-15 03:22:16 | Punjab, India | |||
782338 | 782338 | 2021-12-13 | India | Punjab | 603761 | 16620 | 0 | 30.841465000000003 | 75.40879 | 2021-12-14 04:22:38 | Punjab, India | |||
1660373 | 1660373 | 2021-12-12 | India | Punjab | 603739 | 16619 | 0 | 30.841465000000003 | 75.40879 | 2021-12-13 04:22:02 | Punjab, India | |||
1664389 | 1664389 | 2021-12-11 | India | Punjab | 603697 | 16618 | 0 | 30.841465000000003 | 75.40879 | 2021-12-12 04:22:12 | Punjab, India | |||
3655541 | 3655541 | 2021-12-10 | India | Punjab | 603674 | 16617 | 0 | 30.841465000000003 | 75.40879 | 2021-12-11 04:22:45 | Punjab, India | |||
1077872 | 1077872 | 2021-12-09 | India | Punjab | 603638 | 16616 | 0 | 30.841465000000003 | 75.40879 | 2021-12-10 04:22:28 | Punjab, India | |||
550721 | 550721 | 2021-12-08 | India | Punjab | 603578 | 16614 | 0 | 30.841465000000003 | 75.40879 | 2021-12-09 04:22:49 | Punjab, India | |||
404241 | 404241 | 2021-12-07 | India | Punjab | 603556 | 16612 | 0 | 30.841465000000003 | 75.40879 | 2021-12-08 04:22:46 | Punjab, India | |||
1030323 | 1030323 | 2021-12-06 | India | Punjab | 603509 | 16611 | 0 | 30.841465000000003 | 75.40879 | 2021-12-07 04:22:34 | Punjab, India | |||
1740486 | 1740486 | 2021-12-05 | India | Punjab | 603488 | 16608 | 0 | 30.841465000000003 | 75.40879 | 2021-12-06 04:22:34 | Punjab, India | |||
137918 | 137918 | 2021-12-04 | India | Punjab | 603410 | 16607 | 0 | 30.841465000000003 | 75.40879 | 2021-12-05 04:22:25 | Punjab, India | |||
2195571 | 2195571 | 2021-12-03 | India | Punjab | 603410 | 16607 | 0 | 30.841465000000003 | 75.40879 | 2021-12-04 04:22:18 | Punjab, India | |||
277 | 277 | 2021-12-02 | India | Punjab | 603352 | 16606 | 0 | 30.841465000000003 | 75.40879 | 2021-12-03 04:23:05 | Punjab, India | |||
1144876 | 1144876 | 2021-12-01 | India | Punjab | 603320 | 16605 | 0 | 30.841465000000003 | 75.40879 | 2021-12-02 04:22:37 | Punjab, India | |||
3401388 | 3401388 | 2021-11-30 | India | Punjab | 603279 | 16602 | 0 | 30.841465000000003 | 75.40879 | 2021-12-01 04:22:29 | Punjab, India | |||
149931 | 149931 | 2021-11-29 | India | Punjab | 603258 | 16599 | 0 | 30.841465000000003 | 75.40879 | 2021-11-30 04:22:53 | Punjab, India | |||
1231577 | 1231577 | 2021-11-28 | India | Punjab | 603240 | 16596 | 0 | 30.841465000000003 | 75.40879 | 2021-11-29 04:22:30 | Punjab, India | |||
1358284 | 1358284 | 2021-11-27 | India | Punjab | 603190 | 16593 | 0 | 30.841465000000003 | 75.40879 | 2021-11-28 04:22:43 | Punjab, India | |||
758275 | 758275 | 2021-11-26 | India | Punjab | 603173 | 16593 | 0 | 30.841465000000003 | 75.40879 | 2021-11-27 04:22:45 | Punjab, India | |||
1802692 | 1802692 | 2021-11-25 | India | Punjab | 603132 | 16591 | 0 | 30.841465000000003 | 75.40879 | 2021-11-26 04:22:33 | Punjab, India | |||
904126 | 904126 | 2021-11-24 | India | Punjab | 603095 | 16588 | 0 | 30.841465000000003 | 75.40879 | 2021-11-25 04:22:33 | Punjab, India | |||
3069976 | 3069976 | 2021-11-23 | India | Punjab | 603043 | 16587 | 0 | 30.841465000000003 | 75.40879 | 2021-11-24 04:22:14 | Punjab, India | |||
3749074 | 3749074 | 2021-11-22 | India | Punjab | 603002 | 16586 | 0 | 30.841465000000003 | 75.40879 | 2021-11-23 04:22:39 | Punjab, India | |||
1014281 | 1014281 | 2021-11-21 | India | Punjab | 602980 | 16584 | 0 | 30.841465000000003 | 75.40879 | 2021-11-22 04:22:20 | Punjab, India | |||
722445 | 722445 | 2021-11-20 | India | Punjab | 602956 | 16584 | 0 | 30.841465000000003 | 75.40879 | 2021-11-21 04:22:13 | Punjab, India | |||
161975 | 161975 | 2021-11-19 | India | Punjab | 602943 | 16580 | 0 | 30.841465000000003 | 75.40879 | 2021-11-20 04:22:17 | Punjab, India | |||
3288862 | 3288862 | 2021-11-18 | India | Punjab | 602906 | 16577 | 0 | 30.841465000000003 | 75.40879 | 2021-11-19 04:21:40 | Punjab, India | |||
447318 | 447318 | 2021-11-17 | India | Punjab | 602870 | 16575 | 0 | 30.841465000000003 | 75.40879 | 2021-11-18 04:21:33 | Punjab, India | |||
3342568 | 3342568 | 2021-11-16 | India | Punjab | 602833 | 16573 | 0 | 30.841465000000003 | 75.40879 | 2021-11-17 04:21:48 | Punjab, India | |||
2287404 | 2287404 | 2021-11-15 | India | Punjab | 602825 | 16573 | 0 | 30.841465000000003 | 75.40879 | 2021-11-16 04:21:10 | Punjab, India | |||
1322178 | 1322178 | 2021-11-14 | India | Punjab | 602795 | 16572 | 0 | 30.841465000000003 | 75.40879 | 2021-11-15 04:21:36 | Punjab, India | |||
686304 | 686304 | 2021-11-13 | India | Punjab | 602778 | 16571 | 0 | 30.841465000000003 | 75.40879 | 2021-11-14 04:21:31 | Punjab, India | |||
714413 | 714413 | 2021-11-12 | India | Punjab | 602733 | 16571 | 0 | 30.841465000000003 | 75.40879 | 2021-11-13 04:21:38 | Punjab, India | |||
28363 | 28363 | 2021-11-11 | India | Punjab | 602695 | 16570 | 0 | 30.841465000000003 | 75.40879 | 2021-11-12 04:22:01 | Punjab, India | |||
2844802 | 2844802 | 2021-11-10 | India | Punjab | 602647 | 16567 | 0 | 30.841465000000003 | 75.40879 | 2021-11-11 04:21:45 | Punjab, India | |||
87072 | 87072 | 2021-11-09 | India | Punjab | 602616 | 16566 | 0 | 30.841465000000003 | 75.40879 | 2021-11-10 04:21:38 | Punjab, India | |||
3639500 | 3639500 | 2021-11-08 | India | Punjab | 602584 | 16564 | 0 | 30.841465000000003 | 75.40879 | 2021-11-09 04:21:36 | Punjab, India | |||
2000608 | 2000608 | 2021-11-07 | India | Punjab | 602550 | 16564 | 0 | 30.841465000000003 | 75.40879 | 2021-11-08 04:21:43 | Punjab, India | |||
495599 | 495599 | 2021-11-06 | India | Punjab | 602517 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-07 04:21:53 | Punjab, India | |||
3121454 | 3121454 | 2021-11-05 | India | Punjab | 602496 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-06 04:21:51 | Punjab, India | |||
698352 | 698352 | 2021-11-04 | India | Punjab | 602466 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-05 04:21:54 | Punjab, India | |||
276130 | 276130 | 2021-11-03 | India | Punjab | 602466 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-04 04:22:20 | Punjab, India | |||
43655 | 43655 | 2021-11-02 | India | Punjab | 602434 | 16561 | 0 | 30.841465000000003 | 75.40879 | 2021-11-03 06:22:09 | Punjab, India | |||
3511351 | 3511351 | 2021-11-01 | India | Punjab | 602420 | 16560 | 0 | 30.841465000000003 | 75.40879 | 2021-11-02 04:22:03 | Punjab, India | |||
287943 | 287943 | 2021-10-31 | India | Punjab | 602401 | 16559 | 0 | 30.841465000000003 | 75.40879 | 2021-11-01 04:22:01 | Punjab, India | |||
2720949 | 2720949 | 2021-10-30 | India | Punjab | 602375 | 16558 | 0 | 30.841465000000003 | 75.40879 | 2021-10-31 04:22:08 | Punjab, India | |||
567051 | 567051 | 2021-10-29 | India | Punjab | 602349 | 16557 | 0 | 30.841465000000003 | 75.40879 | 2021-10-30 04:22:03 | Punjab, India | |||
4293 | 4293 | 2021-10-28 | India | Punjab | 602320 | 16556 | 0 | 30.841465000000003 | 75.40879 | 2021-10-29 04:22:03 | Punjab, India | |||
534683 | 534683 | 2021-10-27 | India | Punjab | 602289 | 16556 | 0 | 30.841465000000003 | 75.40879 | 2021-10-28 04:22:08 | Punjab, India | |||
3492120 | 3492120 | 2021-10-26 | India | Punjab | 602251 | 16554 | 0 | 30.841465000000003 | 75.40879 | 2021-10-27 04:22:32 | Punjab, India | |||
3793842 | 3793842 | 2021-10-25 | India | Punjab | 602238 | 16553 | 0 | 30.841465000000003 | 75.40879 | 2021-10-26 04:22:09 | Punjab, India | |||
682288 | 682288 | 2021-10-24 | India | Punjab | 602209 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-25 04:22:31 | Punjab, India | |||
770296 | 770296 | 2021-10-23 | India | Punjab | 602189 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-24 04:21:22 | Punjab, India | |||
653943 | 653943 | 2021-10-22 | India | Punjab | 602163 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-23 04:21:32 | Punjab, India | |||
2123690 | 2123690 | 2021-10-21 | India | Punjab | 602135 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-22 04:21:14 | Punjab, India | |||
443302 | 443302 | 2021-10-20 | India | Punjab | 602113 | 16550 | 0 | 30.841465000000003 | 75.40879 | 2021-10-21 04:21:18 | Punjab, India | |||
597621 | 597621 | 2021-10-19 | India | Punjab | 602081 | 16549 | 0 | 30.841465000000003 | 75.40879 | 2021-10-20 04:21:00 | Punjab, India | |||
2043798 | 2043798 | 2021-10-18 | India | Punjab | 602059 | 16544 | 0 | 30.841465000000003 | 75.40879 | 2021-10-19 04:20:54 | Punjab, India | |||
1909159 | 1909159 | 2021-10-17 | India | Punjab | 602035 | 16544 | 0 | 30.841465000000003 | 75.40879 | 2021-10-18 04:21:10 | Punjab, India | |||
934748 | 934748 | 2021-10-16 | India | Punjab | 602008 | 16541 | 0 | 30.841465000000003 | 75.40879 | 2021-10-17 04:21:29 | Punjab, India | |||
2943303 | 2943303 | 2021-10-15 | India | Punjab | 601992 | 16540 | 0 | 30.841465000000003 | 75.40879 | 2021-10-16 04:21:15 | Punjab, India | |||
491583 | 491583 | 2021-10-14 | India | Punjab | 601971 | 16538 | 0 | 30.841465000000003 | 75.40879 | 2021-10-15 04:21:26 | Punjab, India | |||
633871 | 633871 | 2021-10-13 | India | Punjab | 601938 | 16532 | 0 | 30.841465000000003 | 75.40879 | 2021-10-14 04:21:29 | Punjab, India | |||
1491549 | 1491549 | 2021-10-12 | India | Punjab | 601913 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-13 04:20:51 | Punjab, India | |||
3007282 | 3007282 | 2021-10-11 | India | Punjab | 601894 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-12 04:21:09 | Punjab, India | |||
423298 | 423298 | 2021-10-10 | India | Punjab | 601876 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-11 04:21:31 | Punjab, India | |||
2876155 | 2876155 | 2021-10-09 | India | Punjab | 601849 | 16529 | 0 | 30.841465000000003 | 75.40879 | 2021-10-10 04:21:38 | Punjab, India | |||
2959321 | 2959321 | 2021-10-08 | India | Punjab | 601821 | 16529 | 0 | 30.841465000000003 | 75.40879 | 2021-10-09 04:21:34 | Punjab, India | |||
467359 | 467359 | 2021-10-07 | India | Punjab | 601805 | 16526 | 0 | 30.841465000000003 | 75.40879 | 2021-10-08 04:21:25 | Punjab, India | |||
2458739 | 2458739 | 2021-10-06 | India | Punjab | 601782 | 16526 | 0 | 30.841465000000003 | 75.40879 | 2021-10-07 04:21:36 | 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]);