names

35 rows where place_id = 595686

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621473 1874255 1874255 defendant Hull John husbandman 595686 595686 Hull, John, of Neuport Paynell, Bucks, husbandman 3
4622996 2238169 2238169 defendant Tryklove Simon   595686 595686 Tryklove, Simon, of Neuport Paynell, Bucks 3
4654032 2247145 2247145 defendant Barkere Simon yeoman 595686 595686 Barkere, Simon, of Neuport Paynell, Bucks, yeoman 0
4671551 2256748 2256748 defendant Taillour Adam tailor 595686 595686 Taillour, Adam, of Neuport Paynell, Bucks, tailor 0
4671553 2256749 2256749 defendant Taillour Adam tailor 595686 595686 Taillour, Adam, of Neuport Paynell, Bucks, tailor 0
4686215 2261286 2261286 defendant Stafford Richard butcher 595686 595686 Stafford, Richard, of Neuport Paynell, Bucks, butcher 1
4688328 2261918 2261918 defendant Wyrehale Hugh ostler 595686 595686 Wyrehale, Hugh, of Neuport Paynell, Bucks, ostler 0
4777876 2289067 2289067 defendant Abbeye Thomas husbandman 595686 595686 Abbeye, Thomas, of Neuport Paynell, Bucks, husbandman 2
4805241 2297839 2297839 defendant Byrches Thomas husbandman 595686 595686 Byrches, Thomas, of Neuport Paynell, Bucks, husbandman 1
4863056 2315422 2315422 defendant Peyto John fuller 595686 595686 Peyto, John, of Neuport Paynell, Bucks, fuller 2
4872392 2318326 2318326 defendant Tomes Ralph smith 595686 595686 Tomes, Ralph, of Neuport Paynell, Bucks, smith 0
4892992 2324532 2324532 defendant Credelyng John chapman 595686 595686 Credelyng, John, of Neuport Paynell, Bucks, chapman 0
4924709 2334166 2334166 defendant Fycher John husbandman 595686 595686 Fycher, John, of Neuport Paynell, Bucks, husbandman 0
4924710 2334166 2334166 defendant Cradelyng John (legal representative) 595686 595686 Cradelyng, John, of Neuport Paynell, Bucks, chapman, executors of 1
4924726 2334170 2334170 defendant Fycher John husbandman 595686 595686 Fycher, John, of Neuport Paynell, Bucks, husbandman 0
4924727 2334170 2334170 defendant Cradelyng John (legal representative) 595686 595686 Cradelyng, John, of Neuport Paynell, Bucks, chapman, executors of 1
4943947 2340071 2340071 defendant Hobbes Thomas maltman 595686 595686 Hobbes, Thomas, of Neuport Paynell, Bucks, maltman 2
5020795 2362978 2362978 defendant Fyssh John fisher 595686 595686 Fyssh, John, of Neuport Paynell, Bucks, fisher 1
5022806 2363582 2363582 defendant Peyto John dyer 595686 595686 Peyto, John, of Neuport Paynell, Bucks, dyer 3
5022812 2363583 2363583 defendant Peyto John dyer 595686 595686 Peyto, John, of Neuport Paynell, Bucks, dyer 3
5029110 2365390 2365390 defendant Wyrale William gent 595686 595686 Wyrale, William, of Neuport Paynell, Bucks, gent 1
5037760 2367919 2367919 defendant Fyssher John yeoman 595686 595686 Fyssher, John, of Neuport Paynell, Bucks, yeoman 0
5053792 2372735 2372735 defendant Barker Robert chapman 595686 595686 Barker, Robert, of Neuport Paynell, Bucks, chapman 0
5079119 2380241 2380241 defendant Hobbys Ralph husbandman 595686 595686 Hobbys, Ralph, of Neuport Paynell, Bucks, husbandman 0
5083519 2381571 2381571 defendant Wyrall William gent 595686 595686 Wyrall, William, of Neuport Paynell, Bucks, gent 6
5094891 2384921 2384921 defendant Fyssher John ostler 595686 595686 Fyssher, John, of Neuport Paynell, Bucks, ostler 0
5096474 2385401 2385401 defendant Smyth John chapman 595686 595686 Smyth, John, of Neuport Paynell, Bucks, chapman 3
5096480 2385402 2385402 defendant Smyth John chapman 595686 595686 Smyth, John, of Neuport Paynell, Bucks, chapman 3
5103605 2387481 2387481 defendant Hobbys Ralph husbandman 595686 595686 Hobbys, Ralph, of Neuport Paynell, Bucks, husbandman 1
5242052 2427879 2427879 defendant Barker Thomas osteler 595686 595686 (Barker, Thomas, of Neuport Paynell, Bucks, osteler 5
5267879 2435718 2435718 defendant Sharp John chapman 595686 595686 Sharp, John, of Neuport Paynell, Bucks, chapman 0
5284127 2440378 2440378 defendant Peyto Robert innholder 595686 595686 Peyto, Robert, of Neuport Paynell, Bucks, innholder 0
5311229 2448385 2448385 defendant Cornell John yeoman 595686 595686 Cornell, John, of Neuport Paynell, Bucks, yeoman 0
5340867 2457343 2457343 defendant Peytowe John fuller 595686 595686 Peytowe, John, of Neuport Paynell, Bucks, fuller 4
5632390 2554165 2554165 defendant Waleys Thomas spicer 595686 595686 Waleys, Thomas, of Neuport Paynell, Bucks, spicer 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);