Lecture 5 - Communicating


Topics in Econometrics - M2 ENS Lyon

Vincent Bagilet

2026-09-30

Graphs and tables, not so simple

  • Key to produce credible estimates but only worth it if we communicate them properly

  • Graphs and tables are everywhere in economics

  • They are often the result of analyses

  • Readers often start looking at graphs and tables

  • Seems pretty simple, we all know how to make graphs and tables

  • Sure BUT handled carelessly a graph can be inefficient and even misleading

  • Once you pay attention to data viz, it is fun, instructive and satisfying!

Many graph types

Trying to go beyond the obvious

  • I will probably state obvious stuff BUT

    • Maybe still good to hear it sometimes
    • I will provide references to explore all this in more details
    • I will try to structure and conceptualize
  • Objectives of the class:

    • Provide tools to nail your data viz and your tables
    • Communicate that how you present results matters and provide a conceptual lens

Outline

  • Why good data viz matters?

  • What are the characteristics of good data viz?

  • How to make an ok data viz?

  • Communicating in economics

  • Main take-away points

Why good data viz matters?

What do we use data viz for?

Usefulness of data viz, overall

  • Allows to synthesize large amounts of information into a limited space (that also applies to tables)

  • Ease interpretation (reduce the cognitive load)

  • For your audience to not only receive info but also understand and remember it

Synthetic and memorable

Yearly fluctuations in area of Arctic covered by ice

Several uses of data viz


Graphs to explore


  • Analyze
  • Confirm


Graphs to explain


  • Inform
  • Convince


Graphs for inference


  • Econ specific



They have different goals and audiences

Adapting graphs to the audience

  • Which potential audiences?

    • Peers, economists: can use complex but familiar types of graphs
    • Non-economists: think about how they are
    • You today: super quick but with basic labels
    • Future you: still need to be able to remember what the graph is about 6 months later

Different levels of polishing

  • Graphs for you (and your future self): can be quite rough on the edges, but you will want to be able to understand it in the future

  • For presentations: you have some leeway for explaining orally your graphs

  • For the paper: there is only a couple of graphs in a paper; make them perfect!

Explore: make sense of your data


  • Data viz helps a lot to identify patterns in data

  • That’s the role of the exploratory data analysis (EDA)

  • It may help to:

    • Understand what is your data and in your data
    • Spot issues in your data
    • Formulate hypotheses (to test on other data sets)
    • Assess the relevance of some key assumptions

Rule

Always look at your raw data

Look at your raw data

  • eg might be helpful to evaluate your modeling assumptions
  • Spot outliers driving your results

Explain: get your point across





  • A data viz can be much clearer than a table (not always)
  • Can help focus on one specific point
  • Convey a story

Why make good data viz?

Data viz can be obviously deceptive

…or difficult to interpret


The power of data viz


*We can easily see patterns presented in certain ways, but if they are presented in other ways, they become invisible [..]

Following perception-based rules, we can present our data in such a way that the important and informative patterns stand out. If we disobey the rules, our data will be incomprehensible or misleading.


Ware, C. (2012). Information Visualization, Third Edition: Perception for Design

  • Charts can be wrong. They can also be correct BUT misleading1
  • Be mindful of this power when make and read graphs

Cutting 0 on the y-axis

Map projections distort the reality




Data viz and credibility


“This paper did not receive the care it deserved” comment given to a now senior researcher when they submitted a paper with a sketchy graph

Credibility and aesthetics

Graph aesthetics

  • Beyond credibility, why make nice looking visualizations?

  • To trigger interest, to intrigue, to catch the eye

  • That affects how people perceive information

  • Nice looking visuals may be more memorable

  • They can help engage the audience

  • Pretty does not always mean non-simple. Simple graphs have value.

  • In academia, maybe better to keep the design rather minimalist

Pretty and memorable

Engaging the audience

What are the characteristics of good data viz?

Tell a story

Which story?


  • Stories resonate with us, humans

  • What do you want to show in your graph?

  • What is the message you want to convey?

  • Again, you do not want your audience to receive info, you want them to understand and remember your message


Important

Clearly stating the message you want to convey is the first and most important step of a successful visualization

1 dataset, many stories, many graphs

  • With the same data, you can:

    • Tell a lot of different stories

    • Emphasize different points

  • Making a graph = choosing a lighting for your data

  • The type of graph you choose matters and depends on your story

Cognitive load

A guiding principle



A rough definition

How easy or difficult it is to parse new information


  • Often want to decrease the cognitive load (particularly for academia)

  • Can often use this a guide for making our data visualization

  • As all rules, it is meant to be broken

Different types of cognitive loads

  • Intrinsic load: inherent complexity of the information

    • eg, 3/7 more difficult to compute than 3 + 7
  • Germane load: how familiar is the audience with the new information

    • eg, box plots, coefficient plots might be difficult to understand without prior experience
  • Extraneous load: how the new information is presented

    • eg, horizontal text, highlight important data points, annotate, etc

Data viz theory

Importance of theory

  • There is actually a lot of theory behind data viz:

    • Perception,
    • Colors,
    • Design,
    • etc
  • Can relate to cognitive load

  • But can also leverage it to make better data viz

  • Worth learning about it and being aware of key principles

Gestalt principles



  • How our brain interprets what we see

  • How it organize visual information

  • How we group elements together

  • Use them to highlight some patterns and downplay others

Data-to-ink ratio




  • Introduced by Edward Tufte

  • In a nutshell: avoid clutter

  • Erase non-essential and redundant information

  • “Above all else show the data”

  • Somehow “reduce the cognitive load”

Data-to-ink ratio


\(\text{data-ink ratio} = \dfrac{\text{data ink}}{\text{total ink on graph}}\)


How to make an ok data viz?

Non-negotiable rules

Example data

country year lifeExp
France 1952 67.410
France 1957 68.930
France 1962 70.510
France 1967 71.550
France 1972 72.380
France 1977 73.830
France 1982 74.890
France 1987 76.340
France 1992 77.460
France 1997 78.640
France 2002 79.590
France 2007 80.657
Japan 1952 63.030
Japan 1957 65.500
Japan 1962 68.730
Japan 1967 71.430
Japan 1972 73.420
Japan 1977 75.380
Japan 1982 77.110
Japan 1987 78.670
Japan 1992 79.360
Japan 1997 80.690
Japan 2002 82.000
Japan 2007 82.603
Niger 1952 37.444
Niger 1957 38.598
Niger 1962 39.487
Niger 1967 40.118
Niger 1972 40.546
Niger 1977 41.291
Niger 1982 42.598
Niger 1987 44.555
Niger 1992 47.391
Niger 1997 51.313
Niger 2002 54.496
Niger 2007 56.867

A concrete example

Legible text

Title, clear axis labels and source

Graphs in an oral presentation

  • Explain orally what your graph represents!

    • What is on the x-axis?

    • What is on the y-axis?

    • What is the message you want to convey?

Avoid low contrast

Good practice

Stylize

Limited number of guides break

Export graphs in PDF (vectorized)

An informative title

Think about the scale of the y-axis

An alternative story

Avoid using many different colors


If need more than 7 colors or so:


  • Use another graph

  • Group categories together

Use intuitive colors

Colorblind-friendly visualizations

Diverging color scale (vs sequential)

Use gray. Emphasize.

Label directly

Horizontal text

Order your data

Data viz caveats

Sometimes you may break the rules




9 colors


BUT


  • Labeled directly
  • Shade reinforces grouping

Choosing a type of graph

Know what chart types exist

Type of relationship to show



In your graph, you may want to show a:


  • Distribution
  • Evolution over time
  • Magnitude
  • Part of a whole
  • Ranking
  • Geographical patterns
  • Flow
  • Correlations
  • Deviation

Graph type decision tree

Pay attention to good data viz

  • If you start paying attention to data viz when you see them, you will see what works, what does not

  • It is a process that takes place in the “background”: you will learn quickly and not realize it

  • You will see nice looking graphs (and hopefully enjoy it)

  • You will build better and more impactful graphs

“Originality” VS “familiarity”

  • Original graphs may trigger interest

  • Familiar graphs may convey the point more easily

  • My take:

    • Use the best type of graph, regardless of its originality/familiarity

    • If it is different from what people are used to, make it easy to read

Communicating in economics

Specificities of communicating in economics

  • Often have a specific type of output: estimation results

  • There are norms for tables, in particular: deviating from them is costly

  • And a massive number of observations

  • Our analyses rest on identifying assumptions \(\to\) can explore with graphs and tables

  • We often use very complex models. Visualization can help understand what we are actually estimating

Graphs and tables in economics

When do we use them in econ?

  • As rhetorical visualization tools for models

  • To explore our data

  • To check the validity of our models and assumptions

  • As diagnostics

  • To communicate results

Rhetorical tool: FEs

Rhetorical tool: models


Example

  • We will run a simple analysis:

    • Link between jail sentences for drunk driving and traffic deaths?
  • At each step, we ask the same two questions:

    • Which graph helps here?
    • Which table helps here?
  • Side goal: provide practical tips to make these tables and graphs (eg chunks of code, packages, etc)

Setting of the running example

