home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

22,854 rows where county = "San Francisco" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 75 22,854

county 1

  • San Francisco · 22,854 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1008 1008 94102 94102 2022-08-11 San Francisco 75 7330   31067
1009 1009 94103 94103 2022-08-11 San Francisco 75 7470   28735
1010 1010 94105 94105 2022-08-11 San Francisco 75 2487   9155
1011 1011 94107 94107 2022-08-11 San Francisco 75 6119   29689
1012 1012 94108 94108 2022-08-11 San Francisco 75 1852   14550
1013 1013 94109 94109 2022-08-11 San Francisco 75 9263   56677
1014 1014 94110 94110 2022-08-11 San Francisco 75 15031   94161
1015 1015 94111 94111 2022-08-11 San Francisco 75 686   3620
1016 1016 94112 94112 2022-08-11 San Francisco 75 19029   85166
1017 1017 94114 94114 2022-08-11 San Francisco 75 5021   34754
1018 1018 94115 94115 2022-08-11 San Francisco 75 6320   35004
1019 1019 94116 94116 2022-08-11 San Francisco 75 6594   47823
1020 1020 94117 94117 2022-08-11 San Francisco 75 6466   44239
1021 1021 94118 94118 2022-08-11 San Francisco 75 5803   41468
1022 1022 94121 94121 2022-08-11 San Francisco 75 6496   43795
1023 1023 94122 94122 2022-08-11 San Francisco 75 8322   62131
1024 1024 94123 94123 2022-08-11 San Francisco 75 3925   25941
1025 1025 94124 94124 2022-08-11 San Francisco 75 12439   35363
1026 1026 94127 94127 2022-08-11 San Francisco 75 3058   21423
1027 1027 94129 94129 2022-08-11 San Francisco 75 516   3994
1028 1028 94130 94130 2022-08-11 San Francisco 75 507   3064
1029 1029 94131 94131 2022-08-11 San Francisco 75 4463   29902
1030 1030 94132 94132 2022-08-11 San Francisco 75 4573   31488
1031 1031 94133 94133 2022-08-11 San Francisco 75 3873   26527
1032 1032 94134 94134 2022-08-11 San Francisco 75 10245   42471
1033 1033 94158 94158 2022-08-11 San Francisco 75 1988   7291
2279 2279 94102 94102 2022-08-10 San Francisco 75 7326   31067
2280 2280 94103 94103 2022-08-10 San Francisco 75 7467   28735
2281 2281 94105 94105 2022-08-10 San Francisco 75 2484   9155
2282 2282 94107 94107 2022-08-10 San Francisco 75 6116   29689
2283 2283 94108 94108 2022-08-10 San Francisco 75 1850   14550
2284 2284 94109 94109 2022-08-10 San Francisco 75 9258   56677
2285 2285 94110 94110 2022-08-10 San Francisco 75 15015   94161
2286 2286 94111 94111 2022-08-10 San Francisco 75 685   3620
2287 2287 94112 94112 2022-08-10 San Francisco 75 19019   85166
2288 2288 94114 94114 2022-08-10 San Francisco 75 5019   34754
2289 2289 94115 94115 2022-08-10 San Francisco 75 6316   35004
2290 2290 94116 94116 2022-08-10 San Francisco 75 6586   47823
2291 2291 94117 94117 2022-08-10 San Francisco 75 6465   44239
2292 2292 94118 94118 2022-08-10 San Francisco 75 5798   41468
2293 2293 94121 94121 2022-08-10 San Francisco 75 6493   43795
2294 2294 94122 94122 2022-08-10 San Francisco 75 8308   62131
2295 2295 94123 94123 2022-08-10 San Francisco 75 3923   25941
2296 2296 94124 94124 2022-08-10 San Francisco 75 12432   35363
2297 2297 94127 94127 2022-08-10 San Francisco 75 3054   21423
2298 2298 94129 94129 2022-08-10 San Francisco 75 515   3994
2299 2299 94130 94130 2022-08-10 San Francisco 75 507   3064
2300 2300 94131 94131 2022-08-10 San Francisco 75 4458   29902
2301 2301 94132 94132 2022-08-10 San Francisco 75 4569   31488
2302 2302 94133 94133 2022-08-10 San Francisco 75 3866   26527
2303 2303 94134 94134 2022-08-10 San Francisco 75 10238   42471
2304 2304 94158 94158 2022-08-10 San Francisco 75 1985   7291
3550 3550 94102 94102 2022-08-09 San Francisco 75 7317   31067
3551 3551 94103 94103 2022-08-09 San Francisco 75 7456   28735
3552 3552 94105 94105 2022-08-09 San Francisco 75 2483   9155
3553 3553 94107 94107 2022-08-09 San Francisco 75 6109   29689
3554 3554 94108 94108 2022-08-09 San Francisco 75 1849   14550
3555 3555 94109 94109 2022-08-09 San Francisco 75 9247   56677
3556 3556 94110 94110 2022-08-09 San Francisco 75 14999   94161
3557 3557 94111 94111 2022-08-09 San Francisco 75 685   3620
3558 3558 94112 94112 2022-08-09 San Francisco 75 18988   85166
3559 3559 94114 94114 2022-08-09 San Francisco 75 5017   34754
3560 3560 94115 94115 2022-08-09 San Francisco 75 6309   35004
3561 3561 94116 94116 2022-08-09 San Francisco 75 6575   47823
3562 3562 94117 94117 2022-08-09 San Francisco 75 6462   44239
3563 3563 94118 94118 2022-08-09 San Francisco 75 5792   41468
3564 3564 94121 94121 2022-08-09 San Francisco 75 6481   43795
3565 3565 94122 94122 2022-08-09 San Francisco 75 8293   62131
3566 3566 94123 94123 2022-08-09 San Francisco 75 3921   25941
3567 3567 94124 94124 2022-08-09 San Francisco 75 12418   35363
3568 3568 94127 94127 2022-08-09 San Francisco 75 3047   21423
3569 3569 94129 94129 2022-08-09 San Francisco 75 514   3994
3570 3570 94130 94130 2022-08-09 San Francisco 75 507   3064
3571 3571 94131 94131 2022-08-09 San Francisco 75 4455   29902
3572 3572 94132 94132 2022-08-09 San Francisco 75 4555   31488
3573 3573 94133 94133 2022-08-09 San Francisco 75 3861   26527
3574 3574 94134 94134 2022-08-09 San Francisco 75 10226   42471
3575 3575 94158 94158 2022-08-09 San Francisco 75 1984   7291
4821 4821 94102 94102 2022-08-08 San Francisco 75 7308   31067
4822 4822 94103 94103 2022-08-08 San Francisco 75 7446   28735
4823 4823 94105 94105 2022-08-08 San Francisco 75 2482   9155
4824 4824 94107 94107 2022-08-08 San Francisco 75 6099   29689
4825 4825 94108 94108 2022-08-08 San Francisco 75 1848   14550
4826 4826 94109 94109 2022-08-08 San Francisco 75 9237   56677
4827 4827 94110 94110 2022-08-08 San Francisco 75 14980   94161
4828 4828 94111 94111 2022-08-08 San Francisco 75 682   3620
4829 4829 94112 94112 2022-08-08 San Francisco 75 18960   85166
4830 4830 94114 94114 2022-08-08 San Francisco 75 5009   34754
4831 4831 94115 94115 2022-08-08 San Francisco 75 6302   35004
4832 4832 94116 94116 2022-08-08 San Francisco 75 6557   47823
4833 4833 94117 94117 2022-08-08 San Francisco 75 6457   44239
4834 4834 94118 94118 2022-08-08 San Francisco 75 5782   41468
4835 4835 94121 94121 2022-08-08 San Francisco 75 6461   43795
4836 4836 94122 94122 2022-08-08 San Francisco 75 8263   62131
4837 4837 94123 94123 2022-08-08 San Francisco 75 3917   25941
4838 4838 94124 94124 2022-08-08 San Francisco 75 12405   35363
4839 4839 94127 94127 2022-08-08 San Francisco 75 3040   21423
4840 4840 94129 94129 2022-08-08 San Francisco 75 514   3994
4841 4841 94130 94130 2022-08-08 San Francisco 75 505   3064
4842 4842 94131 94131 2022-08-08 San Francisco 75 4448   29902

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);
Powered by Datasette · Queries took 2120.925ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals