Organizing research outcomes with multiple subtypes and ranges


#1

I’m trying to figure out the most efficient way to organize information about a demographic. I’d love some ideas on how to compare different estimate types or at least organize them efficiently.

I’m building a database on information about “gig workers”. There’s about a dozen different studies estimating the definition, size and difficulties of gig workers.

So, lets say I want to organize all of the estimates of the size of gig workers in America.

Study A - may say its 30% of working americans, while study B will say its between 10M - 20M Americans total.

Right now, I have one table with each study as a record. And each estimate as a column, “estimate size 1”, “estimate citation”, “estimate population” (working or total population as a multiple select).

That would produce more than 50 columns if size is a row. If its a table, then it could be fewer columns, but all of the rows would have to be in some way comparable. Id way to be able to compare, or at least generate a distribution of estimates.

Thanks and let me know if i can make this any clearer.