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 = "Rajasthan" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436149 | 3436149 | 2020-07-11 | India | Rajasthan | 23748 | 503 | 17869 | 5376 | 26.583423 | 73.847973 | 2020-07-12 04:34:30 | Rajasthan, India | ||
3237647 | 3237647 | 2020-07-10 | India | Rajasthan | 23174 | 497 | 17620 | 5057 | 26.583423 | 73.847973 | 2020-07-11 04:34:26 | Rajasthan, India | ||
1005632 | 1005632 | 2020-07-09 | India | Rajasthan | 22563 | 491 | 17070 | 5002 | 26.583423 | 73.847973 | 2020-07-10 04:34:24 | Rajasthan, India | ||
2222848 | 2222848 | 2020-07-08 | India | Rajasthan | 22063 | 482 | 16866 | 4715 | 26.583423 | 73.847973 | 2020-07-09 04:34:23 | Rajasthan, India | ||
887457 | 887457 | 2020-07-07 | India | Rajasthan | 21404 | 472 | 16575 | 4357 | 26.583423 | 73.847973 | 2020-07-08 05:33:48 | Rajasthan, India | ||
2685017 | 2685017 | 2020-07-06 | India | Rajasthan | 20688 | 461 | 16278 | 3949 | 26.583423 | 73.847973 | 2020-07-07 04:34:00 | Rajasthan, India | ||
415482 | 415482 | 2020-07-05 | India | Rajasthan | 20164 | 456 | 15928 | 3780 | 26.583423 | 73.847973 | 2020-07-06 04:33:57 | Rajasthan, India | ||
530044 | 530044 | 2020-07-04 | India | Rajasthan | 19532 | 447 | 15640 | 3445 | 26.583423 | 73.847973 | 2020-07-05 04:33:46 | Rajasthan, India | ||
2234705 | 2234705 | 2020-07-03 | India | Rajasthan | 19052 | 440 | 15281 | 3331 | 26.583423 | 73.847973 | 2020-07-04 04:33:51 | Rajasthan, India | ||
3045499 | 3045499 | 2020-07-02 | India | Rajasthan | 18662 | 430 | 14948 | 3284 | 26.583423 | 73.847973 | 2020-07-03 04:33:54 | Rajasthan, India | ||
303190 | 303190 | 2020-07-01 | India | Rajasthan | 18312 | 421 | 14574 | 3317 | 26.583423 | 73.847973 | 2020-07-02 04:33:46 | Rajasthan, India | ||
2974568 | 2974568 | 2020-06-30 | India | Rajasthan | 18014 | 413 | 14220 | 3381 | 26.583423 | 73.847973 | 2020-07-01 04:33:52 | Rajasthan, India | ||
2633045 | 2633045 | 2020-06-29 | India | Rajasthan | 17660 | 405 | 13618 | 3637 | 26.583423 | 73.847973 | 2020-06-30 04:33:48 | Rajasthan, India | ||
2306608 | 2306608 | 2020-06-28 | India | Rajasthan | 17271 | 399 | 13611 | 3261 | 26.583423 | 73.847973 | 2020-06-29 04:33:44 | Rajasthan, India | ||
2039943 | 2039943 | 2020-06-27 | India | Rajasthan | 16944 | 391 | 13367 | 3186 | 26.583423 | 73.847973 | 2020-06-28 04:34:04 | Rajasthan, India | ||
1136224 | 1136224 | 2020-06-26 | India | Rajasthan | 16660 | 380 | 13062 | 3218 | 26.583423 | 73.847973 | 2020-06-27 04:33:35 | Rajasthan, India | ||
2625211 | 2625211 | 2020-06-25 | India | Rajasthan | 16296 | 379 | 12840 | 3077 | 26.583423 | 73.847973 | 2020-06-26 04:33:43 | Rajasthan, India | ||
2700851 | 2700851 | 2020-06-24 | India | Rajasthan | 16009 | 375 | 12611 | 3023 | 26.583423 | 73.847973 | 2020-06-25 05:26:54 | Rajasthan, India | ||
1522536 | 1522536 | 2020-06-23 | India | Rajasthan | 15627 | 365 | 12213 | 3049 | 26.583423 | 73.847973 | 2020-06-24 04:33:28 | Rajasthan, India | ||
1510730 | 1510730 | 2020-06-22 | India | Rajasthan | 15232 | 356 | 11910 | 2966 | 26.583423 | 73.847973 | 2020-06-23 04:33:22 | Rajasthan, India | ||
3249469 | 3249469 | 2020-06-21 | India | Rajasthan | 14930 | 349 | 11597 | 2984 | 26.583423 | 73.847973 | 2020-06-22 04:33:20 | Rajasthan, India | ||
2438062 | 2438062 | 2020-06-20 | India | Rajasthan | 14536 | 337 | 11274 | 2925 | 26.583423 | 73.847973 | 2020-06-21 04:33:19 | Rajasthan, India | ||
1691640 | 1691640 | 2020-06-19 | India | Rajasthan | 14156 | 333 | 10997 | 2826 | 26.583423 | 73.847973 | 2020-06-20 04:33:19 | Rajasthan, India | ||
3682789 | 3682789 | 2020-06-18 | India | Rajasthan | 13857 | 323 | 10742 | 2792 | 26.583423 | 73.847973 | 2020-06-19 04:33:17 | Rajasthan, India | ||
1195992 | 1195992 | 2020-06-17 | India | Rajasthan | 13542 | 313 | 10467 | 2762 | 26.583423 | 73.847973 | 2020-06-18 04:33:18 | Rajasthan, India | ||
2386755 | 2386755 | 2020-06-16 | India | Rajasthan | 13216 | 308 | 9849 | 3059 | 26.583423 | 73.847973 | 2020-06-17 04:33:21 | Rajasthan, India | ||
287318 | 287318 | 2020-06-15 | India | Rajasthan | 12981 | 301 | 9785 | 2895 | 26.583423 | 73.847973 | 2020-06-16 04:33:09 | Rajasthan, India | ||
1837269 | 1837269 | 2020-06-14 | India | Rajasthan | 12401 | 282 | 9337 | 2782 | 26.583423 | 73.847973 | 2020-06-15 03:33:14 | Rajasthan, India | ||
3061321 | 3061321 | 2020-06-13 | India | Rajasthan | 12068 | 272 | 8898 | 2898 | 26.583423 | 73.847973 | 2020-06-14 03:33:15 | Rajasthan, India | ||
737641 | 737641 | 2020-06-12 | India | Rajasthan | 11838 | 265 | 8775 | 2798 | 26.583423 | 73.847973 | 2020-06-13 03:33:14 | Rajasthan, India | ||
1273611 | 1273611 | 2020-06-11 | India | Rajasthan | 11838 | 265 | 8775 | 2798 | 26.583423 | 73.847973 | 2020-06-12 05:09:52 | Rajasthan, India | ||
2864053 | 2864053 | 2020-06-10 | India | Rajasthan | 11245 | 255 | 8328 | 2662 | 26.583423 | 73.847973 | 2020-06-11 03:33:41 | Rajasthan, 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]);