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 = "Gujarat" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435940 | 3435940 | 2020-07-11 | India | Gujarat | 40941 | 2032 | 28649 | 10260 | 22.694884 | 71.590923 | 2020-07-12 04:34:30 | Gujarat, India | ||
3237438 | 3237438 | 2020-07-10 | India | Gujarat | 40069 | 2022 | 28147 | 9900 | 22.694884 | 71.590923 | 2020-07-11 04:34:26 | Gujarat, India | ||
1005423 | 1005423 | 2020-07-09 | India | Gujarat | 39194 | 2008 | 27718 | 9468 | 22.694884 | 71.590923 | 2020-07-10 04:34:24 | Gujarat, India | ||
2222639 | 2222639 | 2020-07-08 | India | Gujarat | 38333 | 1993 | 27289 | 9051 | 22.694884 | 71.590923 | 2020-07-09 04:34:23 | Gujarat, India | ||
887248 | 887248 | 2020-07-07 | India | Gujarat | 37550 | 1977 | 26720 | 8853 | 22.694884 | 71.590923 | 2020-07-08 05:33:48 | Gujarat, India | ||
2684808 | 2684808 | 2020-07-06 | India | Gujarat | 36772 | 1960 | 26315 | 8497 | 22.694884 | 71.590923 | 2020-07-07 04:34:00 | Gujarat, India | ||
415273 | 415273 | 2020-07-05 | India | Gujarat | 36037 | 1943 | 25892 | 8202 | 22.694884 | 71.590923 | 2020-07-06 04:33:57 | Gujarat, India | ||
529835 | 529835 | 2020-07-04 | India | Gujarat | 35312 | 1925 | 25406 | 7981 | 22.694884 | 71.590923 | 2020-07-05 04:33:46 | Gujarat, India | ||
2234496 | 2234496 | 2020-07-03 | India | Gujarat | 34600 | 1904 | 24933 | 7763 | 22.694884 | 71.590923 | 2020-07-04 04:33:51 | Gujarat, India | ||
3045290 | 3045290 | 2020-07-02 | India | Gujarat | 33913 | 1886 | 24593 | 7434 | 22.694884 | 71.590923 | 2020-07-03 04:33:54 | Gujarat, India | ||
302981 | 302981 | 2020-07-01 | India | Gujarat | 33232 | 1867 | 24030 | 7335 | 22.694884 | 71.590923 | 2020-07-02 04:33:46 | Gujarat, India | ||
2974359 | 2974359 | 2020-06-30 | India | Gujarat | 32557 | 1846 | 23662 | 7049 | 22.694884 | 71.590923 | 2020-07-01 04:33:52 | Gujarat, India | ||
2632836 | 2632836 | 2020-06-29 | India | Gujarat | 31938 | 1827 | 23240 | 6871 | 22.694884 | 71.590923 | 2020-06-30 04:33:48 | Gujarat, India | ||
2306399 | 2306399 | 2020-06-28 | India | Gujarat | 31320 | 1808 | 22800 | 6712 | 22.694884 | 71.590923 | 2020-06-29 04:33:44 | Gujarat, India | ||
2039734 | 2039734 | 2020-06-27 | India | Gujarat | 30709 | 1789 | 22409 | 6511 | 22.694884 | 71.590923 | 2020-06-28 04:34:04 | Gujarat, India | ||
1136015 | 1136015 | 2020-06-26 | India | Gujarat | 30095 | 1771 | 22030 | 6294 | 22.694884 | 71.590923 | 2020-06-27 04:33:35 | Gujarat, India | ||
2625002 | 2625002 | 2020-06-25 | India | Gujarat | 29520 | 1753 | 21498 | 6269 | 22.694884 | 71.590923 | 2020-06-26 04:33:43 | Gujarat, India | ||
2700642 | 2700642 | 2020-06-24 | India | Gujarat | 28943 | 1735 | 21088 | 6120 | 22.694884 | 71.590923 | 2020-06-25 05:26:54 | Gujarat, India | ||
1522327 | 1522327 | 2020-06-23 | India | Gujarat | 28371 | 1710 | 20513 | 6148 | 22.694884 | 71.590923 | 2020-06-24 04:33:28 | Gujarat, India | ||
1510521 | 1510521 | 2020-06-22 | India | Gujarat | 27825 | 1684 | 19909 | 6232 | 22.694884 | 71.590923 | 2020-06-23 04:33:22 | Gujarat, India | ||
3249260 | 3249260 | 2020-06-21 | India | Gujarat | 27260 | 1663 | 19349 | 6248 | 22.694884 | 71.590923 | 2020-06-22 04:33:20 | Gujarat, India | ||
2437853 | 2437853 | 2020-06-20 | India | Gujarat | 26680 | 1638 | 18694 | 6348 | 22.694884 | 71.590923 | 2020-06-21 04:33:19 | Gujarat, India | ||
1691431 | 1691431 | 2020-06-19 | India | Gujarat | 26141 | 1618 | 18159 | 6364 | 22.694884 | 71.590923 | 2020-06-20 04:33:19 | Gujarat, India | ||
3682580 | 3682580 | 2020-06-18 | India | Gujarat | 25601 | 1591 | 17819 | 6191 | 22.694884 | 71.590923 | 2020-06-19 04:33:17 | Gujarat, India | ||
1195783 | 1195783 | 2020-06-17 | India | Gujarat | 25093 | 1560 | 17430 | 6103 | 22.694884 | 71.590923 | 2020-06-18 04:33:18 | Gujarat, India | ||
2386546 | 2386546 | 2020-06-16 | India | Gujarat | 24577 | 1533 | 17082 | 5962 | 22.694884 | 71.590923 | 2020-06-17 04:33:21 | Gujarat, India | ||
287109 | 287109 | 2020-06-15 | India | Gujarat | 24055 | 1505 | 16664 | 5886 | 22.694884 | 71.590923 | 2020-06-16 04:33:09 | Gujarat, India | ||
1837060 | 1837060 | 2020-06-14 | India | Gujarat | 23038 | 1448 | 15883 | 5707 | 22.694884 | 71.590923 | 2020-06-15 03:33:14 | Gujarat, India | ||
3061112 | 3061112 | 2020-06-13 | India | Gujarat | 22527 | 1415 | 15493 | 5619 | 22.694884 | 71.590923 | 2020-06-14 03:33:15 | Gujarat, India | ||
737432 | 737432 | 2020-06-12 | India | Gujarat | 22032 | 1385 | 15101 | 5546 | 22.694884 | 71.590923 | 2020-06-13 03:33:14 | Gujarat, India | ||
1273402 | 1273402 | 2020-06-11 | India | Gujarat | 22032 | 1385 | 15101 | 5546 | 22.694884 | 71.590923 | 2020-06-12 05:09:52 | Gujarat, India | ||
2863845 | 2863845 | 2020-06-10 | India | Gujarat | 21014 | 1313 | 14365 | 5336 | 22.694884 | 71.590923 | 2020-06-11 03:33:41 | Gujarat, 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]);