state year spirits unemp income emppop beertax baptist mormon drinkage dry youngdrivers miles breath jail service fatal nfatal sfatal fatal1517 nfatal1517 fatal1820 nfatal1820 fatal2124 nfatal2124 afatal pop pop1517 pop1820 pop2124 milestot unempus emppopus gsp
al 1982 1.37 14.4 10544.152 50.69204 1.5393795 30.35570 0.328290 19.00 25.006300 0.211572 7233.887 no no no 839 146 99 53 9 99 34 120 32 309.438 3942002.2 208999.59 221553.44 290000.06 28516 9.7 57.8 -0.0221248
al 1983 1.36 13.7 10732.798 52.14703 1.7889907 30.33360 0.343410 19.00 22.994200 0.210768 7836.348 no no no 930 154 98 71 8 108 26 124 35 341.834 3960008.0 202000.08 219125.47 290000.16 31032 9.6 57.9 0.0465583
al 1984 1.32 11.1 11108.791 54.16809 1.7142856 30.31150 0.359240 19.00 24.042601 0.211484 8262.990 no no no 932 165 94 49 7 103 25 118 34 304.872 3988991.8 196999.97 216724.09 288000.16 32961 7.5 59.5 0.0627978
al 1985 1.28 8.9 11332.627 55.27114 1.6525424 30.28950 0.375790 19.67 23.633900 0.211140 8726.917 no no no 882 146 98 66 9 100 23 114 45 276.742 4021007.8 194999.73 214349.03 284000.31 35091 7.2 60.1 0.0274900
al 1986 1.23 9.8 11661.507 56.51450 1.6099070 30.26740 0.393110 21.00 23.464701 0.213400 8952.854 no no no 1081 172 119 82 10 120 23 119 29 360.716 4049993.8 203999.89 212000.00 263000.28 36259 7.0 60.7 0.0321429
al 1987 1.18 7.8 11944.000 57.50988 1.5599999 30.24530 0.411230 21.00 23.792400 0.215527 9166.302 no no no 1110 181 114 94 11 127 31 138 30 368.421 4082999.0 204999.81 208998.45 258999.77 37426 6.2 61.5 0.0489764
al 1988 1.17 7.2 12368.624 56.83453 1.5014436 30.22330 0.430180 21.00 23.792400 0.218328 9674.323 no no no 1023 139 89 66 8 105 24 123 25 298.322 4101992.2 201000.12 193000.52 262999.78 39684 5.5 62.3 0.0353918
az 1982 1.97 9.9 12309.069 56.89330 0.2147971 3.95890 4.919100 19.00 0.000000 0.209012 6810.157 no yes yes 724 131 76 40 7 81 16 96 36 173.668 2896996.5 140999.98 156378.70 217999.98 19729 9.7 57.8 -0.0431819
az 1983 1.90 9.1 12693.808 57.55363 0.2064220 3.89010 4.831070 19.00 0.000000 0.203855 6587.495 no yes yes 675 112 60 40 7 83 19 80 17 196.890 2977004.2 138999.89 157521.44 218999.89 19611 9.6 57.9 0.0762055
az 1984 2.14 5.0 13265.934 60.37902 0.2967033 3.82260 4.744610 19.00 0.000000 0.209127 6709.970 no yes yes 869 149 81 51 8 118 34 123 33 212.361 3071995.8 138000.08 158672.53 219999.97 20613 7.5 59.5 0.1062140
az 1985 1.86 6.5 13726.695 58.64853 0.3813559 3.75620 4.659710 21.00 0.000000 0.188428 6771.263 no yes yes 893 150 75 48 11 100 26 121 30 225.824 3186998.0 140000.06 159832.03 220000.00 21580 7.2 60.1 0.0781956
az 1986 1.78 6.9 14107.327 60.28018 0.3715170 3.69100 4.576320 21.00 0.000000 0.171539 8129.008 no yes yes 1007 173 85 72 19 104 30 130 25 242.827 3278998.0 148000.14 161000.00 210999.91 26655 7.0 60.7 0.0677125
az 1987 1.72 6.2 14241.000 60.21506 0.3600000 3.62690 4.494420 21.00 0.000000 0.168724 9370.654 no yes yes 937 172 87 50 16 99 25 121 34 241.780 3385996.2 149000.22 162000.30 211999.91 31729 6.2 61.5 0.0641113
az 1988 1.68 6.3 14408.085 60.49767 0.3464870 3.56400 4.413990 21.00 0.000000 0.161005 9815.721 no yes yes 944 136 67 54 14 100 14 116 31 238.234 3488995.0 147999.94 157000.66 218000.05 34247 5.5 62.3 0.0265678
ar 1982 1.19 9.8 10267.303 54.47586 0.6503580 22.96720 0.328290 21.00 36.712799 0.204903 7208.500 no no no 550 102 64 36 5 62 24 61 18 271.459 2306998.5 121999.99 121269.50 157000.02 16630 9.7 57.8 -0.0347338
ar 1983 1.20 10.1 10433.486 53.81479 0.6754587 23.00090 0.343410 21.00 36.430099 0.194169 7175.917 no no no 557 88 47 35 2 65 19 73 22 247.857 2324999.0 118000.07 120698.10 159000.17 16684 9.6 57.9 0.0401444
ar 1984 1.22 8.9 10916.483 54.67128 0.5989011 23.03460 0.359240 21.00 36.104000 0.186380 7084.820 no no no 525 81 48 34 2 72 24 67 18 182.707 2346001.8 115000.07 120129.39 162000.09 16621 7.5 59.5 0.0835973
ar 1985 1.12 8.7 11149.364 54.97712 0.5773305 23.06840 0.375790 21.00 35.904999 0.189292 7253.918 no no no 534 73 43 45 7 56 13 57 19 198.154 2359001.0 113000.02 119563.37 161000.12 17112 7.2 60.1 0.0046022
ar 1986 0.92 8.7 11399.381 55.56186 0.5624355 23.10220 0.393110 21.00 39.569599 0.161957 7468.999 no no no 603 108 67 48 7 66 22 78 22 237.517 2371000.5 115000.08 119000.00 145000.02 17709 7.0 60.7 0.0297692
ar 1987 1.01 8.1 11537.000 56.33089 0.5450000 23.13610 0.411230 21.00 39.287899 0.164132 7665.831 no no no 639 110 61 58 15 72 19 65 17 221.905 2387999.5 115999.99 117000.88 142000.14 18306 6.2 61.5 0.0019300
ar 1988 0.99 7.7 11760.347 57.36695 0.5245429 23.17000 0.430180 21.00 39.287899 0.167541 8024.625 no no no 610 86 55 41 6 61 16 69 21 208.850 2395002.8 114000.03 109999.10 145999.92 19219 5.5 62.3 0.0337335
ca 1982 2.21 9.9 15797.136 59.51593 0.1073986 1.72310 1.678540 21.00 0.000000 0.190196 6858.677 no no no 4615 944 553 241 61 567 161 758 249 1379.130 24785976.0 1157001.75 1321004.38 1892998.12 169999 9.7 57.8 -0.0116860
ca 1983 2.15 9.7 15970.184 59.25233 0.1032110 1.73470 1.667920 21.00 0.000000 0.183569 7216.292 no no no 4573 856 487 232 39 513 141 702 206 1251.600 25311062.0 1126000.50 1309863.12 1886001.75 182652 9.6 57.9 0.0530367
ca 1984 2.07 7.8 16590.109 60.69826 0.0989011 1.74640 1.657360 21.00 0.000000 0.174131 7619.176 no no no 5020 957 559 267 68 593 177 770 215 1421.820 25795048.0 1104999.88 1298815.88 1873999.12 196537 7.5 59.5 0.0724610
ca 1985 1.97 7.2 16985.170 61.33171 0.0953390 1.75820 1.646870 21.00 0.000000 0.167896 7874.067 no no no 4960 887 499 302 65 545 139 762 226 1243.920 26365028.0 1106000.25 1287861.75 1854998.50 207600 7.2 60.1 0.0483305
ca 1986 1.85 6.7 17356.037 62.00847 0.0928793 1.77010 1.636440 21.00 0.000000 0.164371 8034.910 no no no 5253 880 510 318 62 571 141 757 185 1309.910 27001048.0 1172000.25 1277000.00 1766998.88 216951 7.0 60.7 0.0466814
ca 1987 1.78 5.8 17846.000 63.07429 0.0900000 1.78210 1.626080 21.00 0.000000 0.160682 8180.633 no no no 5504 944 531 302 50 601 137 717 199 1431.570 27663018.0 1163001.25 1268012.75 1753999.75 226301 6.2 61.5 0.0697363
ca 1988 1.72 5.3 18049.086 63.78366 0.0866218 1.79410 1.615780 21.00 0.000000 0.148684 8531.990 no NA NA 5390 936 541 246 48 583 144 702 197 1246.710 28314028.0 1126998.00 1227988.88 1770000.75 241575 5.5 62.3 0.0490204
co 1982 2.25 7.7 15082.339 64.96674 0.2147971 2.30000 1.823010 21.00 0.113151 0.229148 7742.842 no no yes 668 140 96 27 5 91 36 100 35 219.750 3071998.8 143000.14 169956.84 246000.05 23786 9.7 57.8 0.0120430
co 1983 2.15 6.6 15131.881 67.30022 0.2064220 2.30000 1.834620 21.00 0.090822 0.207658 7656.063 yes no yes 646 146 92 44 12 68 20 98 30 217.350 3149007.5 139999.88 167671.97 243000.11 24109 9.6 57.9 0.0291794
co 1984 2.15 5.6 15486.813 68.66242 0.1978022 2.30000 1.846310 21.00 0.075862 0.192155 7707.853 yes no yes 608 104 73 53 14 71 14 101 28 202.940 3189993.5 137000.11 165417.81 239000.08 24588 7.5 59.5 0.0553472
co 1985 2.05 5.9 15569.915 67.85415 0.1906780 2.30000 1.858080 21.00 0.074899 0.192028 8092.209 yes no yes 579 96 63 35 7 58 16 100 28 186.730 3231008.8 137000.23 163193.95 232999.77 26146 7.2 60.1 0.0243076
co 1986 1.81 7.4 15616.099 64.98344 0.1857585 2.30000 1.869910 21.00 0.074097 0.192100 8131.375 yes no yes 603 116 75 50 9 76 18 101 37 175.370 3265991.5 147000.02 161000.00 220999.80 26557 7.0 60.7 0.0165261
co 1987 1.78 7.7 15605.000 64.21830 0.1800000 2.30000 1.881830 21.00 0.058070 0.192999 8182.028 yes no yes 591 90 64 42 7 54 16 59 16 140.260 3296004.5 143999.83 156999.56 216000.11 26968 6.2 61.5 -0.0235823
co 1988 1.74 6.4 15845.043 65.30445 0.1732435 2.30000 1.893820 21.00 0.058070 0.180260 8380.769 yes no yes 497 93 66 33 6 44 16 69 23 132.950 3301009.8 136000.03 149001.02 208999.72 27665 5.5 62.3 0.0086260
ct 1982 2.42 6.9 17255.369 61.72942 0.2243437 0.10000 0.233310 18.50 0.227055 0.192841 6440.054 no no no 515 158 90 39 8 86 35 96 42 195.110 3126992.5 169999.83 162300.14 216000.20 20138 9.7 57.8 -0.0029880
ct 1983 2.46 6.0 17744.266 62.29441 0.2335631 0.10000 0.251980 19.25 0.082803 0.189350 6570.043 no no no 438 118 85 29 11 61 28 87 31 171.220 3140010.0 164000.25 160443.48 215999.88 20630 9.6 57.9 0.0736263
ct 1984 2.41 4.6 18760.439 65.03468 0.2480110 0.10000 0.272160 20.00 0.080634 0.181857 6680.193 no no no 469 126 85 32 6 65 25 81 30 171.700 3154998.8 158999.89 158608.08 216000.00 21076 7.5 59.5 0.0778200
ct 1985 2.41 4.9 19312.500 65.91093 0.2390784 0.10000 0.293950 20.33 0.080151 0.178947 6979.215 no yes yes 448 103 71 35 1 53 15 64 24 150.750 3173996.0 155000.31 156793.66 216000.22 22152 7.2 60.1 0.0505845
ct 1986 2.31 3.8 20152.734 67.24277 0.2329102 0.10000 0.317480 21.00 0.079862 0.171669 7661.745 no yes yes 450 114 63 37 11 56 14 63 26 145.750 3193006.5 152000.03 155000.00 200000.00 24464 7.0 60.7 0.0636907
ct 1987 2.25 3.3 21192.000 67.63767 0.2256900 0.10000 0.342900 21.00 0.080972 0.166009 8338.534 no yes yes 449 102 61 31 3 42 11 69 30 165.510 3210996.0 145999.84 150000.00 194000.06 26775 6.2 61.5 0.0757369
ct 1988 2.15 3.0 22193.455 67.06396 0.2172185 0.10000 0.370350 21.00 0.080972 0.157068 8061.235 no yes yes 484 93 62 40 7 57 17 76 32 135.420 3233003.2 135999.83 143000.50 201999.80 26062 5.5 62.3 0.0512114
de 1982 2.59 8.5 14263.724 60.31042 0.1730310 0.70000 0.200000 20.00 0.000000 0.205543 7651.654 yes no no 122 34 23 5 2 24 9 23 14 45.650 600001.0 31000.06 36772.90 47999.96 4591 9.7 57.8 0.0079685
de 1983 2.63 8.1 14500.000 59.86842 0.1662844 0.70000 0.200000 20.00 0.000000 0.199483 8062.700 yes no no 110 26 14 8 2 9 3 18 7 33.000 606000.5 29999.96 36059.16 48000.00 4886 9.6 57.9 0.0567113
de 1984 2.57 6.2 14925.274 62.41901 0.1593406 0.70000 0.200000 21.00 0.000000 0.193182 8368.062 yes no no 130 28 16 8 0 15 3 17 8 28.680 614001.1 29000.01 35359.28 47000.02 5138 7.5 59.5 0.0523612
de 1985 2.55 5.3 15408.898 63.55932 0.1536017 0.70000 0.200000 21.00 0.000000 0.183342 8625.425 yes no no 104 21 12 7 2 10 2 21 3 38.880 621998.4 28000.00 34672.98 46999.95 5365 7.2 60.1 0.0378007
de 1986 2.42 4.3 15822.497 64.58333 0.1496388 0.70000 0.200000 21.00 0.000000 0.177617 9045.817 yes no no 136 33 20 10 5 18 6 22 8 45.550 632999.8 28999.96 34000.00 41000.03 5726 7.0 60.7 0.0399405
de 1987 2.37 3.2 16407.000 65.51020 0.1450000 0.70000 0.200000 21.00 0.000000 0.169047 9450.308 yes no no 146 27 16 9 3 9 1 24 10 41.840 644000.2 28999.98 33999.47 40999.99 6086 6.2 61.5 0.0614631
de 1988 2.32 3.2 16998.074 67.60000 0.1395573 0.70000 0.200000 21.00 0.000000 0.158751 9703.021 yes no no 160 32 18 9 1 19 2 20 7 42.840 660000.7 27999.96 30000.16 45000.04 6404 5.5 62.3 0.0714475
fl 1982 2.51 8.2 13502.387 53.48780 1.0739857 9.15260 0.400000 19.00 0.000000 0.181476 7587.130 yes no yes 2653 587 282 148 35 259 86 350 123 810.760 10478007.0 476999.28 492108.41 687999.94 79498 9.7 57.8 0.0053854
fl 1983 2.46 8.6 13924.312 53.72708 1.1704128 8.93670 0.400000 19.00 0.000000 0.177945 7604.254 yes no yes 2686 562 291 132 30 274 92 317 110 963.900 10753980.0 467000.41 497250.16 701000.19 81776 9.6 57.9 0.0770848
fl 1984 2.35 6.3 14307.692 55.62103 1.1868132 8.72600 0.400000 19.00 0.000000 0.178720 7735.305 yes no yes 2814 566 311 150 29 270 88 344 129 744.380 11049985.0 459000.56 502445.66 713000.69 85475 7.5 59.5 0.0808424
fl 1985 2.27 6.0 14760.593 56.36853 1.1440679 8.52020 0.400000 20.00 0.000000 0.170072 7747.311 yes no yes 2832 490 254 146 24 239 79 341 101 690.200 11366008.0 456999.78 507695.38 718999.75 88056 7.2 60.1 0.0592894
fl 1986 2.24 5.7 15102.167 57.44054 1.1145512 8.31930 0.400000 21.00 0.000000 0.162555 7768.756 yes no yes 2830 530 296 173 39 263 92 347 94 806.840 11694022.0 474999.38 513000.00 670999.50 90848 7.0 60.7 0.0535696
fl 1987 2.17 5.3 15584.000 58.94335 1.0800000 8.12310 0.400000 21.00 0.000000 0.161258 7788.331 yes no yes 2839 493 262 166 32 227 75 326 94 778.970 12022987.0 483000.41 512994.34 670000.25 93639 6.2 61.5 0.0625311
fl 1988 2.08 5.0 15979.788 59.79093 1.0394610 7.93160 0.400000 21.00 0.000000 0.157563 8538.230 yes no yes 3078 573 315 184 42 278 73 382 145 794.750 12334992.0 477000.28 492000.59 698999.94 105319 5.5 62.3 0.0507521
ga 1982 1.94 7.8 11774.463 60.07344 2.7207637 24.65610 0.426410 19.00 0.498940 0.210264 8623.444 no no no 1229 225 132 90 16 131 41 161 59 443.230 5650990.5 303999.62 323855.62 420999.78 48731 9.7 57.8 0.0060982
ga 1983 1.99 7.5 12237.386 59.85542 2.6146789 24.38850 0.440260 19.00 0.499910 0.206981 8518.590 no no no 1296 217 134 97 19 141 45 160 41 389.500 5732991.0 297000.31 324141.34 427000.31 48837 9.6 57.9 0.0790374
ga 1984 1.97 6.0 12957.143 61.21198 2.5054944 24.12390 0.454560 19.00 0.450190 0.205332 8641.914 no no no 1410 252 146 124 31 167 47 168 48 436.750 5841993.0 293000.12 324427.31 432999.75 50486 7.5 59.5 0.1020049
ga 1985 1.93 6.5 13364.407 61.65138 2.4152541 23.86210 0.469320 19.25 0.433170 0.194928 8988.107 no no no 1361 198 124 95 16 151 37 163 38 400.130 5976008.0 294000.22 324713.53 439000.47 53713 7.2 60.1 0.0524056
ga 1986 1.77 5.9 13891.641 63.30337 2.3529410 23.60320 0.484570 20.25 0.424590 0.188869 9344.768 no no no 1530 263 165 119 22 153 41 183 49 463.130 6099991.5 310999.72 325000.00 411999.78 57003 7.0 60.7 0.0652951
ga 1987 1.75 5.5 14306.000 63.32089 2.2800000 23.34710 0.500300 21.00 0.207280 0.184329 9690.281 no no no 1599 264 164 113 13 134 29 190 49 470.430 6222007.5 315000.12 324000.19 411000.09 60293 6.2 61.5 0.0648060
ga 1988 1.72 5.8 14687.199 64.06385 2.1944177 23.09380 0.516560 21.00 0.207280 0.174883 9817.396 no no no 1653 272 171 125 15 171 49 170 49 484.880 6342008.0 312000.03 307001.81 425000.00 62262 5.5 62.3 0.0443216
id 1982 1.39 9.8 11078.759 58.82353 0.4027447 1.02369 25.157499 19.00 0.000000 0.233786 8033.752 no no no 256 47 24 29 4 38 10 32 13 76.790 977998.8 47999.97 52247.96 69000.02 7857 9.7 57.8 -0.0541203
id 1983 1.30 9.8 11346.330 59.85507 0.3870413 1.03574 24.987900 19.00 0.000000 0.228551 8387.642 no no no 263 44 31 15 4 38 12 36 6 88.280 988001.2 46999.99 51676.66 69000.02 8287 9.6 57.9 0.0452080
id 1984 1.28 7.2 11386.813 61.37339 0.3708791 1.04794 24.819599 19.00 0.000000 0.218236 7775.768 no no no 242 34 22 24 2 26 8 33 7 79.660 999001.0 47000.03 51111.62 68000.02 7768 7.5 59.5 0.0387287
id 1985 1.18 7.9 11459.746 61.28572 0.3575212 1.06028 24.652300 19.00 0.000000 0.212606 7671.632 no no no 255 53 34 17 7 38 13 27 9 73.650 1005001.3 47000.02 50552.75 64999.94 7710 7.2 60.1 0.0210429
id 1986 1.12 8.7 11541.796 61.10326 0.3482972 1.07277 24.486200 19.00 0.000000 0.207312 7899.201 no no no 258 48 35 33 5 31 10 32 9 84.020 1002000.1 49000.03 50000.00 62999.94 7915 7.0 60.7 -0.0151058
id 1987 1.06 8.0 11859.000 61.18143 0.3375000 1.08540 24.321199 20.50 0.000000 0.202263 8135.269 no no no 262 53 39 22 5 34 11 34 11 78.180 998000.2 48999.96 48000.23 61000.00 8119 6.2 61.5 0.0005643
id 1988 1.07 5.8 12189.605 62.90098 0.3248316 1.09818 24.157301 21.00 0.000000 0.189994 8102.682 no no no 257 36 25 22 4 30 6 30 6 72.800 1003001.2 48000.04 46999.84 56999.98 8127 5.5 62.3 0.0495875
il 1982 2.04 11.3 14743.437 58.07432 0.1885442 2.34697 0.233300 21.00 6.403550 0.209362 5696.535 no no no 1651 418 229 106 23 203 80 224 98 532.990 11478031.0 583000.56 618339.00 839999.00 65385 9.7 57.8 -0.0399355
il 1983 1.96 11.4 14745.413 57.74566 0.1811927 2.37081 0.252000 21.00 6.396310 0.205004 5862.868 no no no 1526 362 201 96 18 187 64 195 85 501.100 11490963.0 559998.62 605350.75 827000.06 67370 9.6 57.9 0.0109067
il 1984 1.93 9.1 15390.110 59.13629 0.1736264 2.39490 0.272200 21.00 6.379100 0.195512 6067.528 no no no 1547 343 206 99 27 179 62 231 72 462.280 11521990.0 541001.31 592635.25 816000.62 69910 7.5 59.5 0.0689042
il 1985 1.86 9.0 15602.754 59.70356 0.1673729 2.41923 0.293900 21.00 6.371910 0.192188 6141.676 no no no 1534 304 162 73 13 162 45 232 82 396.690 11534962.0 529999.44 580186.88 796998.88 70844 7.2 60.1 0.0187625
il 1986 1.75 8.1 15988.648 60.34324 0.1630547 2.44381 0.317500 21.00 4.473210 0.185557 6345.777 no no no 1596 354 207 108 20 178 64 238 98 475.670 11550988.0 541000.88 568000.00 741999.31 73300 7.0 60.7 0.0308808
il 1987 1.68 7.4 16417.000 60.99989 0.1580000 2.46863 0.342900 21.00 4.461230 0.182501 6540.846 yes no no 1660 326 183 100 18 173 54 225 66 437.110 11581988.0 531999.81 552998.31 723000.75 75756 6.2 61.5 0.0263684
il 1988 1.63 6.8 16915.303 61.59708 0.1520693 2.49371 0.370300 21.00 4.461230 0.170912 6757.613 yes no no 1837 364 228 110 23 210 68 225 63 506.850 11614013.0 508001.00 517994.12 730998.88 78483 5.5 62.3 0.0450503
in 1982 1.44 11.9 12282.816 56.42292 0.3091325 1.80443 0.328300 21.00 0.000000 0.202990 7149.917 yes no no 961 235 131 65 21 127 45 141 53 348.890 5483000.5 284000.28 310440.28 412000.03 39203 9.7 57.8 -0.0645199
in 1983 1.39 11.1 12364.679 56.48422 0.2970791 1.85902 0.343400 21.00 0.000000 0.180198 7277.506 yes no no 1016 212 130 65 11 130 43 146 56 346.770 5473990.5 271999.53 303874.88 404999.78 39837 9.6 57.9 0.0155557
in 1984 1.39 8.6 13008.791 58.71965 0.2846736 1.91527 0.359200 21.00 0.000000 0.103286 7478.887 no no no 925 191 119 83 20 102 32 137 54 351.450 5491993.5 263999.94 297448.28 399000.47 41074 7.5 59.5 0.0773052
in 1985 1.39 7.9 13161.017 61.43695 0.2744205 1.97321 0.375800 21.00 0.000000 0.185119 7416.253 no no no 974 166 93 77 14 109 31 157 52 302.450 5499003.5 259999.86 291157.62 388000.19 40782 7.2 60.1 0.0168915
in 1986 1.28 6.7 13582.043 62.45146 0.2673405 2.03292 0.393100 21.00 0.000000 0.120420 7714.322 no no no 1038 192 131 83 15 119 34 142 55 290.310 5503011.0 270000.38 285000.00 358000.03 42452 7.0 60.7 0.0307622
in 1987 1.29 6.4 13937.000 61.92881 0.2590530 2.09442 0.411200 21.00 0.000000 0.097662 7977.216 no no no 1055 194 123 100 20 99 32 118 38 254.860 5531002.5 270000.28 278998.97 351000.34 44122 6.2 61.5 0.0409886
in 1988 1.28 5.3 14363.812 63.40649 0.2493291 2.15779 0.430200 21.00 0.000000 0.073137 9201.576 no no no 1101 202 123 90 19 132 36 141 44 322.400 5556004.5 260999.69 260001.17 357999.75 51124 5.5 62.3 0.0364388
ia 1982 1.25 8.5 12968.974 60.02779 0.3758950 0.46661 0.328300 19.00 0.000000 0.216399 6653.263 no no no 480 87 61 52 6 59 19 66 21 219.280 2906994.5 144000.05 159388.62 215999.69 19341 9.7 57.8 -0.0895124
ia 1983 1.23 8.1 12573.395 60.44465 0.3612385 0.50397 0.343400 19.00 0.000000 0.204323 6770.308 yes no no 514 123 72 42 10 77 36 75 32 211.560 2904004.0 137999.92 155393.77 211999.75 19661 9.6 57.9 -0.0511714
ia 1984 1.16 7.0 13203.297 60.74074 0.3461539 0.54432 0.359200 19.00 0.000000 0.193046 7060.630 yes no no 420 100 61 32 7 62 29 56 22 168.690 2902998.5 132999.72 151499.05 207000.31 20497 7.5 59.5 0.0678450
ia 1985 1.10 8.0 13351.695 60.49326 0.3336864 0.58790 0.375794 19.00 0.000000 0.184236 7001.038 yes no no 474 85 62 37 6 71 21 76 25 182.751 2884001.0 128999.87 147701.94 198000.20 20191 7.2 60.1 -0.0198835
ia 1986 0.98 7.0 13812.178 62.52336 0.3831269 0.63500 0.393111 20.00 0.000000 0.178267 7192.990 yes no no 441 93 62 49 5 65 25 51 13 146.979 2849997.0 132000.05 144000.00 176999.75 20500 7.0 60.7 0.0143715
ia 1987 1.04 5.5 14284.000 64.03181 0.4275000 0.68580 0.411227 21.00 0.000000 0.172570 7342.257 yes no no 491 91 61 42 6 55 16 56 13 186.090 2834005.8 128000.00 138000.25 169999.88 20808 6.2 61.5 -0.0128075
ia 1988 0.96 4.5 14111.646 66.68217 0.4849269 0.74070 0.430177 21.00 0.000000 0.156330 7730.063 yes no no 557 106 65 40 8 63 22 73 22 182.051 2834000.0 120000.12 125999.99 174000.09 21907 5.5 62.3 0.0249414
ks 1982 1.29 6.3 14094.272 62.73292 0.4840096 3.19660 0.426407 21.00 0.000000 0.213105 7333.069 no yes yes 498 88 55 30 7 56 18 77 24 288.305 2407995.8 111000.12 134654.73 185000.09 17658 9.7 57.8 -0.0154056
ks 1983 1.23 6.1 13917.432 62.44395 0.4651376 3.24610 0.440257 21.00 0.000000 0.204553 7479.611 no yes yes 411 76 45 30 3 59 28 64 16 185.429 2426998.0 105999.95 131373.02 182000.19 18153 9.6 57.9 0.0094826
ks 1984 1.21 5.2 14308.791 63.11977 0.4457143 3.29630 0.454557 21.00 0.000000 0.195035 7670.888 no yes yes 510 96 62 32 6 60 22 68 20 208.669 2440004.5 102000.16 128171.28 176999.91 18717 7.5 59.5 0.0549539
ks 1985 1.22 5.0 14631.355 65.55184 0.4296610 3.34730 0.469321 21.00 0.000000 0.190181 7867.333 no yes yes 486 89 47 29 3 61 20 67 27 231.750 2450004.2 100999.90 125047.58 168999.88 19275 7.2 60.1 0.0107860
ks 1986 1.14 5.4 14977.296 64.40771 0.4185759 3.39910 0.484565 21.00 0.000000 0.183509 8100.053 yes yes yes 500 110 56 38 7 63 30 59 17 216.014 2458996.2 107000.06 122000.00 156000.05 19918 7.0 60.7 0.0250776
ks 1987 1.08 4.9 15152.000 65.77511 0.4056000 3.45160 0.500305 21.00 0.000000 0.179385 8304.131 yes yes yes 491 112 72 37 10 62 24 66 27 184.431 2475996.5 104999.98 118000.84 151999.84 20561 6.2 61.5 0.0028575
ks 1988 1.08 4.8 15167.469 66.14301 0.3903754 3.50500 0.516555 21.00 0.000000 0.170375 8481.355 yes yes yes 483 95 63 34 7 59 27 52 14 161.535 2495002.2 102000.10 110000.74 152000.12 21161 5.5 62.3 0.0206855
ky 1982 1.43 10.6 11071.599 55.83982 0.2159905 24.04110 0.300000 21.00 39.453300 0.195236 6937.466 no no no 822 159 100 67 14 113 37 119 33 279.195 3694000.2 193999.89 208284.19 276999.91 25627 9.7 57.8 -0.0276839
ky 1983 1.38 11.7 10913.991 55.22058 0.2075688 23.91270 0.300000 21.00 39.240799 0.202715 7194.143 no no no 778 148 95 73 14 92 35 101 33 262.608 3713993.8 187000.16 205142.80 276999.97 26719 9.6 57.9 0.0128027
ky 1984 1.30 9.3 11441.758 56.90224 0.1989011 23.78500 0.300000 21.00 40.354099 0.191641 7513.703 yes no no 754 126 80 55 10 87 21 107 25 236.672 3720003.2 181000.23 202048.77 273999.97 27951 7.5 59.5 0.0646127
ky 1985 1.28 9.5 11405.721 55.89949 0.1917373 23.65790 0.300000 21.00 39.103600 0.202642 7654.335 yes no no 712 117 69 61 16 84 18 92 30 203.750 3725993.0 176999.88 199001.41 269000.34 28520 7.2 60.1 -0.0024902
ky 1986 1.17 9.3 11602.684 55.57971 0.1867905 23.53150 0.300000 21.00 45.792099 0.179630 7859.621 yes no no 805 142 108 58 18 89 22 105 34 244.906 3726006.8 182999.94 196000.00 246000.16 29285 7.0 60.7 0.0103472
ky 1987 1.16 8.8 12008.000 55.38739 0.1810000 23.40580 0.300000 21.00 45.779800 0.173935 8135.244 yes no no 844 121 75 80 10 87 17 106 25 255.851 3726993.2 183000.19 192002.11 239999.81 30320 6.2 61.5 0.0472531
ky 1988 1.16 7.9 12340.712 56.57942 0.1742060 23.28080 0.300000 21.00 45.779800 0.166122 8482.436 yes no no 838 107 79 77 9 93 20 106 22 224.850 3726995.5 177000.11 178000.66 245000.03 31614 5.5 62.3 0.0329400
la 1982 1.84 10.3 12213.604 53.74718 0.8663484 15.26560 0.328286 18.00 3.454300 0.281496 6137.799 yes yes yes 1091 230 120 58 15 155 49 175 50 378.609 4383004.5 239999.67 251680.30 345000.25 26902 9.7 57.8 -0.0428278
la 1983 1.76 11.8 11994.266 53.36705 0.8325688 15.14980 0.343414 18.00 3.409100 0.243499 6208.742 no yes yes 933 168 95 66 13 117 31 142 37 362.470 4440996.5 235000.05 248966.66 343000.12 27573 9.6 57.9 -0.0619938
la 1984 1.74 10.0 12017.582 54.88226 0.7978022 15.03480 0.359239 18.00 3.183100 0.281625 7080.938 no yes yes 961 222 138 70 19 119 53 152 48 407.527 4460990.5 227000.02 246282.27 338000.09 31588 7.5 59.5 0.0243971
la 1985 1.60 11.5 11972.458 54.95467 0.7690678 14.92070 0.375794 18.00 3.124300 0.202869 7445.878 no yes yes 931 194 113 61 8 118 46 134 42 360.649 4481002.5 221000.08 243626.81 329999.69 33365 7.2 60.1 -0.0276619
la 1986 1.45 13.1 11602.684 53.71233 0.7492260 14.80750 0.393111 18.00 3.080700 0.196083 7108.686 no yes yes 932 181 91 57 12 108 32 141 34 351.913 4499003.0 221999.80 241000.00 302999.69 31982 7.0 60.7 -0.0904825
la 1987 1.40 12.0 11515.000 53.64404 0.7260000 14.69510 0.411227 20.50 3.106900 0.182696 6859.208 no yes yes 827 174 103 58 11 82 24 127 40 303.575 4461011.0 214000.03 230998.92 290000.00 30599 6.2 61.5 -0.0609582
la 1988 1.39 10.9 11830.606 53.84858 0.6987488 14.58360 0.430177 21.00 3.106900 0.170625 7867.977 no yes yes 925 208 131 57 12 108 39 110 34 313.573 4407994.5 203999.83 208998.56 295000.28 34682 5.5 62.3 0.0213793
me 1982 1.97 8.6 11442.721 55.99051 0.8054893 0.10000 0.400000 20.00 3.345100 0.187583 6733.286 no yes no 166 30 24 11 2 26 6 19 4 75.240 1135998.1 60999.95 62254.06 80000.00 7649 9.7 57.8 0.0058755
me 1983 1.99 9.0 11795.871 57.25995 0.7740826 0.10000 0.400000 20.00 3.406100 0.183961 6920.517 no yes no 224 44 31 22 4 30 9 43 11 91.595 1145001.1 59000.05 61682.73 81000.03 7924 9.6 57.9 0.0623604
me 1984 1.97 6.1 12271.429 59.76878 0.7417582 0.10000 0.400000 20.00 3.571190 0.179520 8083.908 no yes no 232 47 39 15 2 39 12 22 9 71.800 1156000.2 57999.93 61116.64 80999.98 9345 7.5 59.5 0.0590452
me 1985 1.83 5.4 12609.110 59.77143 0.7150424 0.10000 0.400000 20.50 3.350520 0.174748 7969.934 no yes no 206 39 28 18 4 31 4 22 8 58.600 1163999.6 55999.93 60555.74 80000.00 9277 7.2 60.1 0.0366306
me 1986 1.79 5.3 13292.054 60.13590 0.7498070 0.10000 0.400000 21.00 3.327650 0.169682 8550.348 no yes no 214 34 21 12 1 22 5 41 10 65.880 1171999.1 55999.93 60000.00 74000.01 10021 7.0 60.7 0.0618390
me 1987 1.78 4.4 13984.000 62.47216 0.7875000 0.10000 0.400000 21.00 3.285590 0.188787 9069.937 no yes no 232 36 26 12 2 34 9 26 11 59.930 1186998.4 55999.93 59000.12 72000.02 10766 6.2 61.5 0.1128455
me 1988 1.78 3.8 14538.979 62.91028 0.7579404 0.10000 0.400000 21.00 3.285590 0.179826 9461.399 no yes no 255 31 25 21 3 28 4 29 6 61.770 1205001.5 55000.02 56000.00 77000.08 11401 5.5 62.3 0.0703771
md 1982 2.46 8.4 15198.091 61.45026 0.2410501 3.02269 0.328286 21.00 1.533680 0.196279 6768.094 yes no no 640 182 101 43 10 90 45 92 37 175.600 4272990.5 236999.48 234008.06 310000.19 28920 9.7 57.8 -0.0069335
md 1983 2.38 6.9 15644.495 63.14655 0.2316514 3.03409 0.343414 21.00 1.501050 0.204690 7118.825 yes no no 656 167 93 47 11 69 32 102 36 177.330 4300990.5 229999.80 231722.80 312000.06 30618 9.6 57.9 0.0579636
md 1984 2.32 5.4 16313.187 64.53771 0.2219780 3.04554 0.359239 21.00 1.133940 0.212863 7289.488 yes no no 643 142 86 48 10 62 15 109 43 180.070 4349002.0 222999.62 229459.84 314999.78 31702 7.5 59.5 0.0671133
md 1985 2.26 4.6 16921.609 64.55090 0.2139831 3.05704 0.375794 21.00 1.122840 0.215297 7590.410 yes no no 729 141 85 39 6 90 32 123 41 188.840 4391989.5 216999.41 227218.98 315999.59 33337 7.2 60.1 0.0554242
md 1986 2.13 4.5 17475.748 66.24410 0.2084623 3.06858 0.393111 21.00 1.107380 0.176037 7826.705 yes no no 784 174 106 56 13 75 27 132 55 197.080 4461009.0 210999.88 225000.00 293999.75 34915 7.0 60.7 0.0559680
md 1987 2.10 4.2 18167.000 66.69566 0.2020000 3.08016 0.411227 21.00 1.091510 0.170368 8046.975 yes no no 814 172 101 53 17 90 23 118 41 170.010 4534996.0 206999.72 221997.48 289000.34 36493 6.2 61.5 0.0718352
md 1988 1.98 4.5 18755.533 66.68565 0.1944177 3.09178 0.430177 21.00 1.091510 0.172348 8112.946 yes no no 782 150 92 50 7 80 25 100 31 158.010 4621995.5 197000.08 214001.02 309999.66 37498 5.5 62.3 0.0544077
ma 1982 2.46 7.9 15215.990 62.05267 0.2863962 0.00000 0.100000 20.00 1.811140 0.190607 6380.051 no no no 659 169 108 76 15 92 33 109 45 344.770 5746976.0 289999.97 332032.38 445999.31 36666 9.7 57.8 -0.0017325
ma 1983 2.42 6.9 15801.605 61.98569 0.2752294 0.00000 0.100000 20.00 1.800210 0.186082 6510.740 no no no 651 198 131 59 12 85 48 109 55 221.520 5766011.5 281999.81 325323.69 440999.16 37541 9.6 57.9 0.0677382
ma 1984 2.46 4.8 16735.164 64.33163 0.2637362 0.00000 0.100000 20.00 2.242150 0.179802 6646.591 no no no 666 181 130 58 13 101 43 119 48 210.570 5798010.0 273999.78 318750.56 435000.34 38537 7.5 59.5 0.0839121
ma 1985 2.40 3.9 17271.186 64.64491 0.2542373 0.00000 0.100000 20.50 2.310320 0.173664 6818.296 no no no 742 176 105 64 10 103 35 101 44 188.430 5821982.0 267000.41 312310.22 426000.38 39696 7.2 60.1 0.0551131
ma 1986 2.20 3.8 18145.512 64.45321 0.2476780 0.00000 0.100000 21.00 1.800070 0.170999 7027.964 no no no 752 190 123 72 27 80 29 109 47 187.300 5833979.5 265000.12 306000.00 386000.56 41001 7.0 60.7 0.0602692
ma 1987 2.26 3.2 19050.000 65.11881 0.2400000 0.00000 0.100000 21.00 1.793610 0.162926 7225.436 no no no 689 163 110 67 14 94 36 80 38 176.040 5855010.0 253999.55 295997.75 373000.38 42305 6.2 61.5 0.0745931
ma 1988 2.15 3.3 20034.648 66.17519 0.2309913 0.00000 0.100000 21.00 1.793610 0.155174 7358.473 no no no 725 165 106 48 9 92 37 86 34 204.220 5888994.0 236999.59 273997.09 398000.72 43334 5.5 62.3 0.0577074
mi 1982 1.88 15.5 13247.017 53.53864 0.5456539 0.62481 0.200000 21.00 0.000000 0.243818 6712.743 yes no no 1392 392 225 89 24 178 84 169 81 496.140 9116988.0 493999.84 517776.75 685000.88 61200 9.7 57.8 -0.0806632
mi 1983 1.87 14.2 13606.651 54.74844 0.5243784 0.63760 0.200000 21.00 0.000000 0.237244 6721.328 yes no no 1314 345 200 110 17 163 75 179 78 492.710 9054014.0 473999.00 505932.31 666999.50 60855 9.6 57.9 0.0472308
mi 1984 1.87 11.2 14317.582 57.24455 0.5024813 0.65064 0.200000 21.00 0.000000 0.243742 7007.071 yes no no 1531 334 191 122 26 174 58 196 74 547.530 9057993.0 460000.66 494358.81 656001.06 63470 7.5 59.5 0.0715408
mi 1985 1.84 9.9 14830.509 57.69797 0.4843835 0.66396 0.200000 21.00 0.000000 0.219419 7416.576 yes no no 1545 302 165 106 19 168 53 179 64 423.760 9088021.0 455000.06 483050.06 642999.06 67402 7.2 60.1 0.0466399
mi 1986 1.75 8.8 15278.638 58.40747 0.4718865 0.67755 0.200000 21.00 0.000000 0.191912 7829.523 yes no no 1605 334 200 147 30 176 72 189 64 498.310 9138998.0 467999.34 472000.00 613999.19 71554 7.0 60.7 0.0387384
mi 1987 1.65 8.2 15418.000 59.94806 0.4572580 0.69141 0.200000 21.00 0.000000 0.186721 8228.915 yes no no 1597 333 177 138 17 169 47 180 61 487.370 9199998.0 461000.38 463001.03 603000.94 75706 6.2 61.5 0.0176270
mi 1988 1.62 7.6 15930.702 60.24684 0.4400943 0.70556 0.200000 21.00 0.000000 0.175254 8430.646 yes no no 1704 359 200 115 17 176 62 192 75 551.130 9239979.0 439999.38 442000.06 599000.44 77899 5.5 62.3 0.0325749
mn 1982 2.13 7.8 13781.623 65.08144 0.3460620 0.10000 0.200000 19.00 0.000000 0.199833 7059.264 yes no no 571 138 83 36 14 65 26 96 39 164.600 4133009.0 213000.09 231810.09 313000.28 29176 9.7 57.8 -0.0207701
mn 1983 2.11 8.2 13840.597 64.76499 0.3325688 0.10000 0.200000 19.00 0.000000 0.191821 7494.075 yes no no 555 124 75 40 13 76 27 82 32 178.565 4145008.0 203000.34 226957.31 309000.22 31063 9.6 57.9 0.0203343
mn 1984 2.06 6.3 14734.066 67.18196 0.3186813 0.10000 0.200000 19.00 0.000000 0.178974 7644.966 yes no no 582 108 61 48 10 93 27 75 21 208.156 4163000.8 195999.97 222206.11 303999.44 31826 7.5 59.5 0.0854081
mn 1985 2.04 6.0 14983.051 66.97630 0.3072034 0.10000 0.200000 19.00 0.000000 0.175171 7795.873 yes no no 608 128 81 45 9 74 29 74 29 160.486 4192987.8 192999.69 217554.36 293999.62 32688 7.2 60.1 0.0203599
mn 1986 1.78 5.3 15464.396 66.76154 0.2992776 0.10000 0.200000 19.67 0.000000 0.164709 8053.176 yes no no 571 121 74 50 7 89 34 63 25 162.805 4212996.0 196000.03 213000.00 267999.56 33928 7.0 60.7 0.0350065
mn 1987 1.81 5.4 15910.000 66.88555 0.3162500 0.10000 0.200000 21.00 0.000000 0.153883 8282.359 yes no no 530 113 60 58 11 55 13 63 25 141.750 4246012.5 189000.19 206000.22 259000.25 35167 6.2 61.5 0.0363326
mn 1988 1.73 4.0 16048.123 68.89848 0.3209817 0.10000 0.200000 21.00 0.000000 0.144433 8462.255 yes no no 612 112 65 44 15 81 27 79 28 158.077 4307008.0 180999.95 192002.27 269000.28 36447 5.5 62.3 0.0391816
ms 1982 1.50 11.0 9553.699 52.20507 1.1459428 30.09000 0.300000 21.00 19.875300 0.208189 6679.401 no no no 730 134 79 46 11 81 24 102 29 276.000 2566996.8 144000.20 150960.09 191999.98 17146 9.7 57.8 -0.0204202
ms 1983 1.47 12.6 9513.762 50.87623 1.1012615 30.03510 0.300000 21.00 20.031000 0.207436 6891.988 yes no no 715 116 71 50 11 76 14 95 22 125.053 2582999.2 139000.09 149960.17 193999.89 17802 9.6 57.9 0.0013884
ms 1984 1.42 10.8 9792.308 52.06522 1.0552747 29.98040 0.300000 21.00 20.000000 0.199328 7098.540 yes no no 679 102 65 40 6 82 27 76 14 434.000 2597999.0 135999.83 148966.89 194999.80 18442 7.5 59.5 0.0672459
ms 1985 1.36 10.3 9797.670 54.20911 1.0766314 29.92570 0.300000 21.00 19.885200 0.193236 7321.097 yes no no 662 102 68 37 6 72 17 101 20 379.895 2612996.5 134000.19 147980.17 191999.88 19130 7.2 60.1 0.0024292
ms 1986 1.27 11.7 9996.904 54.57464 1.0653870 29.87120 0.300000 21.00 18.639999 0.185524 7489.324 yes no no 771 132 79 55 6 85 25 91 24 464.977 2624002.0 140000.05 147000.00 171999.94 19652 7.0 60.7 0.0061583
ms 1987 1.23 10.2 10303.000 55.08791 0.9603000 29.81670 0.300000 21.00 17.264799 0.175626 7684.952 yes no no 756 119 78 48 9 85 20 95 21 464.400 2625000.0 138999.91 143999.45 167000.08 20173 6.2 61.5 0.0131728
ms 1988 1.23 8.4 10698.749 55.46129 0.9242541 29.76240 0.300000 21.00 17.264799 0.161036 8413.373 yes no no 722 106 63 45 7 72 11 84 22 450.000 2619995.5 135000.12 130999.59 173000.05 22043 5.5 62.3 0.0484700
mo 1982 1.27 9.2 12968.974 56.50999 0.3466122 14.38420 0.466610 21.00 0.000000 0.207461 7082.759 no no no 890 220 134 79 22 120 43 122 46 337.458 4942001.0 244999.98 270439.00 356999.69 35003 9.7 57.8 -0.0207589
mo 1983 1.27 9.9 13186.927 56.70601 0.3330975 14.47710 0.503970 21.00 0.000000 0.201181 7363.074 no no no 911 227 130 64 17 102 44 112 47 351.850 4963009.0 235000.38 265442.47 354999.94 36543 9.6 57.9 0.0459878
mo 1984 1.27 7.2 13727.473 58.59958 0.3191879 14.57070 0.544320 21.00 0.000000 0.187239 7705.446 no no no 967 203 106 65 15 131 47 138 48 337.435 5001008.5 226999.69 260538.27 352000.41 38535 7.5 59.5 0.0711630
mo 1985 1.35 6.4 14033.898 61.06405 0.3076918 14.66490 0.587890 21.00 0.000000 0.184188 7811.482 no no no 931 200 126 69 12 105 34 130 45 287.891 5029007.0 223999.80 255724.67 343999.97 39284 7.2 60.1 0.0251532
mo 1986 1.37 6.1 14368.421 62.45421 0.2997534 14.75970 0.634960 21.00 0.000000 0.177048 8161.917 no no no 1129 237 138 97 24 138 57 153 52 351.654 5064006.5 232000.25 251000.00 311000.25 41332 7.0 60.7 0.0272512
mo 1987 1.40 6.3 14648.000 62.73597 0.2904610 14.85510 0.685800 21.00 0.000000 0.163764 8500.705 no no no 1044 209 126 94 16 98 23 125 38 324.708 5102988.5 231000.23 245000.00 304000.16 43379 6.2 61.5 0.0343548
mo 1988 1.32 5.7 14871.992 62.76623 0.2795582 14.95110 0.740700 21.00 0.000000 0.151574 8864.047 no no no 1103 237 147 70 15 129 37 150 61 350.867 5140992.5 223000.25 225998.61 313000.16 45570 5.5 62.3 0.0246795
mt 1982 1.92 8.6 12033.413 61.22449 0.3464475 1.18070 3.300000 19.00 0.000000 0.221545 8284.474 no yes no 254 50 32 26 8 38 12 51 9 95.544 804999.8 41000.02 42323.12 58000.02 6669 9.7 57.8 -0.0431731
mt 1983 1.86 8.8 11954.129 60.40269 0.3329392 1.22320 3.300000 19.00 0.000000 0.225487 8800.240 no yes no 286 77 54 15 6 31 11 49 12 112.641 816000.4 40000.00 41466.70 57999.97 7181 9.6 57.9 -0.0063373
mt 1984 1.75 7.4 11906.594 62.22961 0.3190362 1.26720 3.300000 19.00 0.000000 0.223629 8974.486 no yes no 238 44 24 20 2 41 12 24 6 91.903 822999.8 37999.98 40627.60 56999.95 7386 7.5 59.5 -0.0127104
mt 1985 1.67 7.7 11669.491 62.02322 0.3190784 1.31290 3.300000 19.00 0.000000 0.208701 9167.078 no yes no 223 56 32 15 7 20 12 27 10 94.603 825999.3 37000.04 39805.48 55999.98 7572 7.2 60.1 -0.0510612
mt 1986 1.54 8.1 12076.367 62.33333 0.3220815 1.36020 3.300000 19.00 0.000000 0.187299 9575.281 no yes no 222 30 17 16 2 30 9 24 2 69.936 816999.5 37999.96 39000.00 50000.00 7823 7.0 60.7 0.0265266
mt 1987 1.46 7.4 12291.000 62.54181 0.3238000 1.40920 3.300000 20.33 0.000000 0.175665 9980.224 no yes no 234 54 32 17 3 26 12 35 10 77.865 808999.9 36000.02 37000.14 47999.98 8074 6.2 61.5 -0.0622298
mt 1988 1.44 6.8 12383.061 62.91946 0.3229105 1.45990 3.300000 21.00 0.000000 0.162920 10109.327 no yes no 198 49 35 20 2 13 3 20 7 73.125 804999.2 34999.98 34000.26 45999.96 8138 5.5 62.3 -0.0042574
ne 1982 1.59 6.1 13192.124 63.65979 0.3758950 0.65660 0.426410 20.00 0.037740 0.220480 7191.827 yes no no 261 46 25 14 4 34 9 31 9 90.449 1589999.4 77000.08 87722.62 119001.91 11435 9.7 57.8 -0.0392983
ne 1983 1.51 5.7 12919.725 63.59761 0.3612385 0.68680 0.440260 20.00 0.037590 0.212074 7226.798 yes no no 255 67 29 17 6 38 19 42 16 70.904 1596004.2 73999.91 85724.75 117001.42 11534 9.6 57.9 -0.0244699
ne 1984 1.45 4.4 13540.659 64.54623 0.3461539 0.71850 0.454560 20.00 0.037380 0.192238 26148.271 yes no no 285 44 23 28 6 27 11 37 9 63.360 1605000.9 71000.03 83772.38 114999.70 41968 7.5 59.5 0.0783498
ne 1985 1.43 5.5 13735.170 64.96164 0.3694386 0.75160 0.469320 21.00 0.036920 0.194537 7505.625 yes no no 237 48 30 18 6 28 10 28 14 60.515 1605995.6 68999.88 81864.46 111000.99 12054 7.2 60.1 0.0184424
ne 1986 1.29 5.0 13971.104 65.47922 0.4643963 0.78620 0.484570 21.00 0.037110 0.188938 7867.966 yes no no 290 68 40 23 4 40 15 46 24 78.750 1597998.8 70999.93 80000.00 100999.01 12573 7.0 60.7 0.0077134
ne 1987 1.26 4.9 14300.000 65.31303 0.4668750 0.82250 0.500300 21.00 0.037200 0.180938 8212.686 yes no no 297 54 36 35 2 35 12 37 16 67.892 1593997.5 70999.96 76999.23 97000.84 13091 6.2 61.5 -0.0277117
ne 1988 1.24 3.6 14219.441 66.35828 0.4980751 0.86040 0.516560 21.00 0.037200 0.162372 8368.896 yes no no 261 55 35 22 4 33 11 23 10 90.514 1602003.4 68999.91 70999.80 99001.38 13407 5.5 62.3 0.0314361
nv 1982 4.90 10.1 14914.081 65.95744 0.1610979 2.02290 6.397020 21.00 0.000000 0.192366 7304.109 no no no 280 53 34 9 1 39 16 50 12 96.342 877998.9 41999.95 42000.00 64000.00 6413 9.7 57.8 -0.0297069
nv 1983 4.75 9.8 14863.532 65.27571 0.1999713 2.03450 6.159440 21.00 0.000000 0.191312 7661.085 yes yes yes 253 41 25 12 1 32 8 27 8 57.919 897000.9 40999.99 42000.00 64000.76 6872 9.6 57.9 0.0372155
nv 1984 4.65 7.8 15214.286 66.76301 0.2225275 2.04610 5.930700 21.00 0.000000 0.192364 7995.649 yes yes yes 249 27 19 13 3 24 5 32 7 59.231 916998.7 39000.04 42000.00 64999.70 7332 7.5 59.5 0.0521997
nv 1985 4.40 8.0 15564.618 66.01942 0.2145127 2.05780 5.710440 21.00 0.000000 0.165754 8083.322 yes yes yes 259 44 24 11 3 20 8 38 8 67.328 936001.3 39000.04 42000.00 64999.49 7566 7.2 60.1 0.0564310
nv 1986 4.12 6.0 15976.265 67.84261 0.2089783 2.06960 5.498370 21.00 0.000000 0.160077 8253.348 yes yes yes 233 45 28 12 2 30 9 32 13 69.908 967001.6 40999.99 42000.00 61999.88 7981 7.0 60.7 0.0561900
nv 1987 4.01 6.3 16412.000 68.23530 0.2025000 2.08140 5.294170 21.00 0.000000 0.155419 8337.645 yes yes yes 262 45 26 13 3 22 5 30 10 68.771 1006999.1 41999.97 42999.83 62000.12 8396 6.2 61.5 0.0713571
nv 1988 3.89 5.2 16853.705 69.25000 0.1948989 2.09330 5.097560 21.00 0.000000 0.136147 8528.455 yes yes yes 286 46 32 8 1 24 7 42 9 75.351 1054001.0 40999.99 40999.71 66000.38 8989 5.5 62.3 0.1049200
nh 1982 4.57 7.4 13834.129 63.09859 0.4832936 0.10000 0.300000 20.00 0.108330 0.194978 7353.357 no no no 173 34 28 16 5 26 6 30 14 79.725 948002.3 46999.94 54426.32 70999.20 6971 9.7 57.8 0.0239287
nh 1983 4.60 5.4 14662.844 65.60332 0.5676606 0.10000 0.300000 20.00 0.104280 0.190771 7488.016 yes no no 191 35 29 21 6 35 7 26 9 63.049 958999.1 46999.95 54569.18 70999.45 7181 9.6 57.9 0.0877803
nh 1984 4.58 4.3 15451.648 67.61517 0.7417582 0.10000 0.300000 20.00 0.172490 0.182961 7458.077 yes no no 192 23 12 11 1 24 3 36 6 70.519 978000.1 46000.09 54712.41 71000.31 7294 7.5 59.5 0.0829000
nh 1985 4.36 3.9 16280.721 68.29590 0.7150424 0.10000 0.300000 20.00 0.160320 0.177788 7553.116 yes no no 191 24 18 12 4 21 3 36 4 72.600 997998.8 45999.92 54856.02 71000.31 7538 7.2 60.1 0.0769000
nh 1986 4.05 2.8 17132.096 69.96149 0.6965944 0.10000 0.300000 20.50 0.155790 0.172651 8133.395 yes no no 172 27 18 16 3 26 9 17 3 48.037 1027000.5 48999.94 55000.00 65998.91 8353 7.0 60.7 0.0877444
nh 1987 3.90 2.5 17906.000 71.26865 0.6750000 0.10000 0.300000 21.00 0.151370 0.167907 8672.647 yes no no 179 25 18 23 2 16 5 28 7 53.200 1057001.4 48999.97 54999.83 66000.38 9167 6.2 61.5 0.1423609
nh 1988 3.79 2.4 18704.523 70.83839 0.6496632 0.10000 0.300000 21.00 0.151370 0.156750 8762.188 yes no no 166 22 11 13 0 28 4 28 7 43.716 1085002.9 48000.06 50999.96 71999.79 9507 5.5 62.3 0.0498003
nj 1982 2.24 9.0 16665.871 57.85789 0.0894988 0.10000 0.100000 19.00 2.817460 0.175159 6971.983 no no no 1061 263 157 73 16 143 55 147 71 270.675 7430023.5 404999.78 372372.81 489005.69 51802 9.7 57.8 0.0095634
nj 1983 2.24 7.8 17275.229 58.57415 0.0860092 0.10000 0.100000 21.00 2.799950 0.168256 6992.092 no no no 932 210 127 59 16 109 44 138 59 232.000 7468008.5 393000.59 370515.75 492998.00 52217 9.6 57.9 0.0659496
nj 1984 2.18 6.2 18065.934 61.51868 0.0824176 0.10000 0.100000 21.00 2.784850 0.160739 6959.141 no no no 922 152 88 64 12 98 26 121 33 211.628 7517019.5 382000.62 368667.97 500000.00 52312 7.5 59.5 0.0668847
nj 1985 2.15 5.7 18662.076 61.69705 0.0794492 0.10000 0.100000 21.00 2.768280 0.149365 7023.037 no no no 964 171 109 54 9 103 34 119 37 203.463 7561970.5 374000.06 366829.41 502003.78 53108 7.2 60.1 0.0409840
nj 1986 2.06 5.0 19421.053 62.40753 0.0773994 0.10000 0.100000 21.00 2.819670 0.142315 7224.902 no no no 1039 182 107 76 9 95 28 128 39 205.063 7625017.0 361999.56 364999.97 466999.88 55090 7.0 60.7 0.0595220
nj 1987 2.01 4.0 20313.000 63.41220 0.0750000 0.10000 0.100000 21.00 2.802400 0.129432 7438.867 no no no 1023 171 117 65 14 98 22 123 32 204.244 7672001.5 350000.53 354995.31 454999.44 57071 6.2 61.5 0.0939028
nj 1988 1.84 3.8 21168.432 63.39523 0.0721848 0.10000 0.100000 21.00 2.802400 0.116541 7598.872 no no no 1051 200 135 67 11 112 29 137 55 206.967 7721014.5 330000.50 343000.66 477002.91 58671 5.5 62.3 0.0633851
nm 1982 1.58 9.2 11347.255 55.88843 0.2416468 9.81280 2.222860 21.00 1.192200 0.208908 8662.289 no no no 577 117 60 37 11 66 20 91 19 163.950 1367998.8 76000.02 77136.49 101999.98 11850 9.7 57.8 -0.0281868
nm 1983 1.66 10.1 11288.991 55.14113 0.3483372 9.67230 2.234380 21.00 1.381300 0.208833 8329.537 no no no 531 83 44 28 4 59 10 66 16 137.310 1401998.8 74000.08 76850.78 104000.06 11678 9.6 57.9 0.0035810
nm 1984 1.38 7.5 11539.561 57.46785 0.4450549 9.53380 2.245960 21.00 1.209300 0.208642 8718.084 no no no 497 96 45 18 4 45 12 85 19 121.740 1426001.4 72000.00 76566.14 104999.98 12432 7.5 59.5 0.0386681
nm 1985 1.41 8.8 11861.229 57.10117 0.4290254 9.39730 2.257600 21.00 1.086900 0.201913 9151.046 no no no 535 115 58 40 14 63 19 79 25 132.290 1449998.1 71000.03 76282.55 104000.05 13269 7.2 60.1 0.0159569
nm 1986 1.31 9.2 11825.594 58.33333 0.4179567 9.26270 2.269300 21.00 1.081800 0.222498 9596.345 no no no 499 88 48 32 10 59 17 69 23 123.000 1479000.6 72000.07 76000.00 96000.00 14193 7.0 60.7 -0.0373823
nm 1987 1.24 8.9 11898.000 57.96831 0.4050000 9.13000 2.281060 21.00 1.066700 0.220807 10077.343 no no no 568 97 55 33 5 53 10 78 20 160.350 1499998.6 72000.05 73999.61 94000.02 15116 6.2 61.5 -0.0541545
nm 1988 1.25 7.8 12019.249 58.57934 0.3897979 8.99930 2.292880 21.00 1.066700 0.220724 10141.354 no no no 487 92 51 31 18 45 14 57 12 161.470 1506998.0 70000.02 69999.69 93999.99 15283 5.5 62.3 0.0135970
ny 1982 2.16 8.6 15158.711 54.31521 0.1193317 0.10000 0.100000 19.00 0.208400 0.167705 4576.346 yes no no 2162 477 272 129 29 288 131 298 108 546.860 17586958.0 913002.88 922604.56 1218998.38 80484 9.7 57.8 0.0020746
ny 1983 2.06 8.6 15573.395 54.35151 0.1328555 0.10000 0.100000 19.00 0.201000 0.163121 4737.511 yes no no 2077 436 260 121 23 269 96 248 87 495.690 17685024.0 885999.06 910465.94 1224999.88 83783 9.6 57.9 0.0627833
ny 1984 2.05 7.2 16335.165 55.05173 0.1360000 0.10000 0.100000 19.00 0.177400 0.161692 4917.594 yes no no 2060 360 214 108 18 241 80 246 75 443.910 17746076.0 858000.88 898487.00 1224002.38 87268 7.5 59.5 0.0563927
ny 1985 1.94 6.5 16708.686 56.74925 0.1311017 0.10000 0.100000 19.16 0.183800 0.155274 5090.125 yes no no 2006 376 211 126 29 202 75 263 91 424.420 17783058.0 838000.00 886665.75 1214001.12 90518 7.2 60.1 0.0392643
ny 1986 1.82 6.3 17326.109 57.38864 0.1277193 0.10000 0.100000 21.00 0.179800 0.155271 5296.995 yes no no 2122 381 236 146 24 232 73 257 85 430.180 17794996.0 827997.62 875000.00 1108002.12 94260 7.0 60.7 0.0514966
ny 1987 1.78 4.9 18005.000 58.67354 0.1237600 0.10000 0.100000 21.00 0.179500 0.151975 5498.026 yes no no 2333 397 236 157 34 235 61 304 97 479.830 17824944.0 796000.69 848988.38 1074000.00 98002 6.2 61.5 0.0284298
ny 1988 1.71 4.2 18580.365 59.17125 0.1191145 0.10000 0.100000 21.00 0.179500 0.148806 5789.922 yes no no 2255 391 235 126 17 227 82 281 95 418.580 17909050.0 748000.88 802999.81 1138998.38 103692 5.5 62.3 0.0497645
nc 1982 1.64 9.0 11078.759 60.30207 1.4319810 22.37790 0.426410 21.00 27.629299 0.210607 7164.226 yes no no 1303 243 161 99 19 169 52 175 51 683.820 6016002.5 300000.00 355732.28 470999.84 43100 9.7 57.8 -0.0129525
nc 1983 1.56 8.9 11455.275 59.55457 1.3761468 22.16980 0.440260 21.00 26.746099 0.207260 7411.233 yes no no 1234 212 136 109 19 143 44 177 55 341.620 6076991.5 292999.72 353018.31 469999.69 45038 9.6 57.9 0.0797451
nc 1984 1.53 6.7 12089.011 61.85477 1.3186814 21.96370 0.454560 21.00 26.110901 0.199802 7814.157 yes no no 1450 227 137 96 11 150 34 213 68 373.140 6165988.5 288000.28 350325.06 466999.78 48182 7.5 59.5 0.0825915
nc 1985 1.50 5.4 12353.813 63.17481 1.2711865 21.75940 0.469320 21.00 25.579500 0.194195 7981.280 yes no no 1482 229 150 103 12 172 47 234 63 345.330 6255012.0 287999.91 347652.31 459999.66 49923 7.2 60.1 0.0306999
nc 1986 1.45 5.3 12839.010 63.58064 1.2383901 21.55710 0.484570 21.00 26.027201 0.189738 8254.921 yes no no 1647 251 171 117 20 174 44 228 66 409.680 6331011.5 308999.81 345000.00 426999.84 52262 7.0 60.7 0.0483391
nc 1987 1.40 4.5 13325.000 65.08531 1.2000000 21.35660 0.500300 21.00 25.694401 0.185425 8513.946 yes no no 1584 239 158 126 15 154 45 228 64 353.440 6413007.0 309000.00 341002.19 420999.78 54600 6.2 61.5 0.0777139
nc 1988 1.34 3.6 13767.084 65.60706 1.1549567 21.15800 0.516560 21.00 25.694401 0.175695 8929.410 yes no no 1573 206 141 102 14 161 36 186 43 373.830 6489006.5 300000.00 316997.78 428000.44 57943 5.5 62.3 0.0413293
nd 1982 2.12 5.9 12553.699 62.00417 0.4295943 0.56010 0.182770 21.00 0.000000 0.228972 7815.473 yes no no 148 34 20 14 5 27 6 23 7 78.750 672000.3 33000.04 38843.15 54999.98 5252 9.7 57.8 -0.0474600
nd 1983 1.98 5.6 12389.908 61.80698 0.4128441 0.59280 0.174720 21.00 0.000000 0.221059 7875.196 yes no no 116 30 23 11 1 9 4 24 9 72.000 680998.9 30999.97 37844.51 54000.05 5363 9.6 57.9 -0.0663469
nd 1984 1.85 5.1 12690.110 63.39468 0.3956044 0.62740 0.167020 21.00 0.000000 0.209677 7826.761 yes no no 100 15 9 5 1 12 2 17 5 58.000 687001.9 29999.94 36871.54 52999.95 5377 7.5 59.5 0.0356677
nd 1985 1.85 5.9 12661.017 64.47639 0.3813559 0.66410 0.159660 21.00 0.000000 0.201548 7864.242 yes no no 90 29 23 6 2 12 6 15 11 36.140 684999.2 28999.94 35923.59 50000.00 5387 7.2 60.1 -0.0434199
nd 1986 1.59 6.3 12817.338 64.27104 0.3715170 0.70290 0.152630 21.00 0.000000 0.194245 8150.198 yes no no 100 13 8 7 2 9 2 12 1 31.090 679001.9 30000.04 35000.00 44999.95 5534 7.0 60.7 -0.0250731
nd 1987 1.65 5.2 12971.000 65.08264 0.3600000 0.74390 0.145900 21.00 0.000000 0.185437 8453.891 yes no no 101 29 20 6 2 10 4 13 7 40.380 671998.3 28999.94 33000.03 42999.94 5681 6.2 61.5 -0.0797524
nd 1988 1.65 4.8 12351.300 65.56017 0.3464870 0.78740 0.139480 21.00 0.000000 0.171434 8643.176 yes no no 104 18 16 6 0 12 4 19 6 37.130 667000.2 27999.96 30000.00 42000.00 5765 5.5 62.3 -0.0517941
oh 1982 1.27 12.5 13039.380 55.61218 0.4295943 1.50870 0.200000 21.00 11.602000 0.225714 6659.627 no no no 1607 421 271 130 19 221 88 223 101 643.130 10774027.0 552000.56 582422.00 783999.38 71751 9.7 57.8 -0.0544071
oh 1983 1.24 12.2 13236.238 55.74505 0.4128441 1.56620 0.200000 21.00 11.640900 0.199801 6818.204 no yes no 1582 383 264 129 26 201 74 231 95 744.280 10738019.0 530000.50 568580.88 765998.94 73214 9.6 57.9 0.0217185
oh 1984 1.16 9.4 13784.615 57.32587 0.3956044 1.62580 0.200000 21.00 9.311000 0.194478 6973.471 no yes no 1646 408 258 131 23 217 88 226 91 877.440 10739989.0 514999.88 555068.69 751000.19 74895 7.5 59.5 0.0647631
oh 1985 1.18 8.9 13992.585 57.96384 0.3813559 1.68780 0.200000 21.00 9.307500 0.180359 7031.749 no yes no 1646 357 222 113 18 207 75 218 85 897.920 10743985.0 506999.28 541877.62 732000.50 75549 7.2 60.1 0.0193256
oh 1986 1.17 8.1 14279.670 59.31869 0.3715170 1.75210 0.200000 21.00 9.304100 0.174852 7196.974 no yes no 1673 407 267 129 25 205 82 285 104 843.840 10747990.0 526000.31 529000.00 691999.50 77353 7.0 60.7 0.0233446
oh 1987 1.14 7.0 14598.000 59.85544 0.3600000 1.81880 0.200000 21.00 9.273000 0.171218 7340.248 no no no 1772 383 249 155 18 204 85 229 76 684.690 10783968.0 517999.66 518003.16 677000.06 79157 6.2 61.5 0.0255821
oh 1988 1.06 6.0 14952.839 60.74074 0.3464870 1.88810 0.200000 21.00 9.273000 0.159994 7553.218 no no no 1763 379 230 130 16 215 61 204 91 567.840 10854976.0 498000.31 494003.03 670999.69 81990 5.5 62.3 0.0404018
ok 1982 1.56 5.7 13552.506 59.61702 0.8663484 26.42230 0.560110 21.00 0.000000 0.207455 9288.461 no no no 1054 234 119 72 15 130 42 164 52 321.110 3230998.0 154000.16 170964.77 241999.98 30011 9.7 57.8 0.0138726
ok 1983 1.46 9.0 12784.403 58.44371 0.8325688 26.43340 0.592820 21.00 0.000000 0.202159 8929.328 no no no 848 152 90 43 11 88 26 103 23 236.370 3310999.5 151000.11 169964.84 245000.09 29565 9.6 57.9 -0.0608553
ok 1984 1.41 7.0 12881.318 59.63681 0.9473901 26.44460 0.627440 21.00 0.000000 0.197189 9359.799 no no no 797 150 83 47 15 79 21 89 24 217.620 3310007.0 145999.92 168970.75 238999.97 30981 7.5 59.5 0.0082761
ok 1985 1.29 7.1 12904.661 60.39069 0.9613348 26.45570 0.664080 21.00 0.000000 0.187404 9445.915 no no no 744 124 77 47 8 82 24 84 27 204.180 3301003.5 143000.14 167982.48 230000.23 31181 7.2 60.1 -0.0212907
ok 1986 1.17 8.2 12656.347 60.89293 0.9365326 26.46690 0.702860 21.00 0.000000 0.180598 9496.078 no no no 699 127 71 58 19 59 19 97 22 177.350 3305996.2 151999.97 167000.00 210999.84 31394 7.0 60.7 -0.0454976
ok 1987 1.09 7.4 12607.000 60.30820 0.9075000 26.47800 0.743910 21.00 0.000000 0.171738 9659.524 no no no 597 97 59 40 15 55 18 65 19 147.880 3272003.8 149000.20 160000.00 203000.03 31606 6.2 61.5 -0.0785221
ok 1988 1.06 6.7 12822.906 59.59765 0.8734360 26.48920 0.787350 21.00 0.000000 0.161580 9990.114 no no no 634 102 71 49 8 73 23 76 17 166.340 3242005.0 143999.91 148000.97 198000.20 32388 5.5 62.3 0.0139080
or 1982 1.68 11.5 12626.491 58.46230 0.2251909 1.02370 2.800000 21.00 0.192900 0.187434 7262.638 no no no 518 90 59 30 8 66 14 64 24 163.380 2669002.5 123000.22 128896.99 182999.89 19384 9.7 57.8 -0.0712934
or 1983 1.64 10.8 12925.459 59.56175 0.2164106 1.03570 2.800000 21.00 0.193600 0.177793 7728.198 no no no 550 92 55 33 8 64 11 79 21 165.050 2659999.0 118000.01 126612.74 178000.09 20557 9.6 57.9 0.0343776
or 1984 1.58 9.4 13246.154 59.76273 0.2073736 1.04790 2.800000 21.00 0.192500 0.174122 7826.238 no yes yes 572 78 61 47 8 62 10 83 16 153.780 2675998.2 116000.12 124368.96 174000.19 20943 7.5 59.5 0.0541632
or 1985 1.50 8.8 13376.060 59.29946 0.1999047 1.06030 2.800000 21.00 0.200600 0.165584 7985.869 no yes yes 559 74 50 39 10 53 11 79 17 150.370 2686996.2 115999.96 122164.95 168999.86 21458 7.2 60.1 0.0173024
or 1986 1.43 8.5 13649.123 60.55447 0.1947472 1.07280 2.800000 21.00 0.203900 0.165853 8288.321 no yes yes 619 69 40 48 4 60 11 69 15 176.430 2701994.8 121999.88 119999.99 165999.86 22395 7.0 60.7 0.0331698
or 1987 1.40 6.2 14019.000 62.47601 0.1887100 1.08540 2.800000 21.00 0.202300 0.159338 8565.328 no yes yes 620 57 44 53 6 73 12 74 17 144.540 2724005.5 117999.88 118000.78 162000.05 23332 6.2 61.5 0.0226403
or 1988 1.38 5.8 14326.275 63.25954 0.1816266 1.09820 2.800000 21.00 0.202300 0.151539 9108.771 no yes yes 677 95 57 57 10 83 17 68 17 153.900 2767003.5 112999.95 117000.28 158999.98 25204 5.5 62.3 0.0578641
pa 1982 1.36 10.9 13651.552 53.45506 0.2863962 0.10000 0.233310 21.00 10.763100 0.183376 6003.269 yes no no 1819 432 234 126 16 216 80 282 110 581.090 11879029.0 594999.19 629687.38 846000.81 71313 9.7 57.8 -0.0358291
pa 1983 1.32 11.8 13706.422 52.90976 0.2752294 0.10000 0.251980 21.00 10.703600 0.176879 6080.384 yes no no 1721 397 237 109 14 211 68 253 102 533.420 11891025.0 576000.31 617411.12 833001.38 72302 9.6 57.9 0.0207041
pa 1984 1.31 9.1 13987.912 54.15987 0.2637362 0.10000 0.272160 21.00 10.941800 0.170683 6250.283 yes no no 1727 359 239 110 15 186 73 236 90 497.130 11886981.0 556998.69 605374.31 815999.12 74297 7.5 59.5 0.0433327
pa 1985 1.29 8.0 14356.991 55.23685 0.2542373 0.10000 0.293950 21.00 10.972700 0.166263 6363.636 yes no no 1771 409 253 108 14 178 62 261 110 567.760 11852972.0 541000.88 593572.12 792999.69 75428 7.2 60.1 0.0206657
pa 1986 1.27 6.8 14713.106 56.80441 0.2476780 0.10000 0.317480 21.00 10.774700 0.161688 6476.124 yes no no 1894 438 291 138 31 213 67 263 115 618.520 11893997.0 547999.62 582000.00 735000.25 77027 7.0 60.7 0.0337199
pa 1987 1.23 5.7 15200.000 57.35642 0.2400000 0.10000 0.342900 21.00 10.807600 0.156139 6587.292 yes no no 1987 442 242 111 18 202 74 265 113 647.830 11936013.0 535998.88 566000.75 715999.50 78626 6.2 61.5 0.0480365
pa 1988 1.14 5.1 15623.677 58.54651 0.2309913 0.10000 0.370350 21.00 10.807600 0.149836 6769.258 yes no no 1931 405 252 110 13 215 67 245 93 574.010 12001019.0 511999.41 530000.50 732999.62 81238 5.5 62.3 0.0433613
ri 1982 2.09 10.2 13326.969 58.60656 0.1742243 0.10000 0.100000 20.00 1.695400 0.196667 6192.878 yes no no 105 36 20 9 4 18 10 18 6 31.800 953999.1 46000.04 55891.46 74000.07 5908 9.7 57.8 -0.0257270
ri 1983 2.13 8.3 13759.174 59.18367 0.1674312 0.10000 0.100000 20.00 1.694600 0.190400 6290.825 yes no no 100 26 22 6 0 12 3 16 7 27.530 955995.5 43999.88 54892.11 74000.08 6014 9.6 57.9 0.0459322
ri 1984 2.06 5.3 14312.088 62.53370 0.1604396 0.10000 0.100000 20.50 1.470900 0.181669 5509.383 yes no no 79 24 17 5 1 10 5 16 5 24.600 961995.1 43000.03 53910.62 72000.07 5300 7.5 59.5 0.0740321
ri 1985 2.07 4.9 14595.339 63.63636 0.1546610 0.10000 0.100000 21.00 1.678700 0.177523 6015.479 yes no no 109 32 17 9 1 13 7 28 13 30.700 968002.7 41999.95 52946.70 70000.00 5823 7.2 60.1 0.0415732
ri 1986 1.87 4.0 15109.392 64.72148 0.1506708 0.10000 0.100000 21.00 1.756000 0.172161 6064.592 yes no no 124 25 17 7 1 17 3 14 4 47.140 975003.8 43999.98 52000.00 63000.06 5913 7.0 60.7 0.0610067
ri 1987 1.88 3.8 15633.000 65.48557 0.1460000 0.10000 0.100000 21.00 1.744400 0.167711 6088.211 yes no no 113 31 23 5 1 15 4 24 13 42.550 986003.9 43000.03 50999.94 60999.94 6003 6.2 61.5 0.0535684
ri 1988 1.93 3.1 16257.940 66.27605 0.1405197 0.10000 0.100000 21.00 1.744400 0.158109 5894.251 yes no no 125 30 21 8 3 13 8 13 8 37.500 993001.4 40999.99 45999.95 65000.00 5853 5.5 62.3 0.0419318
sc 1982 1.88 10.8 10393.795 57.82402 2.0620525 25.13580 0.400000 21.00 0.000000 0.211843 7508.355 no no no 730 140 95 62 15 77 23 101 28 219.600 3226006.0 172000.06 195651.41 259999.69 24222 9.7 57.8 -0.0232433
sc 1983 1.93 10.0 10693.808 56.51431 1.9816514 24.85830 0.400000 21.00 0.000000 0.208084 7666.370 no yes yes 844 175 100 58 12 88 26 131 42 277.130 3257995.5 165999.80 194222.98 258999.77 24977 9.6 57.9 0.0598180
sc 1984 1.91 7.1 11160.439 57.83943 1.8989011 24.58390 0.400000 21.00 0.000000 0.198571 7865.243 no yes yes 916 142 95 55 7 82 21 130 36 320.700 3301995.8 162000.09 192805.00 261000.16 25971 7.5 59.5 0.0767706
sc 1985 1.90 6.8 11369.703 59.90936 1.8305085 24.31250 0.400000 21.00 0.000000 0.193221 7970.419 no yes yes 951 175 102 56 7 111 35 144 37 400.050 3347000.8 160000.00 191397.38 254999.95 26677 7.2 60.1 0.0188054
sc 1986 1.77 6.2 11674.923 60.85540 1.7832818 24.04420 0.400000 21.00 0.000000 0.188851 8414.968 no yes yes 1059 192 119 67 13 95 24 153 49 485.390 3380999.2 168999.88 189999.98 231999.91 28451 7.0 60.7 0.0416201
sc 1987 1.69 5.6 12027.000 61.76353 1.7280000 23.77880 0.400000 21.00 0.000000 0.185350 8824.518 no yes yes 1086 197 124 73 11 131 40 141 46 377.770 3425003.0 169999.91 186999.94 228999.83 30224 6.2 61.5 0.0747457
sc 1988 1.70 4.5 12440.809 62.61350 1.6631377 23.51630 0.400000 21.00 0.000000 0.169980 9152.459 no yes yes 1034 188 130 72 15 115 32 133 40 321.600 3469996.5 168000.17 170999.91 237000.19 31759 5.5 62.3 0.0542324
sd 1982 1.83 5.5 11323.389 62.72545 0.7183771 0.65660 0.380649 21.00 0.000000 0.242798 9165.686 yes no no 148 30 27 7 3 15 1 27 10 54.340 694001.6 35000.00 39847.16 53000.00 6361 9.7 57.8 -0.0349467
sd 1983 1.79 5.4 11091.743 62.69841 0.6903670 0.68680 0.371327 21.00 0.000000 0.229347 9037.208 yes no no 175 23 19 11 4 12 4 22 3 47.000 698999.1 33000.03 38848.44 51999.99 6317 9.6 57.9 -0.0183846
sd 1984 1.67 4.3 11661.538 64.89152 0.6615385 0.71850 0.362234 21.00 0.000000 0.219713 9079.438 yes no no 143 25 18 12 3 17 5 24 8 50.640 704999.6 32000.00 37874.76 52000.05 6401 7.5 59.5 0.0803718
sd 1985 1.76 5.1 11684.322 64.42687 0.6377119 0.75160 0.353363 21.00 0.000000 0.209174 8865.828 yes no no 130 17 11 11 1 7 2 22 5 34.900 707999.3 30999.97 36925.48 48999.96 6277 7.2 60.1 -0.0067439
sd 1986 1.47 4.7 12175.438 65.16634 0.6212590 0.78620 0.344710 21.00 0.000000 0.199289 8817.817 yes no no 134 23 17 6 2 14 6 20 6 36.090 707998.3 32000.00 36000.00 43000.03 6243 7.0 60.7 0.0271174
sd 1987 1.50 4.2 12545.000 66.01942 0.6092530 0.82250 0.336268 21.00 0.000000 0.193110 8757.423 yes no no 134 14 10 8 1 15 2 17 4 30.040 708998.5 30999.94 35000.04 41999.99 6209 6.2 61.5 -0.0334714
sd 1988 1.45 3.9 12276.228 66.21622 0.5933648 0.86040 0.328033 21.00 0.000000 0.179332 9304.343 yes no no 147 23 16 12 1 16 8 18 4 42.730 713000.4 30000.00 32000.00 42999.96 6634 5.5 62.3 -0.0034753
tn 1982 1.35 11.8 10988.066 53.99885 0.3380943 25.83650 0.200000 19.00 1.886400 0.198828 7458.300 no yes no 1055 243 153 84 13 154 54 143 50 386.770 4665004.0 234999.88 255683.08 341999.72 34793 9.7 57.8 -0.0190983
tn 1983 1.34 11.5 11183.486 55.06419 0.3249117 25.65670 0.200000 19.00 1.876700 0.193916 7733.209 no yes no 1037 193 111 53 10 153 42 141 38 377.890 4688997.5 227000.17 252969.42 339999.91 36261 9.6 57.9 0.0414893
tn 1984 1.35 8.6 11704.396 57.31225 0.3113439 25.47810 0.200000 19.67 1.862000 0.183345 7728.100 no yes no 1095 213 128 65 10 151 51 165 42 388.720 4726000.0 220999.72 250284.55 338999.78 36523 7.5 59.5 0.0754379
tn 1985 1.32 8.0 11919.491 57.64738 0.3001303 25.30070 0.200000 21.00 1.848000 0.187638 7614.016 no yes no 1101 183 114 65 8 117 23 177 58 324.310 4762007.5 219999.67 247628.17 335000.16 36258 7.2 60.1 0.0303716
tn 1986 1.24 8.0 12371.517 58.03252 0.2923870 25.12460 0.200000 21.00 0.000000 0.174572 8165.000 no yes no 1230 233 148 90 10 158 51 175 57 395.690 4800000.0 233000.05 244999.98 307999.91 39192 7.0 60.7 0.0429537
tn 1987 1.21 6.6 12876.000 59.23913 0.2833230 24.94970 0.200000 21.00 0.000000 0.168929 8676.843 no yes no 1248 225 135 97 20 150 45 152 46 376.370 4854992.0 233999.95 241999.89 304999.78 42126 6.2 61.5 0.0785765
tn 1988 1.18 5.8 13352.262 59.20451 0.2726882 24.77600 0.200000 21.00 0.000000 0.168742 9028.183 no yes no 1266 230 145 79 16 173 46 156 48 398.480 4895005.0 228000.16 224999.97 310999.81 44193 5.5 62.3 0.0394782
tx 1982 1.56 6.9 13942.721 62.65511 0.4331742 18.20490 0.525400 19.00 11.317800 0.208686 8144.788 no no no 4213 1049 603 237 72 526 196 632 228 2094.900 15374004.0 767000.19 842419.25 1186999.25 125218 9.7 57.8 -0.0160661
tx 1983 1.48 8.0 13692.660 62.31614 0.4162844 17.96230 0.538600 19.00 11.178600 0.200634 8338.572 no no no 3823 915 507 207 51 471 176 592 208 1812.500 15816016.0 759000.81 843562.06 1196000.75 131883 9.6 57.9 -0.0025605
tx 1984 1.48 5.9 14039.561 64.55586 0.4188462 17.72290 0.552100 19.00 7.125300 0.193534 8564.129 no no no 3912 886 530 227 39 455 167 600 224 1852.470 16083013.0 748999.44 844706.50 1188999.38 137737 7.5 59.5 0.0492319
tx 1985 1.37 7.0 14270.127 63.91252 0.4614407 17.48670 0.566000 19.00 7.000400 0.184567 8751.546 no no no 3678 811 477 256 53 388 131 523 174 1471.020 16370022.0 750999.62 845852.50 1175001.00 143263 7.2 60.1 0.0252270
tx 1986 1.21 8.9 13950.465 62.00167 0.4495356 17.25370 0.580200 19.67 6.866600 0.175312 8821.696 no no no 3567 788 479 279 76 420 134 485 163 1267.300 16688968.0 813999.62 847000.06 1122999.75 147225 7.0 60.7 -0.0388001
tx 1987 1.13 8.4 13889.000 62.93584 0.4356000 17.02370 0.594800 21.00 6.825700 0.167624 9005.048 no no no 3261 688 402 231 43 385 121 437 136 1034.480 16789028.0 814998.81 829991.81 1100999.75 151186 6.2 61.5 -0.0330688
tx 1988 1.09 7.3 14038.499 64.13017 0.4192493 16.79680 0.609700 21.00 6.825700 0.155518 9290.322 no no no 3393 752 458 247 70 404 129 432 136 1145.630 16840966.0 790000.56 778000.38 1066000.75 156458 5.5 62.3 0.0236797
ut 1982 0.91 7.8 10788.783 61.16027 0.3568401 0.70000 65.916496 21.00 1.604600 0.240700 7012.183 no no no 295 46 24 26 4 35 12 42 10 62.300 1558002.6 73000.08 87822.10 129000.16 10925 9.7 57.8 -0.0094779
ut 1983 0.84 9.2 10779.816 60.03824 0.6292546 0.70000 65.186997 21.00 1.605000 0.232819 7035.091 no yes yes 283 45 23 25 3 29 9 27 7 67.740 1595004.2 72000.05 87107.91 127000.26 11221 9.6 57.9 0.0409858
ut 1984 0.86 6.5 11120.879 62.66667 0.8773484 0.70000 64.465599 21.00 1.848400 0.218515 7184.842 no yes yes 315 51 28 22 4 38 5 34 8 78.060 1623000.2 71999.90 86399.53 125000.00 11661 7.5 59.5 0.0748268
ut 1985 0.89 5.9 11284.958 64.62841 0.8457489 0.70000 63.752201 21.00 1.854100 0.214632 7317.344 no yes yes 303 36 22 20 1 25 6 43 6 63.310 1644995.8 72999.89 85696.91 122000.01 12037 7.2 60.1 0.0275272
ut 1986 0.89 6.0 11339.525 65.83101 0.8239288 0.70000 63.046700 21.00 1.832900 0.207449 7426.684 no yes yes 313 34 25 33 6 36 5 33 3 54.960 1663999.8 82000.00 85000.00 121000.12 12358 7.0 60.7 0.0093475
ut 1987 0.84 6.4 11389.000 65.22540 0.7983870 0.70000 62.348999 21.00 1.190500 0.194580 7547.003 no yes yes 296 48 29 31 6 35 15 32 9 56.800 1680004.5 83999.91 83999.33 119999.85 12679 6.2 61.5 -0.0062180
ut 1988 0.82 4.9 11735.322 65.81586 0.7684187 0.70000 61.659000 21.00 1.190500 0.183352 7847.945 no yes yes 297 29 21 29 3 23 7 31 4 71.500 1689996.6 84000.02 83999.85 111000.12 13263 5.5 62.3 0.0374378
vt 1982 2.39 6.9 12064.439 63.56589 0.7115155 0.10670 0.281400 18.00 0.273300 0.188732 7678.837 yes no no 107 18 10 6 0 27 8 14 6 27.760 520000.6 26000.03 32127.53 42000.04 3993 9.7 57.8 0.0001280
vt 1983 2.31 6.9 12186.927 63.01020 0.6837729 0.11000 0.272600 18.00 0.285700 0.186244 7906.684 yes no no 94 19 11 8 2 19 2 21 9 34.100 524998.9 25000.00 31841.86 42000.00 4151 9.6 57.9 0.0670786
vt 1984 2.24 5.2 12680.220 64.39394 0.6552198 0.11330 0.264000 18.00 0.506600 0.175202 8307.534 yes no no 114 18 16 10 4 23 6 15 3 31.810 530000.8 25000.00 31558.73 40999.96 4403 7.5 59.5 0.0605483
vt 1985 2.13 4.8 13112.288 65.92040 0.6316208 0.11670 0.255700 18.00 0.339800 0.173699 8762.605 yes no no 115 23 15 8 1 14 4 16 8 36.350 535000.7 24000.02 31278.12 40999.99 4688 7.2 60.1 0.0575088
vt 1986 2.03 4.7 13740.970 68.30467 0.6153251 0.12010 0.247600 19.50 0.340300 0.169052 8990.770 yes no no 109 19 14 7 0 14 0 19 11 33.420 540999.3 27000.03 31000.00 35000.01 4864 7.0 60.7 0.0629428
vt 1987 1.93 3.6 14325.000 69.00726 0.5962500 0.12360 0.239900 21.00 0.335900 0.169162 9195.244 yes no no 119 14 11 10 1 18 2 22 6 38.950 548000.7 26000.03 30000.00 35000.02 5039 6.2 61.5 0.1047678
vt 1988 1.82 2.8 14727.623 68.95734 0.5738691 0.12730 0.232300 21.00 0.335900 0.159200 9969.486 yes no no 129 27 12 12 3 19 7 15 7 39.040 556999.6 25000.00 28000.06 37999.98 5553 5.5 62.3 0.0577719
va 1982 1.70 7.7 13878.281 60.84577 0.7589499 12.70810 0.525400 21.00 0.000000 0.208276 7547.831 yes no no 881 177 115 71 14 125 41 117 38 252.700 5488994.0 282000.06 315716.34 425999.84 41430 9.7 57.8 0.0067459
va 1983 1.62 6.1 14299.312 62.64087 0.7293578 12.61320 0.538600 21.00 0.000000 0.202384 7609.125 yes no no 901 179 116 51 11 137 49 124 34 268.260 5558983.0 274000.56 313002.47 427000.19 42299 9.6 57.9 0.0720425
va 1984 1.58 5.0 14906.594 64.89285 0.6989011 12.51910 0.552100 21.00 0.000000 0.197191 7900.444 yes no no 1013 213 138 63 12 127 53 175 60 271.760 5636012.5 267000.06 310311.91 427999.50 44527 7.5 59.5 0.0692306
va 1985 1.52 5.6 15323.093 64.02468 0.6737288 12.42560 0.566000 21.00 0.000000 0.184192 8399.579 yes no no 976 176 106 55 9 109 38 149 47 268.760 5706000.5 264000.41 307644.50 425000.28 47928 7.2 60.1 0.0494880
va 1986 1.45 5.0 15915.377 64.01488 0.6563467 12.33290 0.580200 21.00 0.000000 0.180502 8866.417 yes no no 1126 224 154 77 19 149 45 162 48 294.310 5795013.0 269000.34 304999.97 401000.03 51381 7.0 60.7 0.0639497
va 1987 1.39 4.2 16486.000 65.30148 0.6360000 12.24080 0.594800 21.00 0.000000 0.175822 9287.623 yes no no 1021 165 114 65 9 124 37 144 43 261.100 5903986.5 266999.66 303000.69 399000.28 54834 6.2 61.5 0.0780921
va 1988 1.33 3.9 17011.549 66.50301 0.6121270 12.14940 0.609700 21.00 0.000000 0.163500 9551.628 yes no no 1071 191 128 76 12 118 29 160 55 253.240 6014995.5 257999.67 293000.28 416000.41 57453 5.5 62.3 0.0520566
wa 1982 1.90 12.1 14342.482 56.33313 0.2317590 1.15016 2.657210 21.00 0.000000 0.183850 7306.683 no yes no 748 172 112 43 6 107 28 100 42 271.006 4278001.5 202000.27 219551.97 314001.31 31258 9.7 57.8 -0.0328208
wa 1983 1.81 11.2 14534.403 57.67179 0.2315585 1.17610 2.739480 21.00 0.000000 0.179465 8395.816 no yes no 698 140 105 53 5 92 27 97 31 236.519 4305001.0 194999.91 217124.00 307995.19 36144 9.6 57.9 0.0425709
wa 1984 1.75 9.5 14758.242 57.56355 0.2218890 1.20261 2.824310 21.00 0.000000 0.171880 7874.928 no yes no 746 158 109 45 9 87 22 123 40 229.463 4348992.0 192000.00 214722.88 300998.44 34248 7.5 59.5 0.0483051
wa 1985 1.68 8.1 14909.958 58.94447 0.2138972 1.22973 2.911750 21.00 0.000000 0.166529 7796.564 no yes no 744 124 80 50 16 77 12 103 37 218.182 4408993.5 193999.97 212348.31 295002.12 34375 7.2 60.1 0.0270920
wa 1986 1.59 8.2 15375.645 60.63702 0.2083787 1.25746 3.001910 21.00 0.000000 0.160415 8166.685 no yes no 703 148 93 73 13 83 29 91 33 222.222 4463010.5 202999.95 210000.00 288999.00 36448 7.0 60.7 0.0546685
wa 1987 1.54 7.6 15630.000 61.40041 0.2019190 1.28581 3.094860 21.00 0.000000 0.155314 8488.326 no yes no 780 146 95 55 7 83 20 99 34 246.591 4537997.0 198999.94 206998.03 284998.72 38520 6.2 61.5 0.0166499
wa 1988 1.49 6.2 15854.668 62.49641 0.1943398 1.31480 3.190680 21.00 0.000000 0.144181 8995.922 no yes no 778 173 108 47 11 98 24 94 35 255.938 4647995.0 191999.73 206999.98 278997.97 41813 5.5 62.3 0.0375806
wv 1982 1.05 13.9 10748.210 45.52290 0.4763640 1.54847 0.380650 18.00 0.000000 0.201276 5574.713 yes yes no 450 89 56 35 8 58 21 76 23 144.000 1960997.9 97999.96 100136.30 138001.16 10932 9.7 57.8 -0.0280919
wv 1983 0.93 18.0 10451.835 42.99320 0.4577901 1.57328 0.371330 18.50 0.000000 0.195664 5958.217 yes yes no 425 93 61 23 4 56 21 58 18 153.000 1963003.2 96000.13 98565.66 134999.89 11696 9.6 57.9 -0.0277933
wv 1984 0.85 15.0 10641.758 44.41417 0.4386736 1.59850 0.362230 19.00 0.000000 0.192053 6494.611 yes yes no 438 91 66 30 9 55 15 62 26 131.404 1951002.1 93999.98 97019.65 131999.16 12671 7.5 59.5 0.0143560
wv 1985 0.81 13.0 10669.491 45.38619 0.4228739 1.62412 0.353360 19.00 0.000000 0.179934 6541.318 yes yes no 420 67 45 29 3 47 13 56 14 140.132 1936001.2 92000.11 95497.89 127999.99 12664 7.2 60.1 -0.0083843
wv 1986 0.81 11.8 10888.545 44.98626 0.4119639 1.65015 0.344710 19.67 0.000000 0.173935 6887.315 yes yes no 440 86 56 43 6 53 17 57 15 145.849 1917002.5 94999.91 94000.00 122000.81 13203 7.0 60.7 -0.0028322
wv 1987 0.79 10.8 10992.000 46.13793 0.3991930 1.67660 0.336270 21.00 0.000000 0.171171 7244.076 yes yes no 471 90 58 45 11 51 9 57 26 141.154 1896998.2 92999.99 91999.64 119000.40 13742 6.2 61.5 0.0063589
wv 1988 0.79 9.9 11294.514 46.18055 0.3842089 1.70347 0.328030 21.00 0.000000 0.162937 7400.866 yes yes no 460 83 51 46 11 52 16 55 15 141.439 1875996.6 90999.91 87000.16 115000.21 13884 5.5 62.3 0.0253461
wi 1982 2.21 10.7 13213.604 61.65158 0.1730310 0.23331 0.233310 18.00 1.794310 0.210804 6909.823 yes no no 770 199 105 67 17 126 54 133 46 255.392 4745997.0 251000.25 269586.12 362003.25 32794 9.7 57.8 -0.0286930
wi 1983 2.17 10.4 13291.284 61.35593 0.1662844 0.25198 0.251980 18.00 1.999160 0.205162 7184.746 yes no no 725 196 118 47 10 120 61 114 49 255.777 4747001.5 240000.41 264019.53 356997.47 34106 9.6 57.9 0.0160480
wi 1984 2.13 7.3 13818.682 62.27848 0.1593406 0.27216 0.272160 18.50 2.107430 0.196950 7426.941 yes no no 822 181 104 57 7 126 44 122 46 272.596 4761987.5 231000.22 258567.89 350998.31 35367 7.5 59.5 0.0596980
wi 1985 2.02 7.2 13952.330 61.62888 0.1536017 0.29395 0.293950 19.00 1.994530 0.188973 7681.489 yes no no 744 166 101 46 11 101 35 112 45 246.061 4774985.5 225000.48 253228.81 340995.59 36679 7.2 60.1 0.0066200
wi 1986 1.75 7.0 14351.909 62.21108 0.1496388 0.31748 0.317480 19.67 1.980740 0.182183 8036.372 yes no no 747 159 104 51 8 95 32 110 44 256.031 4783004.0 228000.22 247999.98 305997.53 38438 7.0 60.7 0.0305493
wi 1987 1.68 6.1 14720.000 64.70425 0.1450000 0.34290 0.342900 21.00 1.864410 0.176361 8361.979 yes no no 797 156 106 66 11 82 24 108 41 248.468 4806996.5 222000.22 239997.66 296003.94 40196 6.2 61.5 0.0322504
wi 1988 1.65 4.3 14941.290 67.44313 0.1395573 0.37035 0.370350 21.00 1.864410 0.164296 8745.190 yes no no 807 169 114 59 20 102 35 119 42 274.677 4855011.5 213000.23 219998.28 310000.78 42458 5.5 62.3 0.0401724
wy 1982 2.19 5.8 14600.238 67.31844 0.0536993 2.45981 8.577931 19.00 0.000000 0.233668 10354.911 no yes no 201 38 18 10 1 28 13 26 8 69.931 509999.6 22999.98 25670.91 40000.00 5281 9.7 57.8 -0.0714170
wy 1983 1.99 8.4 13574.541 66.39118 0.0516055 2.54383 8.566920 19.00 0.000000 0.220633 9804.255 no yes no 173 22 14 11 0 22 6 20 3 62.107 516000.5 22999.99 25242.58 40000.00 5059 9.6 57.9 -0.1056785
wy 1984 1.91 6.3 13456.044 66.02209 0.0494506 2.63072 8.555930 19.00 0.000000 0.208333 9994.155 no yes no 157 27 22 3 1 20 7 28 3 62.279 512999.8 21999.94 24821.40 36999.84 5127 7.5 59.5 -0.0166784
wy 1985 1.88 7.1 13595.339 65.08380 0.0476695 2.72057 8.544940 19.00 0.000000 0.191962 10611.011 no yes no 152 27 22 8 3 20 2 24 7 52.345 508999.6 22000.02 24407.24 35000.22 5401 7.2 60.1 -0.0121261
wy 1986 1.70 9.0 13126.935 63.96648 0.0464396 2.81350 8.533970 19.00 0.000000 0.168026 10619.331 no yes no 168 30 19 8 1 25 7 25 11 57.857 506999.9 23000.01 24000.00 34999.79 5384 7.0 60.7 -0.1099759
wy 1987 1.59 8.6 12719.000 62.85714 0.0450000 2.90960 8.523020 19.00 0.000000 0.149312 10953.050 no yes no 129 25 18 8 2 19 6 12 4 35.500 490000.5 22000.02 22999.92 32999.67 5367 6.2 61.5 -0.1236415
wy 1988 1.55 6.3 13098.171 64.63768 0.0433109 3.00899 8.512080 19.50 0.000000 0.131242 11812.115 no yes no 155 26 18 10 1 23 11 19 5 47.422 478999.7 21000.02 20999.96 30000.16 5658 5.5 62.3 -0.0170232
  • Look at the documentation: ?Fatalities or help(Fatalities)

  • Understand the structure of your data

