names

44 rows where place_id = 754988

✎ 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
4424632 2172542 2172542 plaintiff Keterich Walter   754988 754988 Keterich, Walter, of Shaldeford 0
4434341 2175501 2175501 plaintiff Keterich Walter   754988 754988 Keterich, Walter, of Shaldeford 0
4521579 2207083 2207083 defendant Lucas John   754988 754988 Lucas, John, of Shaldeford 0
4568175 2221615 2221615 plaintiff Turnour John   754988 754988 Turnour, John, of Shaldeford 0
4586145 2227088 2227088 defendant Poorte John   754988 754988 Poorte, John, of Shaldeford 4
4596509 2230149 2230149 defendant Kyng Thomas   754988 754988 Kyng, Thomas, of Shaldeford 0
4652586 2246766 2246766 defendant Whateryche John husbandman 754988 754988 Whateryche, John, of Shaldeford, husbandman 1
4660109 2249007 2249007 defendant Huberd John husbandman 754988 754988 Huberd, John, of Shaldeford, husbandman 0
4660110 2249007 2249007 defendant Torner John husbandman 754988 754988 Torner, John, of Shaldeford, husbandman 1
4660115 2249009 2249009 defendant Huberd John husbandman 754988 754988 Huberd, John, of Shaldeford, husbandman 0
4660116 2249009 2249009 defendant Torner John husbandman 754988 754988 Torner, John, of Shaldeford, husbandman 1
4678611 2258915 2258915 defendant Kelhogg Walter husbandman 754988 754988 Kelhogg, Walter, of Shaldeford, husbandman 4
4686945 2261524 2261524 defendant Huberd John husbandman 754988 754988 Huberd, John, of Shaldeford, husbandman 0
4686946 2261524 2261524 defendant Thorner John husbandman 754988 754988 Thorner, John, of Shaldeford, husbandman 1
4689625 2262314 2262314 defendant Walsham Thomas   754988 754988 Walsham, Thomas, of Shaldeford, vicar & clerk 4
4697158 2264589 2264589 defendant Marchall John husbandman 754988 754988 Marchall, John, of Shaldeford, husbandman 0
4697159 2264589 2264589 defendant Babbe William husbandman 754988 754988 Babbe, William, of Shaldeford, husbandman 1
4749450 2280319 2280319 defendant Reynald John laborer 754988 754988 Reynald, John, of Shaldeford, laborer 0
4767706 2285880 2285880 defendant Reynold John carpenter 754988 754988 Reynold, John, of Shaldeford, carpenter 0
4795975 2294888 2294888 defendant Hascombe Walter husbandman 754988 754988 Hascombe, Walter, of Shaldeford, husbandman 0
4802841 2297076 2297076 defendant atte Watere Simon husbandman 754988 754988 atte Watere, Simon, of Shaldeford, husbandman 0
4802842 2297076 2297076 defendant atte Watere Letitia widow 754988 754988 atte Watere, Letitia, of Shaldeford, widow 1
4825918 2304138 2304138 defendant Reynold John husbandman 754988 754988 Reynold, John, of Shaldeford, husbandman 2
4843277 2309414 2309414 defendant Reynold John husbandman 754988 754988 Reynold, John, of Shaldeford, husbandman 3
4847906 2310826 2310826 defendant Est Thomas husbandman 754988 754988 Est, Thomas, of Shaldeford, husbandman 0
4917206 2331887 2331887 defendant Felite Roger gent 754988 754988 Felite, Roger, of Shaldeford, gent 0
4917970 2332134 2332134 defendant Reynold John yeoman 754988 754988 Reynold, John, of Shaldeford, yeoman 1
4966241 2346835 2346835 defendant Caton John husbandman 754988 754988 Caton, John, of Shaldeford, husbandman 1
4978503 2350518 2350518 defendant Hoberd John husbandman 754988 754988 Hoberd, John, of Shaldeford, husbandman 0
5006792 2358886 2358886 defendant Fowler John, sen husbandman 754988 754988 Fowler, John, sen, of Shaldeford, husbandman 1
5019753 2362656 2362656 defendant Caton John husbandman 754988 754988 Caton, John, of Shaldeford, husbandman 3
5019759 2362657 2362657 defendant Caton John husbandman 754988 754988 Caton, John, of Shaldeford, husbandman 3
5136544 2397203 2397203 defendant Reynold John laborer 754988 754988 Reynold, John, of Shaldeford, laborer 2
5139832 2398125 2398125 defendant Brette John carpenter 754988 754988 Brette, John, of Shaldeford, carpenter 1
5253748 2431286 2431286 plaintiff Brette John   754988 754988 Brette, John, of Shaldeford 0
5321236 2451448 2451448 defendant Wassheford Thomas yeoman 754988 754988 Wassheford, Thomas, of Shaldeford, yeoman 4
5321260 2451455 2451455 defendant Wassheford Thomas yeoman 754988 754988 Wassheford, Thomas, of Shaldeford, yeoman 4
5332831 2454888 2454888 defendant Nassh John husbandman 754988 754988 Nassh, John, of Shaldeford, husbandman 0
5332872 2454899 2454899 defendant Nassh John husbandman 754988 754988 Nassh, John, of Shaldeford, husbandman 0
5332876 2454900 2454900 defendant Nassh John husbandman 754988 754988 Nassh, John, of Shaldeford, husbandman 0
5480793 2499213 2499213 defendant Spencer Thomas yeoman 754988 754988 Spencer, Thomas, of Shaldeford, yeoman 2
5504758 2506407 2506407 defendant Nasshe John husbandman 754988 754988 Nasshe, John, of Shaldeford, husbandman 0
5516256 2509921 2509921 defendant Eliot Walter husbandman 754988 754988 Eliot, Walter, of Shaldeford, husbandman 0
5573292 2526744 2526744 defendant Purcas John, senior husbandman 754988 754988 Purcas, John, senior, of Shaldeford, 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);