Open problems by field × shape (what kind of progress we could make)

Custom SQL query returning 38 rows (hide) 

select substr(domain,1,instr(domain||' /',' /')-1) as field, coalesce(shape,'unclassified') as shape, count(*) as n, sum(status='open') as open, sum(status='claimed') as claimed, sum(status='answered') as answered from open_problem group by field, shape order by field, n desc

Edit SQL

This data as json, CSV

fieldshapenopenclaimedanswered
CS unclassified 5 5 0 0
CS definition-dispute 1 1 0 0
TeamScience ops unclassified 1 1 0 0
astronomy needs-experiment-or-observation 87 87 0 0
biology needs-experiment-or-observation 71 71 0 0
biology data-reanalysis 30 30 0 0
biomedical unclassified 1 1 0 0
biomedicine unclassified 1 1 0 0
chemistry needs-experiment-or-observation 14 14 0 0
claim verification unclassified 2 2 0 0
computer science needs-theory 43 43 0 0
computer science compute-checkable-small-cases 30 30 0 0
condensed matter physics unclassified 9 9 0 0
cross-domain unclassified 1 1 0 0
economics unclassified 3 3 0 0
economics data-reanalysis 3 3 0 0
economics unclassified 1 1 0 0
fair division compute-checkable-small-cases 27 27 0 0
fair division unclassified 25 25 0 0
geoscience needs-experiment-or-observation 12 12 0 0
geoscience data-reanalysis 3 3 0 0
information theory needs-theory 8 8 0 0
mathematical physics unclassified 10 10 0 0
mathematics needs-theory 957 957 0 0
mathematics compute-checkable-small-cases 509 509 0 0
mathematics definition-dispute 4 4 0 0
mathematics unclassified 1 1 0 0
metascience unclassified 1 1 0 0
neuroscience needs-experiment-or-observation 45 45 0 0
neuroscience data-reanalysis 9 9 0 0
physics needs-experiment-or-observation 113 113 0 0
physics unclassified 1 1 0 0
statistics unclassified 6 6 0 0
statistics data-reanalysis 1 1 0 0
statistics compute-checkable-small-cases 1 1 0 0
theoretical computer science compute-checkable-small-cases 32 32 0 0
theoretical computer science needs-theory 9 9 0 0
theoretical computer science definition-dispute 1 1 0 0