Rows: 336
Columns: 34
$ state        <fct> al, al, al, al, al, al, al, az, az, az, az, az, az, az, a…
$ year         <fct> 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1982, 1983, 198…
$ spirits      <dbl> 1.37, 1.36, 1.32, 1.28, 1.23, 1.18, 1.17, 1.97, 1.90, 2.1…
$ unemp        <dbl> 14.4, 13.7, 11.1, 8.9, 9.8, 7.8, 7.2, 9.9, 9.1, 5.0, 6.5,…
$ income       <dbl> 10544.15, 10732.80, 11108.79, 11332.63, 11661.51, 11944.0…
$ emppop       <dbl> 50.69204, 52.14703, 54.16809, 55.27114, 56.51450, 57.5098…
$ beertax      <dbl> 1.53937948, 1.78899074, 1.71428561, 1.65254235, 1.6099070…
$ baptist      <dbl> 30.3557, 30.3336, 30.3115, 30.2895, 30.2674, 30.2453, 30.…
$ mormon       <dbl> 0.32829, 0.34341, 0.35924, 0.37579, 0.39311, 0.41123, 0.4…
$ drinkage     <dbl> 19.00, 19.00, 19.00, 19.67, 21.00, 21.00, 21.00, 19.00, 1…
$ dry          <dbl> 25.0063, 22.9942, 24.0426, 23.6339, 23.4647, 23.7924, 23.…
$ youngdrivers <dbl> 0.211572, 0.210768, 0.211484, 0.211140, 0.213400, 0.21552…
$ miles        <dbl> 7233.887, 7836.348, 8262.990, 8726.917, 8952.854, 9166.30…
$ breath       <fct> no, no, no, no, no, no, no, no, no, no, no, no, no, no, n…
$ jail         <fct> no, no, no, no, no, no, no, yes, yes, yes, yes, yes, yes,…
$ service      <fct> no, no, no, no, no, no, no, yes, yes, yes, yes, yes, yes,…
$ fatal        <int> 839, 930, 932, 882, 1081, 1110, 1023, 724, 675, 869, 893,…
$ nfatal       <int> 146, 154, 165, 146, 172, 181, 139, 131, 112, 149, 150, 17…
$ sfatal       <int> 99, 98, 94, 98, 119, 114, 89, 76, 60, 81, 75, 85, 87, 67,…
$ fatal1517    <int> 53, 71, 49, 66, 82, 94, 66, 40, 40, 51, 48, 72, 50, 54, 3…
$ nfatal1517   <int> 9, 8, 7, 9, 10, 11, 8, 7, 7, 8, 11, 19, 16, 14, 5, 2, 2, …
$ fatal1820    <int> 99, 108, 103, 100, 120, 127, 105, 81, 83, 118, 100, 104, …
$ nfatal1820   <int> 34, 26, 25, 23, 23, 31, 24, 16, 19, 34, 26, 30, 25, 14, 2…
$ fatal2124    <int> 120, 124, 118, 114, 119, 138, 123, 96, 80, 123, 121, 130,…
$ nfatal2124   <int> 32, 35, 34, 45, 29, 30, 25, 36, 17, 33, 30, 25, 34, 31, 1…
$ afatal       <dbl> 309.438, 341.834, 304.872, 276.742, 360.716, 368.421, 298…
$ pop          <dbl> 3942002, 3960008, 3988992, 4021008, 4049994, 4082999, 410…
$ pop1517      <dbl> 208999.6, 202000.1, 197000.0, 194999.7, 203999.9, 204999.…
$ pop1820      <dbl> 221553.4, 219125.5, 216724.1, 214349.0, 212000.0, 208998.…
$ pop2124      <dbl> 290000.1, 290000.2, 288000.2, 284000.3, 263000.3, 258999.…
$ milestot     <dbl> 28516, 31032, 32961, 35091, 36259, 37426, 39684, 19729, 1…
$ unempus      <dbl> 9.7, 9.6, 7.5, 7.2, 7.0, 6.2, 5.5, 9.7, 9.6, 7.5, 7.2, 7.…
$ emppopus     <dbl> 57.8, 57.9, 59.5, 60.1, 60.7, 61.5, 62.3, 57.8, 57.9, 59.…
$ gsp          <dbl> -0.022124760, 0.046558253, 0.062797837, 0.027489973, 0.03…
Unique Missing Pct. Mean SD Min Median Max Histogram
spirits 157 0 1.8 0.7 0.8 1.7 4.9
unemp 100 0 7.3 2.5 2.4 7.0 18.0
income 333 0 13880.2 2253.0 9513.8 13763.1 22193.5
emppop 334 0 60.8 4.7 43.0 61.4 71.3
beertax 302 0 0.5 0.5 0.0 0.4 2.7
baptist 248 0 7.2 9.8 0.0 1.7 30.4
mormon 165 0 2.8 9.7 0.1 0.4 65.9
drinkage 12 0 20.5 0.9 18.0 21.0 21.0
dry 161 0 4.3 9.5 0.0 0.1 45.8
youngdrivers 335 0 0.2 0.0 0.1 0.2 0.3
miles 336 0 7890.8 1475.7 4576.3 7796.2 26148.3
fatal 291 0 928.7 934.1 79.0 701.0 5504.0
nfatal 206 0 182.6 188.4 13.0 135.0 1049.0
sfatal 177 0 109.9 108.5 8.0 81.0 603.0
fatal1517 125 0 62.6 55.7 3.0 49.0 318.0
nfatal1517 48 0 12.3 12.3 0.0 10.0 76.0
fatal1820 171 0 106.7 104.2 7.0 82.0 601.0
nfatal1820 88 0 33.5 33.2 0.0 24.0 196.0
fatal2124 183 0 126.9 131.8 12.0 97.5 770.0
nfatal2124 105 0 41.4 42.9 1.0 30.0 249.0
afatal 335 0 293.3 303.6 24.6 211.6 2094.9
pop 336 0 4930271.5 5073703.9 478999.7 3310503.2 28314028.0
pop1517 316 0 230815.5 229896.3 21000.0 163000.2 1172000.2
pop1820 331 0 249090.4 249345.6 21000.0 170982.3 1321004.4
pop2124 328 0 336389.9 345304.4 30000.2 240999.9 1892998.1
milestot 335 0 37101.5 37454.4 3993.0 28483.5 241575.0
unempus 7 0 7.5 1.5 5.5 7.2 9.7
emppopus 7 0 60.0 1.6 57.8 60.1 62.3
gsp 336 0 0.0 0.0 -0.1 0.0 0.1
N %
year 1982 48 14.3
1983 48 14.3
1984 48 14.3
1985 48 14.3
1986 48 14.3
1987 48 14.3
1988 48 14.3
breath no 181 53.9
yes 155 46.1
jail no 241 71.7
yes 94 28.0
service no 273 81.2
yes 62 18.5
  • We will need to wrangle some of the variables (eg jail)

  • We have panel data, with repeated observations

  • We can make tons of graphs to understand what’s in our data

    • Distribution of the variables
    • Temporal evolution
    • Spatial distribution
    • Relationship between variables
