names

50 rows where place_id = 619381

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3729669 1935531 1935531 defendant Wylcokk William tucker 619381 619381 Wylcokk, William, of Lacok, tucker 0
3730246 1935688 1935688 defendant Baynard Henry gent 619381 619381 Baynard, Henry, of Lacok, gent 0
3735405 1937310 1937310 defendant Tukar Thomas butcher 619381 619381 Tukar, Thomas, of Lacok, butcher 0
3747238 1941056 1941056 defendant Nevull John clothier 619381 619381 Nevull, John, of Lacok, clothier 0
3779069 1951179 1951179 defendant Nobull John clothier 619381 619381 Nobull, John, of Lacok, clothier 0
3787944 1954023 1954023 defendant Nobyll John clothman 619381 619381 Nobyll, John, of Lacok, clothman 1
3804165 1959234 1959234 defendant Nobyll John clothman 619381 619381 Nobyll, John, of Lacok, clothman 0
3813293 1962068 1962068 defendant Nobull John clothier 619381 619381 Nobull, John, of Lacok, clothier 0
4537705 2212068 2212068 plaintiff Tanner Thomas   619381 619381 Tanner, Thomas, of Lacok 0
4600843 2231487 2231487 defendant Lovell John   619381 619381 Lovell, John, of Lacok 0
4631155 2240643 2240643 defendant Cook John   619381 619381 Cook, John, of Lacok 2
4643160 2244108 2244108 defendant Coke John   619381 619381 Coke, John, of Lacok 1
4647249 2245250 2245250 defendant Cook John   619381 619381 Cook, John, of Lacok 1
4657964 2248376 2248376 defendant Cook John   619381 619381 Cook, John, of Lacok, cook 0
4685899 2261181 2261181 defendant Tut John wheeler 619381 619381 Tut, John, of Lacok, wheeler 1
4753655 2281515 2281515 plaintiff Webbe Robert   619381 619381 Webbe, Robert, of Lacok 0
4787840 2292262 2292262 defendant Draper John husbandman 619381 619381 (Draper, John, of Lacok, husbandman 1
4796626 2295094 2295094 defendant Mason Walter   619381 619381 Mason, Walter, of Lacok, mason 3
4858210 2313937 2313937 defendant Mome John husbandman 619381 619381 Mome, John, of Lacok, husbandman 4
4869350 2317381 2317381 defendant Hopere John husbandman 619381 619381 Hopere, John, of Lacok, husbandman 1
4891593 2324110 2324110 defendant Britte John husbandman 619381 619381 Britte, John, of Lacok, husbandman 0
4904416 2327995 2327995 defendant Shepherd John   619381 619381 Shepherd, John, of Lacok, shepherd 0
4910979 2329945 2329945 defendant Frye John   619381 619381 Frye, John, of Lacok, mason 0
4912765 2330494 2330494 plaintiff Corvyser Thomas shoemaker 619381 619381 Corvyser, Thomas, of Lacok, shoemaker 2
4912766 2330494 2330494 plaintiff Corvyser Peter-servant-of-Thomas   619381 619381 Corvyser, Peter-servant-of-Thomas, of Lacok, servant 3
4912782 2330494 2330494 plaintiff Sexteyn William yeoman 619381 619381 Sexteyn, William, of Lacok, yeoman 19
4912786 2330494 2330494 plaintiff Scotte Walter husbandman 619381 619381 Scotte, Walter, of Lacok, husbandman 23
4913454 2330706 2330706 defendant Hemmesby John husbandman 619381 619381 Hemmesby, John, of Lacok, husbandman 0
4913455 2330706 2330706 defendant Taillour John husbandman 619381 619381 Taillour, John, of Lacok, husbandman 1
4946021 2340743 2340743 defendant Hosyer Robert hosier 619381 619381 Hosyer, Robert, of Lacok, hosier 2
4968267 2347468 2347468 defendant Baldewyn Richard   619381 619381 Baldewyn, Richard, of Lacok, freemason 0
4969948 2347959 2347959 defendant Rewe Thomas   619381 619381 Rewe, Thomas, of Lacok, "corsetere" 6
4996206 2355720 2355720 defendant Baker William tanner 619381 619381 Baker, William, of Lacok, tanner 2
4996207 2355720 2355720 defendant Okeborne Walter   619381 619381 Okeborne, Walter, of Lacok, mason 3
5200518 2415910 2415910 defendant Mathewe Robert shoemaker 619381 619381 Mathewe, Robert, of Lacok, shoemaker 0
5206901 2417753 2417753 defendant Strong John yeoman 619381 619381 Strong, John, of Lacok, yeoman 0
5222682 2422349 2422349 defendant Saunders Thomas gent 619381 619381 together with Saunders, Thomas, of Lacok, gent 2
5222683 2422349 2422349 defendant Okeborne Robert yeoman 619381 619381 Okeborne, Robert, of Lacok, yeoman 3
5222684 2422349 2422349 defendant Vycary John carter 619381 619381 Vycary, John, of Lacok, carter 4
5225631 2423168 2423168 defendant Broke John gent 619381 619381 Broke, John, of Lacok, gent 0
5225633 2423169 2423169 defendant Crowe John gent 619381 619381 Crowe, John, of Lacok, gent 0
5237963 2426693 2426693 defendant Saundres Margaret widow 619381 619381 Saundres, Margaret, of Lacok, widow 0
5240956 2427559 2427559 defendant Kynge John husbandman 619381 619381 Kynge, John, of Lacok, husbandman 0
5240957 2427559 2427559 defendant Swayn John   619381 619381 Swayn, John, of Lacok, millward 1
5240959 2427560 2427560 defendant Puddyng William husbandman 619381 619381 Puddyng, William, of Lacok, husbandman 0
5256967 2432311 2432311 defendant Croke John gent 619381 619381 Croke, John, of Lacok, gent 0
5262182 2433920 2433920 defendant Frye John   619381 619381 Frye, John, of Lacok, freemason 4
5322332 2451753 2451753 defendant Webbe Henry husbandman 619381 619381 Webbe, Henry, of Lacok, husbandman 0
5481308 2499354 2499354 defendant Colbronde John husbandman 619381 619381 Colbronde, John, of Lacok, husbandman 8
5481309 2499354 2499354 defendant Ludlowe William husbandman 619381 619381 Ludlowe, William, of Lacok, husbandman 9

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