names

34 rows where place_id = 586182

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588104 1863928 1863928 defendant Cherche William yeoman 586182 586182 Cherche, William, of Ardeley, yeoman 0
3588268 1863986 1863986 defendant Kyng William husbandman 586182 586182 Kyng, William, of Ardeley, husbandman 0
3686854 1922049 1922049 defendant Hawkyns John husbandman 586182 586182 Hawkyns, John, of Ardeley, husbandman 1
3701963 1926866 1926866 defendant Grenelyff Thomas laborer 586182 586182 Grenelyff, Thomas, of Ardeley, laborer 0
3845099 1972024 1972024 defendant Heydon Edward clerk 586182 586182 Heydon, Edward, of Ardeley, clerk 0
3845101 1972025 1972025 defendant Heydon Edward clerk 586182 586182 Heydon, Edward, of Ardeley, clerk 0
3899033 1989882 1989882 defendant Starlyng James clothmaker 586182 586182 Starlyng, James, of Ardeley, clothmaker 1
3935444 2002167 2002167 defendant Cam Richard   586182 586182 Cam, Richard, of Ardeley, cloth man 0
4716391 2270446 2270446 plaintiff Whytyng Walter   586182 586182 Whytyng, Walter, of Ardeley 0
4735547 2276266 2276266 defendant Cook Thomas husbandman 586182 586182 Cook, Thomas, of Ardeley, husbandman 3
4785713 2291564 2291564 defendant Goldsmyth John yeoman 586182 586182 Goldsmyth, John, of Ardeley, yeoman 0
4800530 2296346 2296346 defendant Goldsmyth John yeoman 586182 586182 Goldsmyth, John, of Ardeley, yeoman 3
5045204 2370195 2370195 defendant Cook Thomas   586182 586182 Cook, Thomas, of Ardeley 4
5123068 2393181 2393181 defendant Cowey John, junior laborer 586182 586182 Cowey, John, junior, of Ardeley, laborer 4
5123242 2393235 2393235 defendant Coke Thomas yeoman 586182 586182 Coke, Thomas, of Ardeley, yeoman 1
5133752 2396363 2396363 defendant Brokkeford John weaver 586182 586182 Brokkeford, John, of Ardeley, weaver 0
5133755 2396363 2396363 defendant Baker Thomas weaver 586182 586182 Baker, Thomas, of Ardeley, weaver 3
5205649 2417396 2417396 plaintiff Broun Thomas   586182 586182 Broun, Thomas, of Ardeley, iron worker 2
5235383 2425930 2425930 defendant Pacche John wooder 586182 586182 Pacche, John, of Ardeley, wooder 0
5316008 2449863 2449863 defendant Baker Thomas clothmaker 586182 586182 Baker, Thomas, of Ardeley, clothmaker 0
5330168 2454098 2454098 defendant Kyng William husbandman 586182 586182 Kyng, William, of Ardeley, husbandman 0
5353341 2461122 2461122 defendant Brokford John clothmaker 586182 586182 Brokford, John, of Ardeley, clothmaker 4
5434490 2485258 2485258 defendant Aleyn Peter husbandman 586182 586182 Aleyn, Peter, of Ardeley, husbandman 0
5434492 2485258 2485258 defendant Willy John smith 586182 586182 Willy, John, of Ardeley, smith 2
5489698 2501802 2501802 defendant Patche William, junior clothmaker 586182 586182 Patche, William, junior, of Ardeley, clothmaker 0
5504211 2506231 2506231 defendant Pacche William, junior clothmaker 586182 586182 Pacche, William, junior, of Ardeley, clothmaker 1
5504212 2506231 2506231 defendant Pacche William clothmaker 586182 586182 Pacche, William, of Ardeley, clothmaker 2
5505965 2506788 2506788 defendant Pacche William clothmaker 586182 586182 Pacche, William, of Ardeley, clothmaker 0
5525108 2512442 2512442 defendant Squyer John weaver 586182 586182 Squyer, John, of Ardeley, weaver 0
5548062 2519466 2519466 defendant Bastere William laborer 586182 586182 Bastere, William, of Ardeley, laborer 6
5548070 2519467 2519467 defendant Baster William laborer 586182 586182 Baster, William, of Ardeley, laborer 6
5548075 2519468 2519468 defendant Baster William laborer 586182 586182 Baster, William, of Ardeley, laborer 3
5548083 2519469 2519469 defendant Baster William laborer 586182 586182 Baster, William, of Ardeley, laborer 3
5631839 2553975 2553975 defendant Hunt Thomas, junior   586182 586182 Hunt, Thomas, junior, of Ardeley 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);