fatalities <- as_tibble(Fatalities) |>
  remove_missing() |>
  mutate(
    state = str_to_upper(state),
    year = as.integer(paste(year)),
    jail = (jail == "yes"),
    jail_name = ifelse(jail, "Jail penalty", "No jail penalty"),
    fatal_rate = fatal / pop * 1e5 # deaths per 100,000 people
  )
Fatalities |>
  as_tibble() |>
  select(-state) |> #for readability
  modelsummary::datasummary_skim() 

Use for data exploration

  • Graphs and tables can help understand the structure of our data:

    • Distributions
    • Simple relationships
  • Then, can help to:

    • Form hypotheses
    • Explore identifying assumptions
    • Build accurate models
  • May want to plot the same graph many times \(\to\) make functions, eg my balanced graphs below

  • To communicate descriptive analyses

  • To explore potential mechanisms

Explore data: raw data

State Deaths per 100,000
NM 36.5
WY 32.2
MT 29.0
SC 28.2
MS 27.6
NV 27.5
AZ 27.1
ID 25.7
FL 24.8
AR 24.4
AL 24.1
TN 24.0
GA 24.0
NC 23.4
OK 23.4
WV 23.0
TX 22.8
OR 21.8
KY 21.3
LA 21.2
VT 20.9
DE 20.7
SD 20.5
MO 19.8
KS 19.7
CA 19.1
ME 18.7
CO 18.7
UT 18.4
IN 18.3
NH 18.0
VA 17.4
NE 16.9
IA 16.8
WA 16.8
MI 16.7
MD 16.3
WI 16.2
ND 16.0
OH 15.5
PA 15.4
CT 14.6
IL 14.1
MN 13.7
NJ 13.2
NY 12.1
MA 12.0
RI 11.1
Year States with a jail penalty Share of states (%)
1982 9 19
1983 13 27
1984 14 29
1985 15 31
1986 15 31
1987 14 29
1988 14 30
fatal_jail <- fatalities |>
  ggplot(aes(x = jail_name, y = fatal)) +
  geom_jitter(width = 0.25) +
  labs(
    title = "Difference in fatal accidents depending on jail penaly for drunk",
    y = "Number of fatal accidents per state",
    x = "State law on drunk driving"
  ) +
  scale_y_log10() 
