names

53 rows where place_id = 594009

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614154 1872091 1872091 defendant Upton Swilliam clothman 594009 594009 Upton, Swilliam, of Branktre, Essex, clothman 4
3795632 1956517 1956517 defendant Hall John butcher 594009 594009 Hall, John, of Branktre, Essex, butcher 1
3916694 1995952 1995952 defendant Haynes Robert innholder 594009 594009 Haynes, Robert, of Branktre, Essex, innholder 0
3916696 1995953 1995953 defendant Haynes Robert innholder 594009 594009 Haynes, Robert, of Branktre, Essex, innholder 0
4086192 2055335 2055335 defendant Maynerd William clothier 594009 594009 Maynerd, William, of Branktre, Essex, clothier 0
4096910 2059226 2059226 defendant Sparhawke John chapman 594009 594009 Sparhawke, John, of Branktre, Essex, chapman 0
4742587 2278335 2278335 defendant Naylingherst Hugh esq 594009 594009 Naylingherst, Hugh, of Branktre, Essex, esq 0
4742589 2278335 2278335 defendant Smyth John draper 594009 594009 Smyth, John, of Branktre, Essex, draper 2
4852815 2312297 2312297 defendant Curteys Thomas husbandman 594009 594009 Curteys, Thomas, of Branktre, Essex, husbandman 2
4866842 2316593 2316593 defendant Fox John yeoman 594009 594009 Fox, John, of Branktre, Essex, yeoman 2
4878272 2320157 2320157 defendant Bocher Thomas butcher 594009 594009 Bocher, Thomas, of Branktre, Essex, butcher 0
4881246 2321038 2321038 defendant Curteys Alice widow 594009 594009 Curteys, Alice, of Branktre, Essex, widow 4
4931257 2336158 2336158 defendant Payn John husbandman 594009 594009 Payn, John, of Branktre, Essex, husbandman 2
4941814 2339444 2339444 defendant Pacche John weaver 594009 594009 Pacche, John, of Branktre, Essex, weaver 4
4948485 2341504 2341504 defendant Makemery John husbandman 594009 594009 Makemery, John, of Branktre, Essex, husbandman 3
4952147 2342610 2342610 defendant Wayte John gent 594009 594009 Wayte, John, of Branktre, Essex, gent 2
4952151 2342611 2342611 defendant Wayte John gent 594009 594009 Wayte, John, of Branktre, Essex, gent 2
4952155 2342612 2342612 defendant Wayte John gent 594009 594009 Wayte, John, of Branktre, Essex, gent 2
4978058 2350404 2350404 defendant Wayte John yeoman 594009 594009 Wayte, John, of Branktre, Essex, yeoman 0
5000969 2357164 2357164 defendant Clerk John smith 594009 594009 Clerk, John, of Branktre, Essex, smith 0
5000974 2357165 2357165 defendant Clerk John smith 594009 594009 Clerk, John, of Branktre, Essex, smith 0
5022412 2363455 2363455 defendant Wayte John husbandman 594009 594009 Wayte, John, of Branktre, Essex, husbandman 0
5037960 2367984 2367984 defendant Wayte John husbandman 594009 594009 Wayte, John, of Branktre, Essex, husbandman 0
5041718 2369124 2369124 defendant Turnour John yeoman 594009 594009 Turnour, John, of Branktre, Essex, yeoman 2
5062162 2375239 2375239 defendant Wayte John yeoman 594009 594009 Wayte, John, of Branktre, Essex, yeoman 1
5075140 2379061 2379061 defendant Norman William scalder 594009 594009 Norman, William, of Branktre, Essex, scalder 0
5080287 2380594 2380594 defendant Wayte John husbandman 594009 594009 Wayte, John, of Branktre, Essex, husbandman 0
5215578 2420279 2420279 defendant Wayte John yeoman 594009 594009 Wayte, John, of Branktre, Essex, yeoman 3
5217997 2420998 2420998 defendant Bury John gent 594009 594009 Bury, John, of Branktre, Essex, gent 1
5253745 2431284 2431284 defendant Curson John sherman 594009 594009 Curson, John, of Branktre, Essex, sherman 0
5269116 2436071 2436071 defendant Bury John gent 594009 594009 Bury, John, of Branktre, Essex, gent 0
5275337 2437859 2437859 defendant Clarke William chapman 594009 594009 Clarke, William, of Branktre, Essex, chapman 3
5275381 2437869 2437869 defendant Clarke William chapman 594009 594009 Clarke, William, of Branktre, Essex, chapman 4
5275410 2437875 2437875 defendant Lorde John smith 594009 594009 Lorde, John, of Branktre, Essex, smith 3
5280365 2439335 2439335 defendant Uldale William   594009 594009 Uldale, William, of Branktre, Essex, gent, of household of Henry VI 1
5280390 2439340 2439340 defendant Uldale William gent 594009 594009 Uldale, William, of Branktre, Essex, gent 0
5291634 2442558 2442558 defendant Dunmowe Nicholas barber 594009 594009 Dunmowe, Nicholas, of Branktre, Essex, barber 2
5323479 2452100 2452100 defendant Dunmowe Nicholas barber 594009 594009 Dunmowe, Nicholas, of Branktre, Essex, barber 6
5341099 2457408 2457408 defendant Bury John gent 594009 594009 Bury, John,of Branktre, Essex, gent 0
5351806 2460667 2460667 defendant Beere John smith 594009 594009 Beere, John, of Branktre, Essex, smith 0
5351809 2460668 2460668 defendant Beer John smith 594009 594009 Beer, John, of Branktre, Essex, smith 1
5353329 2461118 2461118 defendant Johnson Robert yeoman 594009 594009 Johnson, Robert, of Branktre, Essex, yeoman 1
5353331 2461119 2461119 defendant Johnson Robert yeoman 594009 594009 Johnson, Robert, of Branktre, Essex, yeoman 0
5353366 2461130 2461130 defendant Hoskombe Thomas yeoman 594009 594009 Hoskombe, Thomas, of Branktre, Essex, yeoman 1
5370445 2466341 2466341 defendant Baker Robert tailor 594009 594009 Baker, Robert, of Branktre, Essex, tailor 0
5381297 2469705 2469705 defendant Baker Robert tailor 594009 594009 Baker, Robert, of Branktre, Essex, tailor 0
5491183 2502261 2502261 defendant Norfolke John clothman 594009 594009 Norfolke, John, of Branktre, Essex, clothman 0
5514794 2509470 2509470 defendant Norfolke John chapman 594009 594009 Norfolke, John, of Branktre, Essex, chapman 3
5533958 2515162 2515162 defendant Knyght Roger clothier 594009 594009 Knyght, Roger, of Branktre, Essex, clothier 0
5581558 2529306 2529306 defendant Bukford John butcher 594009 594009 Bukford, John, of Branktre, Essex, butcher 2
5581571 2529311 2529311 defendant Bukford John butcher 594009 594009 Bukford, John, of Branktre, Essex, butcher 1
5581577 2529313 2529313 defendant Bukford John butcher 594009 594009 Bukford, John, of Branktre, Essex, butcher 1
5608836 2537665 2537665 defendant Baker Robert tailor 594009 594009 Baker, Robert, of Branktre, Essex, tailor 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);