Update table language - Githubissues

awunderground commented 1 year ago

[X] ~(sent) (notes) (description) 1. Household income at the 20th, 50th, and 80th percentiles~ (Kevin Werner)
[X] ~(sent) (notes) (description) 2. Share of households with debt in collections~ (Jen Andre)
[X] ~(sent) (notes) (description) 3. Ratio of affordable and available housing units to households with low-, very low-, and extremely-low income levels~ (Kevin Werner)
[X] ~(sent) (notes) (description) 4. Number and share of public-school children who are ever homeless during the school year~ (Emily Gutierrez)
[X] ~(sent) (notes) (description) 5. Ratio of population per primary care physician~ (Vincent Pancini)
[X] ~(sent) (notes) (description) 6. Share of birthweights that are low~ (Julia Long)
[X] ~(sent) (notes) (description) 7. Share of voting-eligible population who turn out to vote~ (Vincent Pancini)
[X] ~(sent) (notes) (description) 8. Ratio of the share of local elected officials of a racial/ethnic group to the share of the same racial/ethnic group~ (Vincent Pancini)
[X] ~(sent) (notes) (description) 9. Poor residents living in high-poverty neighborhoods~ (Vincent Pancini)
[X] ~(sent) (notes) (description) 10. Neighborhood exposure index~ (Vincent Pancini)
[X] ~(sent) (notes) (description) 11. Transit trips index~ (Gabe Morrison)
[X] ~(sent) (notes) (description) 12. Low transportation cost index~ (Gabe Morrison)
[ ] (~sent~) (notes) (description) 13. Air quality index (Rebecca Marx)
[ ] (~sent~) (notes) (description) 14. Reported violent crime and property crime (Lily Robin)
[ ] (~sent~) (notes) (description) 15. Juvenile arrests (Lily Robin)
[X] ~(sent) (notes) (description) 16. Share of children enrolled in nursery school or preschool~ (Kevin Werner)
[X] ~(sent) (notes) (description) 17. Average per-grade change in ELA between 3rd and 8th grade~ (Emily Gutierrez)
[X] ~(sent) (notes) (description) 18. Share of students attending high poverty schools, by student race/ethnicity~ (Emily Gutierrez)
[X] ~(sent) (notes) (description) 19. Share of 19- and 20- year olds with a high school degree~ (Kevin Werner)
[X] ~(sent) (notes) (description) 20. Ratio of pay on the average job to the cost of living~ (Kevin Werner)
[X] ~(sent) (notes) (description) 21. Employment to population ratio for adults ages 25-54~ (Kevin Werner)
[ ] (~sent~) (notes) (description) 22. Share of households with broadband access in the home (Tina Chelidze)
[ ] (~sent~) (notes) (description) 23. Number of membership associations per 10,000 people (Tina Chelidze)
[ ] (~sent~) (notes) (description) 24. Ratio of higher socioeconomic status Facebook friends to friends of lower socioeconomic status (Tina Chelidze)
[ ] ~(sent) (notes) (description) 25. Number of deaths due to injury per 100,000 people~ (Vincent Pancini)
[X] ~(sent) (notes) (description) 26. Ratio of housing wealth owned by heads of households of a certain race to the number of heads of households of that race~ (Jung Choi)

awunderground commented 1 year ago

Link: https://urbanorg.box.com/s/5fnr5pq7owvuwyd2lx7ov1cvdgsvhmqt

cdsolari commented 1 year ago

General comments