fatalities |>
  summarise(fatal_rate = mean(fatal_rate), .by = c(year, jail_name)) |>
  ggplot(aes(x = year, y = fatal_rate, color = jail_name)) +
  geom_line(linewidth = 1.2) +
  geom_point(size = 2) +
  labs(
    title = "Deaths relatively stable over the period",
    subtitle = "Average traffic deaths per 100,000 people, by law status",
    x = NULL,
    y = "Deaths per 100,000",
    color = NULL
  )
fatalities |>
  summarise(`Deaths per 100,000` = mean(fatal_rate), .by = state) |>
  arrange(desc(`Deaths per 100,000`)) |>
  rename(State = state) |>
  kable(digits = 1) |>
  scroll_box(height = "550px")
fatalities |>
  summarise(
    `States with a jail penalty` = sum(jail),
    `Share of states (%)` = mean(jail) * 100,
    .by = year
  ) |>
  arrange(year) |>
  rename(Year = year) |>
  kable(digits = 0)

Handling large numbers of observations

ex_duration <- readRDS("~/Documents/Teaching/data_viz_summer/content/slides/data/ex_duration.RDS") 
# ex_duration <- readRDS("data/ex_duration.RDS")

raw <- ex_duration |>
  ggplot(aes(x = date, y = duration)) +
  geom_point(color = "black") +
  scale_y_log10() +
  labs(
    title = "Duration of evening news items French TV",
    subtitle = "For TF1 and France 2",
    x = NULL,
    y = "Duration (in s)"
  )

