names

69 rows where place_id = 626770

✎ 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
3730263 1935694 1935694 defendant Brey Edmund   626770 626770 Brey, Edmund, of Eton, Beds, knight 0
3772139 1948978 1948978 defendant Gune John husbandman 626770 626770 Gune, John, of Eton, Beds, husbandman 0
3789418 1954516 1954516 defendant Dene John husbandman 626770 626770 Dene, John, of Eton, Beds, husbandman 0
3825998 1965975 1965975 defendant Brey Edward   626770 626770 Brey, Edward, of Eton, Beds, Lord Brey 0
3833593 1968439 1968439 defendant Braye Edward   626770 626770 Braye, Edward, of Eton, Beds, knight, Lord Braye 0
3851203 1973971 1973971 defendant Beryngton Geoffrey husbandman 626770 626770 Beryngton, Geoffrey, of Eton, Beds, husbandman 1
3878208 1982959 1982959 defendant Wyngar John laborer 626770 626770 Wyngar, John, of Eton, Beds, laborer 2
3894491 1988364 1988364 defendant Luddyngton John   626770 626770 Luddyngton, John, of Eton, Beds 1
3906173 1992356 1992356 defendant Andrewe Robert husbandman 626770 626770 Andrewe, Robert, of Eton, Beds, husbandman 0
3909287 1993399 1993399 defendant Athall Robert   626770 626770 Athall, Robert, of Eton, Beds, horse courser 0
3933761 2001587 2001587 defendant Newman Thomas chapman 626770 626770 Newman, Thomas, of Eton, Beds, chapman 0
3959737 2010496 2010496 defendant Stocker John gent 626770 626770 Stocker, John, of Eton, Beds, gent 0
3982786 2018615 2018615 defendant Braye Reginald gent 626770 626770 Braye, Reginald, of Eton, Beds, esq, of of Middle Temple, London, gent 0
4390795 2161534 2161534 defendant Buckmaster John yeoman 626770 626770 Buckmaster, John, of Eton, Beds, yeoman 0
4719583 2271466 2271466 defendant Lorde John, sen gent 626770 626770 Lorde, John, sen, of Eton, Beds, gent 0
4724057 2272820 2272820 defendant Lord John, sen husbandman 626770 626770 Lord, John, sen, of Eton, Beds, husbandman 0
4735460 2276236 2276236 defendant Pulter William skinner 626770 626770 Pulter, William, of Eton, Beds, skinner 0
4740514 2277737 2277737 defendant Harthern John de tanner 626770 626770 Harthern, John de, of Eton, Beds, tanner 0
4760749 2283703 2283703 defendant Okeham William husbandman 626770 626770 Okeham, William, of Eton, Beds, husbandman 0
4788711 2292524 2292524 defendant Pie William clerk 626770 626770 Pie, William, of Eton, Beds, clerk 3
4832197 2306102 2306102 defendant Gate John carver 626770 626770 Gate, John, of Eton, Beds, carver 0
4832199 2306103 2306103 defendant Cate John carver 626770 626770 Cate, John, of Eton, Beds, carver 0
4891204 2323981 2323981 defendant Bullok Robert gent 626770 626770 Bullok, Robert, of Eton, Beds, gent 0
4894671 2325003 2325003 defendant Wysbech Thomas cordwainer 626770 626770 Wysbech, Thomas, of Eton, Beds, cordwainer 0
4901818 2327176 2327176 defendant Lorde William husbandman 626770 626770 Lorde, William, of Eton, Beds, husbandman 1
4905970 2328467 2328467 defendant Bullok Robert gent 626770 626770 Bullok, Robert, of Eton, Beds, gent 0
4913103 2330593 2330593 defendant Stokker Thomas woolman 626770 626770 Stokker, Thomas, of Eton, Beds, woolman 1
4916418 2331633 2331633 defendant Stokker Thomas yeoman 626770 626770 Stokker, Thomas, of Eton, Beds, yeoman 0
4926053 2334576 2334576 defendant Bullok Robert esq 626770 626770 Bullok, Robert, of Eton, Beds, esq 0
4931629 2336280 2336280 defendant bullok Robert gent 626770 626770 bullok, Robert, of Eton, Beds, gent 0
4931637 2336283 2336283 defendant Stoughton William husbandman 626770 626770 Stoughton, William, of Eton, Beds, husbandman 0
4931639 2336284 2336284 defendant Bullok Robert gent 626770 626770 Bullok, Robert, of Eton, Beds, gent 0
4937031 2337957 2337957 defendant Stokker Thomas woolman 626770 626770 Stokker, Thomas, of Eton, Beds, woolman 0
4938459 2338407 2338407 defendant Elys John husbandman 626770 626770 Elys, John, of Eton, Beds, husbandman 0
4957979 2344355 2344355 defendant Cadwade Robert husbandman 626770 626770 Cadwade, Robert, of Eton, Beds, husbandman 1
4958719 2344574 2344574 defendant Bullok Robert gent 626770 626770 Bullok, Robert, of Eton, Beds, gent 0
4991746 2354415 2354415 defendant Stokker Thomas husbandman 626770 626770 Stokker, Thomas, of Eton, Beds, husbandman 0
4991750 2354416 2354416 defendant Stokker Thomas husbandman 626770 626770 Stokker, Thomas, of Eton, Beds, husbandman 0
4995690 2355553 2355553 defendant Bullok Robert esq 626770 626770 Bullok, Robert, of Eton, Beds, esq 0
5029828 2365598 2365598 defendant Stokker Thomas woolman 626770 626770 Stokker, Thomas, of Eton, Beds, woolman 0
5045797 2370378 2370378 defendant Bullok Robert gent 626770 626770 Bullok, Robert, of Eton, Beds, gent 0
5047431 2370852 2370852 defendant Stokker Thomas yeoman 626770 626770 Stokker, Thomas, of Eton, Beds, yeoman 0
5061743 2375108 2375108 defendant Hobbes John maltman 626770 626770 Hobbes, John, of Eton, Beds, maltman 0
5078189 2379963 2379963 defendant Langonho John husbandman 626770 626770 Langonho, John, of Eton, Beds, husbandman 1
5083672 2381616 2381616 defendant Chaumberleyn Thomas husbandman 626770 626770 Chaumberleyn, Thomas, of Eton, Beds, husbandman 12
5160494 2404160 2404160 defendant Langno John husbandman 626770 626770 Langno, John, of Eton, Beds, husbandman 1
5191007 2413112 2413112 defendant Hille John smith 626770 626770 Hille, John, of Eton, Beds, smith 3
5205761 2417425 2417425 defendant Fyssher John butcher 626770 626770 Fyssher, John, of Eton, Beds, butcher 1
5207184 2417840 2417840 defendant Hille John smith 626770 626770 Hille, John, of Eton, Beds, smith 3
5247424 2429402 2429402 defendant Drewell William laborer 626770 626770 Drewell, William, of Eton, Beds, laborer 0
5259486 2433088 2433088 defendant Hervy Thomas fuller 626770 626770 Hervy, Thomas, of Eton, Beds, fuller 0
5383752 2470435 2470435 defendant Stokes John, senior (legal representative) 626770 626770 Stokes, John, senior, of Eton, Beds, husbandman, executrix of 4
5383753 2470435 2470435 defendant Stokes Agnes widow 626770 626770 Stokes, Agnes, of Eton, Beds, widow 5
5393229 2473115 2473115 defendant Wale Robert gent 626770 626770 Wale, Robert, of Eton, Beds, gent 4
5395581 2473816 2473816 defendant Stokes John, senior (legal representative) 626770 626770 Stokes, John, senior, of Eton, Beds, husbandman, executor of 3
5395582 2473816 2473816 defendant Stokes Agnes widow 626770 626770 Stokes, Agnes, of Eton, Beds, widow 4
5399811 2475040 2475040 defendant Wale Robert gent 626770 626770 Wale, Robert, of Eton, Beds, gent 4
5408621 2477543 2477543 defendant Stokes John (legal representative) 626770 626770 Stokes, John, of Eton, Beds, husbandman, executrix of 3
5408622 2477543 2477543 defendant Stokes Agnes widow 626770 626770 Stokes, Agnes, of Eton, Beds, widow 4
5419450 2480735 2480735 defendant Wale Robert gent 626770 626770 Wale, Robert, of Eton, Beds, gent 3
5475834 2497774 2497774 defendant Bette John gent 626770 626770 Bette, John, of Eton, Beds, gent 0
5487177 2501060 2501060 defendant Swetnam William tailor 626770 626770 Swetnam, William, of Eton, Beds, tailor 4
5496957 2504023 2504023 defendant Bronde William clerk 626770 626770 Bronde, William, of Eton, Beds, clerk 0
5516457 2509975 2509975 defendant Bronde William clerk 626770 626770 Bronde, William, of Eton, Beds, clerk 2
5516464 2509976 2509976 defendant Bronde William clerk 626770 626770 Bronde, William, of Eton, Beds, clerk 2
5539828 2516936 2516936 defendant Roodys Richard husbandman 626770 626770 Roodys, Richard, of Eton, Beds, husbandman 0
5549461 2519896 2519896 defendant Boston Robert husbandman 626770 626770 Boston, Robert, of Eton, Beds, husbandman 2
5629044 2553054 2553054 defendant Turnour Richard tailor 626770 626770 Turnour, Richard, of Eton, Beds, tailor 1
5632346 2554148 2554148 defendant Abbot John husbandman 626770 626770 Abbot, John, of Eton, Beds, husbandman 2

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);