names

44 rows where place_id = 600275

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640404 1907429 1907429 defendant Bedford Thomas yeoman 600275 600275 Bedford, Thomas, of Tettesworth, yeoman 0
4416077 2169912 2169912 defendant Andreu Nicholas de   600275 600275 Andreu, Nicholas de, of Tettesworth, son of William 3
4481587 2194938 2194938 defendant Crook John   600275 600275 Crook, John, of Tettesworth 0
4493580 2198696 2198696 defendant Crook John   600275 600275 Crook, John, of Tettesworth 0
4493581 2198696 2198696 defendant Spaldyng Nicholas   600275 600275 Spaldyng, Nicholas, of Tettesworth 1
4501489 2201068 2201068 plaintiff Longe Thomas   600275 600275 Longe, Thomas, of Tettesworth, on his own account 0
4527124 2208767 2208767 defendant Bate Thomas   600275 600275 Bate, Thomas, of Tettesworth 0
4557966 2218424 2218424 defendant Bate Thomas   600275 600275 Bate, Thomas, of Tettesworth 0
4573722 2223297 2223297 defendant Spaldyng Nicholas   600275 600275 Spaldyng, Nicholas, of Tettesworth 0
4573723 2223297 2223297 defendant Dawe Thomas   600275 600275 Dawe, Thomas, of Tettesworth 1
4636113 2242126 2242126 defendant Manytorn John   600275 600275 Manytorn, John, of Tettesworth 0
4663974 2250218 2250218 defendant Bate Thomas, senior ploughman 600275 600275 Bate, Thomas, senior, of Tettesworth, ploughman 0
4663976 2250218 2250218 defendant Stoke John ploughman 600275 600275 Stoke, John, of Tettesworth, ploughman 2
4686977 2261535 2261535 defendant Revell Thomas hosteler 600275 600275 Revell, Thomas, of Tettesworth, hosteler 0
4734406 2275929 2275929 defendant Notte Joan hosteller 600275 600275 Notte, Joan, of Tettesworth, formerly wife of Thomas Notte, hosteller 0
4734417 2275932 2275932 defendant Notte Joan hostiler 600275 600275 Notte, Joan, of Tettesworth, formerly wife of Thomas, hostiler 0
4740639 2277780 2277780 plaintiff Bate Thomas   600275 600275 Bate, Thomas, of Tettesworth 0
4741157 2277917 2277917 defendant Revell Thomas ostler 600275 600275 Revell, Thomas, of Tettesworth, ostler 0
4743319 2278573 2278573 defendant Bate Thomas husbandman 600275 600275 Bate, Thomas, of Tettesworth, husbandman 0
4750214 2280540 2280540 defendant Bate Thomas ostiler 600275 600275 Bate, Thomas, of Tettesworth, ostiler 0
4765087 2285058 2285058 defendant Smart William husbandman 600275 600275 Smart, William, of Tettesworth, husbandman 0
4772221 2287284 2287284 plaintiff Spaldyng William   600275 600275 Spaldyng, William, of Tettesworth 0
4772222 2287284 2287284 defendant Dawe Thomas husbandman 600275 600275 Dawe, Thomas, of Tettesworth, husbandman 0
4772225 2287284 2287284 defendant Uppe John husbandman 600275 600275 Uppe, John, of Tettesworth, husbandman 3
4803352 2297240 2297240 defendant Bailly John husbandman 600275 600275 Bailly, John, of Tettesworth, husbandman 2
4803456 2297267 2297267 defendant Dawe Thomas husbandman 600275 600275 Dawe, Thomas, of Tettesworth, husbandman 0
4810522 2299436 2299436 defendant Bonde Richard gent 600275 600275 Bonde, Richard, of Tettesworth, gent 0
4830707 2305630 2305630 defendant Spaldyng William husbandman 600275 600275 Spaldyng, William, of Tettesworth, husbandman 0
4830708 2305630 2305630 defendant Crowe John husbandman 600275 600275 Crowe, John, of Tettesworth, husbandman 1
4914095 2330919 2330919 defendant Bond Richard yeoman 600275 600275 Bond, Richard, of Tettesworth, yeoman 0
4926435 2334686 2334686 defendant Cave Richard husbandman 600275 600275 Cave, Richard, of Tettesworth, husbandman 1
4992911 2354760 2354760 defendant Bond Richard   600275 600275 Bond, Richard, of Tettesworth, court holder 0
5080989 2380815 2380815 defendant Bond Richard   600275 600275 Bond, Richard, of Tettesworth, court holder 0
5087556 2382741 2382741 defendant Bond Richard gent 600275 600275 Bond, Richard, of Tettesworth, gent 0
5097616 2385729 2385729 defendant Crawe Richard husbandman 600275 600275 Crawe, Richard, of Tettesworth, husbandman 3
5097617 2385729 2385729 defendant Cane or Cave Richard, junior husbandman 600275 600275 Cane or Cave, Richard, junior, of Tettesworth, husbandman 4
5142062 2398801 2398801 defendant Bocher Henry butcher 600275 600275 Bocher, Henry, of Tettesworth, butcher 0
5142068 2398802 2398802 defendant Bocher Henry butcher 600275 600275 Bocher, Henry, of Tettesworth, butcher 0
5181901 2410455 2410455 defendant Mersshe Thomas husbandman 600275 600275 Mersshe, Thomas, of Tettesworth, husbandman 0
5293078 2442959 2442959 defendant Smyth John husbandman 600275 600275 Smyth, John, of Tettesworth, husbandman 0
5296907 2444086 2444086 defendant Preston Thomas ostler 600275 600275 Preston, Thomas, of Tettesworth, ostler 0
5481603 2499427 2499427 defendant Bates John gent 600275 600275 Bates, John, of Tettesworth, gent 2
5611873 2547450 2547450 defendant Loy Robert   600275 600275 Loy, Robert, of Tettesworth 0
5627312 2552510 2552510 defendant Jolyf John husbandman 600275 600275 Jolyf, John, of Tettesworth, husbandman 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);