opacity <- ex_duration |>
  ggplot(aes(x = date, y = duration)) +
  geom_point(color = "black", alpha = 0.01) +
  scale_y_log10() +
  labs(
    title = "Duration of evening news items French TV",
    subtitle = "Visualzing many points: low opacity",
    x = NULL,
    y = "Duration (in s)"
  ) +
  facet_wrap(~ channel)

heat_map <- ex_duration |>
  ggplot(aes(x = date, y = duration)) +
  geom_bin2d(bins = 70, alpha = 0.9) +
  scale_y_log10() +
  labs(
    title = "Duration of evening news items French TV, by channel",
    subtitle = "Visualzing many points: heatmap",
    fill = "Number of observations per tile",
    x = NULL,
    y = "Duration (in s)"
  ) +
  facet_wrap(~ channel)

binscatter <- ex_duration |>
  ggplot(aes(x = date, y = duration)) +
  geom_point(color = "black", alpha = 0.01) +
  scale_y_log10() +
  stat_summary_bin(
    fun.y = 'mean',
    bins = 20,
    geom = "point",
    size = 3,
    color = "orange"
  ) +
  labs(
    title = "Duration of evening news items French TV, by channel",
    subtitle = "Visualzing many points: binscatter",
    x = NULL,
    y = "Duration (in s)"
  )