[ ] The predictor header could link straight to the “visit here for more details” link? (2. YES BUT LATER)
- Aaron: is this too subtle? The links won't show up clearly and I think people may miss them.
[x] ~Inconsistent sizing of the county columns makes the alignment look off. Either fix sizing or center everything? (1. NO - this won't be an issue because we'll only have one location)~
[x] ~Summary and detail tabs don’t specify what year the data represents. Are users supposed to assume that the (Time Period: XX) in the source represents the time period for the data shown? I think it could be clearer. (1. NO - too much variation. The user will have to look at the source.)~
[x] ~Are the summary and detail tabs supposed to show the most recent year of data (usually 2021)? If so, noting that they currently show the older year of data (usually 2018) (3. NEED TO DO - Of course, this is the goal. I know we plan to do this already)~
- ~This is just because of the fake data. This will resolve itself when we have the real data!~
[x] ~Also, if the summary and detail tabs are supposed to show the most recent year of data, I think it makes more sense to show the most recent year first in the “more data” tab, and then the earlier years. Currently it’s the earlier years first and then the later years. (3. NEED TO DO - We always had the most recent year first. I think this will be more intuitive. I'd say we could do this later, but that would be more jarring to change for the viewer)~
[x] ~In cases where the “more data” tab doesn’t contain any additional years nor any disaggregations, it is exactly the same as the detail tab. Consider removing the “more data” tab in these cases? (e.g., facebook friends; membership associations) (3. NEED TO DO - I think we intended to do this. The only places where we shouldn't have a more data tab is: descriptive representation, social capital, ratio pop per primary care physician)~
- ~This was only an issue with the social capital metrics. Deleted!~
[x] ~There are inconsistencies between metrics for what order the racial/ethnic groups in the “more data” tab come in -- e.g., for share of students attending high-poverty schools, white comes first, whereas in a lot of other metrics white comes last. Consider standardizing. (2. YES BUT LATER - I think this is right, but this one is different because this is part of the main metric, rather than a subgroup)~
[x] ~Language for confidence interval notes between “additional notes” at the bottom and the notes used for each metric do not match (1. NO - this is appropriately phrased in the additional notes as a general statement. The not applicable vs not available is correct)~
[ ] Also pointing out again that we use “ratio” very inconsistently throughout. Sometimes ratios are represented as an actual ratio (x:y); sometimes as percentages (e.g. employment to population “ratio”); sometimes as fractions (e.g., “ratio” of pay to cost of living). I think this is confusing and we shouldn’t say ratio unless we are actually presenting things as ratios, but just leaving that here for y’all to consider (2. YES BUT LATER - agree and I am not sure we can fix right now. They aren't incorrect, it is just a bit confusing. Luckily, we have table notes to explain! That will have to do for now)
[x] ~Note that we updated the quality code to: Strong=1, Marginal=2 (same as before!), and Weak=3. (3. NEED TO DO)~
[x] ~The "Description" tab next to the "Home" tab gives me a file error when I click on it. Same is true when I click "here" to learn more about predictors. (3. NEED TO DO)~
[ ] Note that the clicking "here" will have us learn more about not just the predictors but also the metrics, so maybe we update that text to "Visit here for more details about this predictor and metric(s)". (2. YES BUT LATER)

Specific comments

[X] ~Number of homeless public school children, more data: notes say that disaggregated data became available in 2019-20, but we don’t show any disaggregated data. (3. NEED TO DO - we didn't have an example because only just became available and the metric isn't in main yet, but eventually we will need this :)).~
- ~This should fix itself when the real data are complete.~
- [ ] homeless students, more data: I'm sure this will also fix itself when real data are complete, but the years in the more data table where it says 2021 should have 2019. It will also have the 2019 data disaggregated by race, but not the 2018 data. This might be weird to program.
[x] ~Share of people in poverty, summary & detail: missing period after “American Community Survey” in source (2. YES BUT LATER - all the necessary information is there and it is not confusing.~
[x] ~Share of people in poverty, more data: Missing a opening quotation mark before Black in the second paragraph of the note; last sentence missing a word at the end -- “counted in both the ‘Hispanic’ and ‘Other Races and Ethnicities’ CATEGORIES.” (3. NEED TO DO - if it was just the quote, I wouldn't bother, but we are missing a word."~
[x] ~Still missing the above (for share of people in poverty in more data tab) to add the word "categories" at the end of the paragraph about "Those who identify as other race or multiple races and Hispanic are counted in both the 'Hispanic' and 'Other Races and Ethnicities' categories - with "categories" as the missing word. (3. NEED TO DO)~
[x] ~Facebook friends, summary/detail/more data: source for county should not include missouri geocorr (3. NEED TO DO - I think Aaron decided to fix these.)~
[x] ~Preschool, summary/detail: I think % enrolled makes more sense than % pre-kindergarten in the label; the metric for the Hawaii county is NA but quality is poor -- shouldn’t quality also be NA? (1. NO - I like % pre-k and this is how you'd see it in other venues to clarify what the enrollment is rather than a generic term)~
[x] ~English language, summary/detail/more data: missing period after the URL and bracket (2. YES BUT LATER - this doesn't substantively change the user's understanding)~
[x] ~English language, more data: table is repeated twice (1. NO - one is for race/eth and the other for poverty)~
[ ] English language: more data, the table-notes doc tried to distinguish notes added to the by race/eth vs the by low-income tables, and the notes for both race/eth + low income show up in both tables. This should be race/eth notes (w/o income) for that table and low-income notes (w/o race/eth) for the other table (2. YES BUT LATER)
- Yeah, this is a pain.
[X] ~English language, more data: This should get fixed with the final data, but the row years should be whatever Emily has, which is 2017 and 2016.~
[x] ~Students attending high-poverty schools, summary/detail/more data: first instance of “Urban Institute” in the source is misspelt (3. NEED TO DO - COMM will catch that anyway. I'd prefer to remove it because we cite Urban twice if we keep it. Keep the second one)~
[x] ~Broadband access, summary/detail: source is missing the PUMS/IPUMS detail; label would be better as “share” instead of “digital access” (3. NEED TO DO - this metric isn't finalized yet. But, from the code looks like it should be one year, but the more data tab should have variation by race/eth. We need to identify the use of 5-yr ACS for the 3rd tab and say via IPUMS. Looks like this note was incomplete.)~
[x] ~Broadband access: I know Aaron has been working with Tina on this, and the above may not longer be applicable. Also, this may be reviewed for showing by race/ethnicity. Just want to confirm if we will have that. If so, we still need a "More Data" tab. (3. NEED TO DO - but may be correct as is...depending on Aaron's review of Tina's work)~
[x] ~Pay to cost of living, summary/detail: missing period after 2021 in source (2. YES BUT LATER);~
[x] ~should 2021 for the living wage calculator source actually be 2022 given the note in the more data section? (1. NO - the source is 2022, but there's a note about deflating 2022 to be at 2021 levels)~
[x] ~pay to cost of living wage, summary/detail: the source still has living wage calculator 2021, but it should be 2022. The time period should stay 2021. Seems like the detail tab note should include the note in the More Data tab about the situation with that we were only able to access the 2022 living wage data for the 2021 metric and had to deflate it. (this is not marked well in the table-notes doc, so it didn't translate well here. So, in summary: (3. NEED TO DO) a). in summary, the source for MIT living wage calculator should be 2022 (not 2021) b). in detail, the source for MIT living wage calculator should be 2022 (not 2021). And, in the Notes, add this text "For the 2021 metric, we were only able to access the 2022 Living Wage data. We deflated the 2022 data to 2021 using the consumer price index (for all urban consumers), for a correct comparison with the 2021 QCEW."~
[x] ~Household income, summary/detail/more data: source for county should not include missouri geocorr (3. NEED TO DO - I think Aaron decided to fix these.)~
- ~Aaron: I'm pretty sure the PUMA-county crosswalk is from Geocorr and belongs here.~
[x] ~Debt, summary & detail: table notes document lists the county data source as 2018 & 2021 credit bureau data, not just 2021~
[x] ~Debt, summary & detail: also markdown hyperlink seems to be broken in all three tabs, looks like maybe there is an extraneous space? (3. NEED TO DO - this looks like years and sources are confused in the table-notes document. Need to revisit.)~
[x] ~Debt, summary & detail source for county are highlighted text in the table-notes doc. That county most recent year is 2022 (not 2021) (3. NEED TO DO)~
[x] ~Debt, summary & detail: the 3rd tab should read "More Data" instead of "Sub-Area" (3. NEED TO DO)~
[x] ~Housing wealth, summary & detail: source for county should not include missouri geocorr (3. NEED TO DO - I think Aaron decided to fix these.)~
- ~Aaron: I'm pretty sure the PUMA-county crosswalk is from Geocorr and belongs here.~
- ~Claudia: Good point, Aaron! I checked Jung's program and it does access a PUMA-county crosswalk.~
[x] ~NOTE: wealth-building metric row label of "Other Opportunity" is confusing. It needs to be "Other Race Opportunity" at a minimum, but it should ideally follow the labeling of that Other Race and Ethnicity category we've been using throughout. (3. NEED TO DO)~
[x] ~NOTE: wealth-building metric needs a 3rd tab of "More Data" because we have more years (2. YES BUT LATER - we have the years, but it isn't the end of all things if we miss this right now)~
[x] ~Primary care physician: the various labels contradict a bit. The title of the metric is “ratio of population per primary care physician” and the note says “ratio represents number of people served by one primary care physician,” but the label says “ratio of physicians to people” which suggests the opposite. Which is it? (3. NEED TO DO - fix the table row label to the numbers to read the "ratio of people to physicians")~
- ~NOTE: this metric isn't completed and is filled with dummy data, but the value will look more like "XXXX:1" (3. NEED TO DO)
[x] ~Air quality, sub-area: Shouldn’t the years be 2014 and 2018 here per the source data, not 2018 and 2021?~
[x] ~Air quality, sub-area: The line starting with ‘majority’ is repeated twice in the notes.~
[x] ~Air quality, sub-area: Also why is the tab here called “Sub-Area” instead of “More Data” like all the others? The table is also repeated twice in this tab (3. NEED TO DO - this should be fixed once we have real data. I think this is just place-holder. The table-notes are repetitive and need to be fixed, so we define "Majority" only once.)~
[x] ~Air quality, more data: I assume when the data are finalized, you'll show the 2014 year information as well. It isn't in there yet.~
- ~Yes~
[x] ~Elected officials: why is the category called “Asian and Other Races/Ethnicities” when all the other census categories are just “Other Races/Ethnicities”? (3. NEED TO FIX - this is correct, we should have it match. If we want to describe the Other Races/Ethnicities in the notes we can, but we should match the labels)~
[x] ~Elected officials: “The community will need to calculate THE missing percentageS in order to...“;~
[x] ~Elected officials: link to planning guide broken;~
[X] ~too many spaces after “how to calculate the missing percentage.” (2. YES BUT LATER - the link is there for copy/paste by the user. The missing percentage refers to the missing percentage in each cell.)~
[x] ~Elected officials had text in the Metric name that was italicized and needs to be updated. That should read "Ratio of the share of local elected officials of a racial or ethnic group to the share of residents of the same racial or ethnic group. Part of this metric is shown. See the notes for information on finalizing this metric." (3. NEED TO FIX)~
[x] ~neonatal: metric label should read "Share with low birth weight". (3. NEED TO FIX)~
[x] ~neonatal: row label should read "% Low birth weight" (3. NEED TO FIX)~
[x] ~Crime, detail: note should read: “Rates are calculated as the number of reported crimes against PROPERTY OR people per 100,000...” since it includes both violent and property crime (2. YES BUT LATER - it is generically referring to crimes because it applies to both figures).~
[x] ~Crime, more data: table notes document says that there is no disaggregation or additional years for either violent or property crimes, so should the more data tab exist for this metric? (3. NEED TO FIX - only show one year of data because even with past years, we shouldn't compare them.)~
[x] ~Juvenile arrests: table notes document suggests that there are disaggregations available for this metric, but there is no “more data” tab? (3. NEED TO FIX - we don't have final data yet and the older data wasn't available by race/eth. We will need a More Data tab to show current year by race for this metric)~
[x] ~Predictor is only Transportation access, we don't have a cost as a predictor, rather this predictor has two metrics (3. NEED TO DO)~
[x] ~Transportation cost index: the row label says "Transit cost" but this is transit & cars (as indicated in the note in the detail tab). I'd like this to be edited to "Transportation cost" or if that is too long, then "Transport cost" (3. NEED TO DO - because it is otherwise misleading and contradicts our own note)~
[x] ~transit trips: it is pulling in the wrong source information. It is still the old information. That means, we only have this metric for county. The source should read: "2016 Location Affordability Index data based on 2013-15 Illinois vehicle miles traveled data; Longitudinal Employer-Household Dynamics Origin-Destination Employment Statistics data, 2013 & 2014; US Census Bureau’s 2016 5-Year American Community Survey (via HUD AFFH data). (Time period: 2012-16)" We will have a More Data tab, only because we have by tract race/eth characteristics, but it will only have one year of data. We have no place data for this metric. Notes are accurate. (3. NEED TO DO)~
[x] ~transportation cost: same as above. The source should read: "2016 Location Affordability Index data based on 2013-15 Illinois vehicle miles traveled data; Longitudinal Employer-Household Dynamics Origin-Destination Employment Statistics data, 2013 & 2014; US Census Bureau’s 2016 5-Year American Community Survey (via HUD AFFH data). (Time period: 2012-16)" We will have a More Data tab, only because we have by tract race/eth characteristics, but it will only have one year of data. We have no place data for this metric. Notes are accurate. (3. NEED TO DO)~
[x] ~Trauma: the confidence interval is below the quality row and should be reversed (3. NEED TO DO)~
[ ] Employment to pop: You might have intended to do this, but "employed" in the table note is still not defined. Flagging just in case.

awunderground commented 1 year ago

I made many of the suggested edits in #181

cdsolari commented 1 year ago

Amazing work, Aaron! I can't believe you got through all of these! I did catch some things missed and added a few things I caught. If none of the other updates happen, that would be ok, but in advance of the Thursday meeting for the Gates leaders, it would be great if the "Description" tab worked, even if that information is old and not ordered properly. If not, we can work around it! Really great catches and amazing that you got through all of it! The other bonus would be getting rid of the Kalawao, HI site if we could, so we don't distract Gates! We can still explain that away if not :)

cdsolari commented 1 year ago

Ok! I got everything I could see! I keep seeing more things because I was just looking for whether or not you addressed Sam's comments, and then realizing that I needed to look for the table-notes found more. We will have some mistakes we can't see yet, but they should not be major at this point. My next steps are: 1. transfer Sam's catches into the table-notes-official document for places, and 2. gitbash to review the Description tab.

cdsolari commented 1 year ago

[x] ~facebook friends: The metric label should read: Metric: Ratio of Facebook friends with higher socioeconomic status to Facebook friends with lower socioeconomic status (“economic connectedness”)". It is missing the text in parentheses (2. YES BUT LATER- it is described in the notes in Detail tab)~
[x] ~Broadband access: once we do fix Broadband access, I think it should be "% Digital access" for the row label. I believe this is the format we will be sharing it in. (2. YES BUT LATER - I think when people see the figure is a percentage and when they read the note it should be clear~

UI-Research / gates-mobility-metrics-pages

Update table language #166

General comments

Specific comments