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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
978896 | 978896 | 2022-02-01 | India | Punjab | 745129 | 17292 | 0 | 30.841465000000003 | 75.40879 | 2022-02-02 04:21:09 | Punjab, India | |||
2657738 | 2657738 | 2022-01-31 | India | Punjab | 743532 | 17253 | 0 | 30.841465000000003 | 75.40879 | 2022-02-01 04:21:11 | Punjab, India | |||
3300155 | 3300155 | 2022-01-30 | India | Punjab | 741185 | 17214 | 0 | 30.841465000000003 | 75.40879 | 2022-01-31 04:21:09 | Punjab, India | |||
3061946 | 3061946 | 2022-01-29 | India | Punjab | 738405 | 17190 | 0 | 30.841465000000003 | 75.40879 | 2022-01-30 04:21:26 | Punjab, India | |||
3809880 | 3809880 | 2022-01-28 | India | Punjab | 735139 | 17159 | 0 | 30.841465000000003 | 75.40879 | 2022-01-29 04:21:10 | Punjab, India | |||
1779334 | 1779334 | 2022-01-27 | India | Punjab | 732135 | 17129 | 0 | 30.841465000000003 | 75.40879 | 2022-01-28 04:21:09 | Punjab, India | |||
1318162 | 1318162 | 2022-01-26 | India | Punjab | 728042 | 17081 | 0 | 30.841465000000003 | 75.40879 | 2022-01-27 04:21:19 | Punjab, India | |||
2051830 | 2051830 | 2022-01-25 | India | Punjab | 723052 | 17059 | 0 | 30.841465000000003 | 75.40879 | 2022-01-26 04:21:07 | Punjab, India | |||
1227561 | 1227561 | 2022-01-24 | India | Punjab | 719142 | 17023 | 0 | 30.841465000000003 | 75.40879 | 2022-01-25 04:21:05 | Punjab, India | |||
1140860 | 1140860 | 2022-01-23 | India | Punjab | 713445 | 16978 | 0 | 30.841465000000003 | 75.40879 | 2022-01-24 04:21:12 | Punjab, India | |||
2832778 | 2832778 | 2022-01-22 | India | Punjab | 707847 | 16948 | 0 | 30.841465000000003 | 75.40879 | 2022-01-23 04:21:13 | Punjab, India | |||
3424896 | 3424896 | 2022-01-21 | India | Punjab | 700222 | 16913 | 0 | 30.841465000000003 | 75.40879 | 2022-01-22 04:21:13 | Punjab, India | |||
1960504 | 1960504 | 2022-01-20 | India | Punjab | 692526 | 16882 | 0 | 30.841465000000003 | 75.40879 | 2022-01-21 04:21:09 | Punjab, India | |||
3226399 | 3226399 | 2022-01-19 | India | Punjab | 684664 | 16846 | 0 | 30.841465000000003 | 75.40879 | 2022-01-20 04:21:07 | Punjab, India | |||
3464124 | 3464124 | 2022-01-18 | India | Punjab | 676947 | 16817 | 0 | 30.841465000000003 | 75.40879 | 2022-01-19 04:21:23 | Punjab, India | |||
1472063 | 1472063 | 2022-01-17 | India | Punjab | 670460 | 16790 | 0 | 30.841465000000003 | 75.40879 | 2022-01-18 04:21:04 | Punjab, India | |||
554737 | 554737 | 2022-01-16 | India | Punjab | 663867 | 16769 | 0 | 30.841465000000003 | 75.40879 | 2022-01-17 04:21:08 | Punjab, India | |||
3840458 | 3840458 | 2022-01-15 | India | Punjab | 656549 | 16754 | 0 | 30.841465000000003 | 75.40879 | 2022-01-16 04:21:12 | Punjab, India | |||
99273 | 99273 | 2022-01-14 | India | Punjab | 649736 | 16731 | 0 | 30.841465000000003 | 75.40879 | 2022-01-15 04:21:07 | Punjab, India | |||
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 |
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]);