Explore data: finding sources of variation

# Evolution of law
law_evol <- fatalities |>
  group_by(year) |>
  # summarise(prop_jail = mean(jail, na.rm = TRUE))
  summarise(prop_jail = mean(jail, na.rm = TRUE)) |>
  ggplot(aes(year, prop_jail)) +
  geom_line(linewidth = 1.4) +
  labs(
    title = "Adoption of jail sentence for drunk driving",
    y = "Proportion of states with a jail law",
    x = NULL
  )

# Making the map
states_sf <- tigris::states(
    cb = TRUE, resolution = "20m", year = 2024, progress_bar = FALSE) |>
  tigris::shift_geometry() |>
  rename(state = STUSPS)

fatalities_sf <- fatalities |>
  filter(jail) |>
  group_by(state) |>
  mutate(first_year = min(year, na.rm = TRUE)) |>
  ungroup() |>
  filter(year == first_year) |>
  dplyr::full_join(states_sf, by = join_by(state)) |>
  sf::st_as_sf()

law_map <- fatalities_sf |>
  ggplot() +
  geom_sf(aes(fill = first_year), color = "white", linewidth = 0.1) +
  scale_mediocre_c(pal = "portal", gradient = "left") +
  # theme_mediocre() +
  labs(
    title = "First year of adoption of the 'jail' law",
    subtitle = "In the data set",
    fill = NULL
  ) +
  theme(axis.text.y = element_blank(),
        axis.text.x = element_blank())

Explore data: balance

Variable No jail penalty Jail penalty Difference p-value
Traffic deaths (per 100,000) 19.42 22.95 3.53 <0.01
Alcohol-related deaths (per 100,000) 6.22 7.57 1.35 <0.01
Unemployment rate (%) 7.12 7.94 0.81 0.01
Income per capita (thousands of dollars) 14.08 13.33 -0.75 <0.01
Beer tax (dollars per case) 0.53 0.48 -0.04 0.44
Spirits consumption (gallons) 1.77 1.70 -0.07 0.42
Minimum drinking age (years) 20.51 20.30 -0.22 0.07
graph_balance <- function(balance_var) {
  fatalities |>
    ggplot(aes(x = {{ balance_var }}, fill = jail_name, color = jail_name)) +
    geom_density() +
    labs(
      title = paste("Balance plot for", substitute(balance_var)),
      fill = NULL,
      color = NULL,
      y = "Density"
    )
}

# one row per variable, with names a reader can parse
balance_table <- fatalities |>
  transmute(
    jail_name,
    `Traffic deaths (per 100,000)` = fatal_rate,
    `Alcohol-related deaths (per 100,000)` = afatal / pop * 1e5,
    `Unemployment rate (%)` = unemp,
    `Income per capita (thousands of dollars)` = income / 1000,
    `Beer tax (dollars per case)` = beertax,
    `Spirits consumption (gallons)` = spirits,
    `Minimum drinking age (years)` = drinkage
  ) |>
  pivot_longer(-jail_name, names_to = "Variable") |>
  summarise(
    `No jail penalty` = mean(value[jail_name == "No jail penalty"]),
    `Jail penalty` = mean(value[jail_name == "Jail penalty"]),
    Difference = `Jail penalty` - `No jail penalty`,
    `p-value` = t.test(value ~ jail_name)$p.value,
    .by = Variable
  ) |>
  mutate(`p-value` = ifelse(`p-value` < 0.01, "<0.01", sprintf("%.2f", `p-value`)))
balance_table |> kable(digits = 2)

Use to test validity

  • Identifying assumptions are usually not testable

  • But most have testable implications, and those are usually visual

  • The graph shows the raw data underlying the claim

  • But important to combine it with a formal statistical test

Graphs and identifying assumptions

Assumption What to plot
Parallel trends Event study plot
No anticipation The same graph
Overlap / common support (matching) Covariate distributions by group
No manipulation (RD) Density of the running variable at the cutoff
Exclusion (IV) Balance of the instrument on covariates

Find an identification strategy

  • The setting calls for a TWFE approach (staggered roll-out)

  • Identifying assumptions?

  • Threats to identification?

    • Trends in number of fatalities before adoption
    • Other shocks at the time of adoption
    • Anticipation: decrease in fatalities before the implementation
    • Change in composition of the states
    • Spillover effects
  • How to explore these? Are graphs helpful?

Check: who is treated, and when

Group States State-years
Never treated 33 230
Always treated 9 63
Switcher 6 42
  • Only limited amount of switchers

  • The issues from the TWFE literature arise

  • Not visible in the regression table but we noticed it with a graph

fatalities_grp <- fatalities |> 
  group_by(state) |> 
  mutate(
    n_years_treated = sum(jail),
    group = case_when(
      n_years_treated == 0 ~ "Never treated",
      n_years_treated == n() ~ "Always treated",
      TRUE ~ "Switcher"
    )
  ) |> 
  ungroup()

fatalities_grp |> 
  ggplot(aes(x = year, y = fct_reorder(state, n_years_treated), fill = jail_name)) + 
  geom_tile(color = "white", linewidth = 0.4) + 
  labs(
    title = "Only 6 of the 48 states ever change their law",
    subtitle = "Mandatory jail sentence for drunk driving, by state and year",
    fill = NULL,
    y = "State",
    x = NULL
  )
fatalities_grp |>
  summarise(States = n_distinct(state), `State-years` = n(), .by = group) |>
  rename(Group = group) |>
  kable()

Estimation


  • Let’s estimate a couple of models

  • Three specifications: raw, with fixed effects, with controls

reg_raw <- feols(log(fatal) ~ jail, data = fatalities)

reg_fe <- feols(log(fatal) ~ jail | state + year, data = fatalities)

reg_ctrl <- feols(
  log(fatal) ~ jail + log(unemp) + log(income) | state + year,
  data = fatalities,
  cluster = ~state
)
  • How do we communicate them?

Example table

Esposito, Rotesi, Saia & Thoenig (2023), Reconciliation Narratives: The Birth of a Nation after the US Civil War, AER 113(6)



  • Explicit title
  • Column headers name the outcome and what changes across specifications
  • Coefficient block: only the interpreted estimates
  • Bottom block: \(N\), fixed effects, controls, mean of the outcome
  • Notes give units, sample, and what the SE are clustered on

Notable points

  • Self contained can read it without the paper
  • We can understand the magnitude of the effect
  • We can see what changes across columns
  • It shows only the coefficients the authors discuss
  • Numbers are rounded

To include in a table

  • Coefficients and their associated standard error

  • Number of observation the number of clusters

  • Mean (and SD) of the outcome to get a sense of the magnitude of the effect

  • Yes/no rows for each set of FEs and each set of controls

  • Column headers that name the outcome or the specification

  • Clean variable names

  • An informative title

  • Notes that make the table self-contained

Not to include in a table

  • Coefficients on controls we never interpret

  • The intercept, almost always

  • Some goodness-of-fit statistics

  • Six decimals on a coefficient whose standard error is 0.11

  • Too many zeros for a coef (eg 0.00001) \(\to\) change unit

  • Vertical lines, boxes, shading, and color for its own sake

Default table

(1) (2) (3)
(Intercept) 6.506
(0.059)
jailTRUE -0.303 0.025 0.004
(0.111) (0.034) (0.051)
log(unemp) -0.132
(0.053)
log(income) 1.075
(0.341)
Num.Obs. 335 335 335
R2 0.022 0.992 0.995
R2 Adj. 0.019 0.991 0.993
R2 Within 0.002 0.308
R2 Within Adj. -0.002 0.300
AIC 893.9 -617.9 -736.5
BIC 901.5 -408.1 -519.1
RMSE 0.91 0.08 0.07
FE: state X X
FE: year X X
  • jailTRUE: unclear variable name

  • Six decimals on an estimate whose s.e. is 0.11

  • Too many goodness-of-fit rows

  • Can drop the intercept

  • Nothing to help interpret the magnitude of the results

  • No note

modelsummary(list(reg_raw, reg_fe, reg_ctrl))

A better table

Outcome: log of annual traffic fatalities.
No controls State & year FE FE + controls
Notes: OLS estimates of the association between a mandatory jail sentence for drunk driving and traffic fatalities. The outcome is the log of the annual number of traffic fatalities in a state. The sample covers the 48 contiguous US states, observed annually from 1982 to 1988. Column (1) includes no controls. Column (2) adds state and year fixed effects. Column (3) further controls for the log unemployment rate and log income per capita. Mean fatalities is the average annual number of traffic fatalities per state over the period. Standard errors, clustered at the state level, are reported in parentheses.
State with a mandatory jail sentence -0.303 0.025 0.004
(0.111) (0.034) (0.051)
Unemployment rate (log) -0.132
(0.053)
Income per capita (log) 1.075
(0.341)
Observations 335 335 335
Mean fatalities 915 915 915
Clusters (states) 48 48 48
State fixed effects X X
Year fixed effects X X
  • Horizontal lines: a rule at the top, one under the header, one at the bottom

  • No vertical lines

  • Put the unit in the label

  • Use the same variable names as your text

  • One table fits on one page. If it does not, two tables

mean_fatal <- as.character(round(mean(fatalities$fatal)))
n_states <- as.character(n_distinct(fatalities$state))

extra_rows <- tribble(
  ~term, ~`No controls`, ~`State & year FE`, ~`FE + controls`,
  "Mean fatalities", mean_fatal, mean_fatal, mean_fatal,
  "Clusters (states)", n_states, n_states, n_states
)
attr(extra_rows, "position") <- c(8, 9)

modelsummary(
  list(
    `No controls` = reg_raw,
    `State & year FE` = reg_fe,
    `FE + controls` = reg_ctrl
  ),
  coef_map = c(
    "jailTRUE" = "State with a mandatory jail sentence",
    "log(unemp)" = "Unemployment rate (log)",
    "log(income)" = "Income per capita (log)"
  ),
  gof_map = list(
    list(raw = "nobs", clean = "Observations", fmt = 0),
    list(raw = "FE: state", clean = "State fixed effects", fmt = 0),
    list(raw = "FE: year", clean = "Year fixed effects", fmt = 0)
  ),
  add_rows = extra_rows,
  stars = FALSE,
  fmt = 3,
  title = "Outcome: log of annual traffic fatalities.",
  notes = paste(
    "Notes: OLS estimates of the association between a mandatory jail sentence for drunk driving and traffic fatalities.",
    "The outcome is the log of the annual number of traffic fatalities in a state.",
    "The sample covers the 48 contiguous US states, observed annually from 1982 to 1988.",
    "Column (1) includes no controls. Column (2) adds state and year fixed effects.",
    "Column (3) further controls for the log unemployment rate and log income per capita.",
    "Mean fatalities is the average annual number of traffic fatalities per state over the period.",
    "Standard errors, clustered at the state level, are reported in parentheses."
  )
)

Visualizing estimation output

  • The coefficients above are in different units

  • Comparing their size on one axis is meaningless

  • Standardized effect size: rescale every variable by its own SD

    • “A one-SD increase in \(x\) is associated with a change in \(y\) of \(\beta\) sd”
  • Improves comparability of magnitudes but loose interpretability

coef_labels <- c(
  "jailTRUE" = "Mandatory jail sentence",
  "log(unemp)" = "Unemployment rate (log)",
  "log(income)" = "Income per capita (log)"
)

coef_plot <- modelplot(
  list(`No controls` = reg_fe, `With controls` = reg_ctrl),
  coef_map = coef_labels
) +
  geom_vline(xintercept = 0, linetype = "dashed") +
  labs(
    title = "Regression coefficients of log traffic fatalities",
    subtitle = "Dot-whisker plot, 95% confidence intervals, FE model",
    x = "Estimate (log points)",
    caption = "R package: modelsummary",
    color = NULL
  )

fatalities_std <- fatalities |>
  mutate(
    across(
      c(fatal, unemp, income),
      \(x) as.numeric(scale(log(x))),
      .names = "{.col}_z"
    ),
    jail_z = as.numeric(scale(as.numeric(jail)))
  )

reg_std <- feols(
  fatal_z ~ jail_z + unemp_z + income_z | state + year,
  data = fatalities_std,
  cluster = ~state
)

coef_plot_std <- modelplot(
  list(`Standardized` = reg_std),
  coef_map = c(
    "jail_z" = "Mandatory jail sentence",
    "unemp_z" = "Unemployment rate",
    "income_z" = "Income per capita"
  )
) +
  geom_vline(xintercept = 0, linetype = "dashed") +
  labs(
    title = "Regression coefficients of log traffic fatalities",
    subtitle = "Effect of a one-SD increase, in SD of the outcome",
    x = "Standardized estimate (SD of log fatalities)",
    color = NULL
  )

coef_distrib <- reg_ctrl |>
  broom::tidy() |>
  mutate(term = coalesce(unname(coef_labels[term]), term)) |>
  ggplot(aes(y = term)) +
  ggdist::stat_halfeye(
    aes(xdist = distributional::dist_student_t(
      df = df.residual(reg_ctrl), mu = estimate, sigma = std.error)),
    color = colors_mediocre$base,
    fill = colors_mediocre$base,
    alpha = 0.6
  ) +
  geom_vline(xintercept = 0, linetype = "dashed") +
  labs(
    title = "Ploting the whole distribution",
    subtitle = "Determinants of log traffic fatalities",
    x = "Point estimate",
    y = NULL,
    caption = "R package: ggdist"
  )

Use for diagnostic plots

  • Residuals against fitted values, QQ plots
  • Influence and leverage: is one observation carrying the whole result?
  • Overlap and common support before matching
  • Distribution of implicit weights
  • Audience of diagnostic plots: most often you

Diagnostic plots

reg_lm <- lm(
  log(fatal) ~ jail + as.factor(state) + as.factor(year),
  data = fatalities
)

# broom::augment() gives fitted values, residuals, leverage and Cook's distance
diag_data <- broom::augment(reg_lm) |>
  mutate(label = paste(fatalities$state, fatalities$year))

glimpse(diag_data |> select(starts_with(".")))
# Res. vs fitted
diag_data |>
  ggplot(aes(x = .fitted, y = .resid)) +
  geom_hline(yintercept = 0, linetype = "dashed") +
  geom_point(alpha = 0.4) +
  geom_smooth(method = "loess", formula = y ~ x, se = FALSE) +
  labs(
    title = "Residuals vs fitted",
    subtitle = "Look for: curvature (missing non-linearity), changing spread",
    x = "Fitted values",
    y = "Residuals"
  )
#Normal Q-Q
diag_data |>
  ggplot(aes(sample = .std.resid)) +
  geom_qq_line(linetype = "dashed") +
  geom_qq(alpha = 0.4) +
  labs(
    title = "Normal Q-Q",
    subtitle = "Look for: departures in the tails (here: fat lower tail)",
    x = "Theoretical quantiles",
    y = "Standardized residuals"
  )
# Scale-location
diag_data |>
  ggplot(aes(x = .fitted, y = sqrt(abs(.std.resid)))) +
  geom_point(alpha = 0.4) +
  geom_smooth(method = "loess", formula = y ~ x, se = FALSE) +
  labs(
    title = "Scale-location",
    subtitle = "Look for: a trend in the line, ie heteroskedasticity",
    x = "Fitted values",
    y = "Root of |standardized residuals|"
  )

Main take-away points

Data viz at large

  • Data viz is powerful, harness its power

  • It can be super insightful or equally deceptive

  • It can make your point memorable

  • It can also be truly beautiful

  • Leverage perception and data viz principles

How to build a graph?



Take-away messages

  1. Identify message

  2. Identify audience and objective

  3. Find the right type of graph for your story and audience

  4. Keep cognitive load in mind

  5. Think about aesthetics

  6. Follow “good-practice” rules

Graphs: concrete take-aways



Concrete take-away messages

  • Overall, facilitate the retrieval of information and reduce cognitive load

  • Build legible, understandable and nice looking graphs.

  • Have a title and explicit axes; present them.

  • Limit the number of colors you use. Use gray.

  • Label your graphs directly, add annotations.

Tables: take-aways


Take-away messages

  • One table, one question. Name the outcome and the treatment in words

  • Report the coefficient you interpret, its uncertainty, \(N\), clusters and the mean of the outcome

  • Yes/No rows for FE and controls: the reader must see what changes across columns

  • Round to what you can defend; delete everything you will not discuss

  • Write the notes so the table stands alone

  • Build it from code, never by hand

Thanks