names

32 rows where place_id = 772176

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4586088 2227074 2227074 defendant Ryvet William   772176 772176 Ryvet, William, of Sutton atte Hone 0
4782658 2290589 2290589 defendant Merford Richard sawyer 772176 772176 Merford, Richard, of Sutton atte Hone, sawyer 1
4807298 2298480 2298480 defendant Goderode John husbandman 772176 772176 Goderode, John, of Sutton atte Hone, husbandman 0
4808323 2298779 2298779 defendant Castell John husbandman 772176 772176 Castell, John, of Sutton atte Hone, husbandman 0
4858985 2314189 2314189 defendant Wynker William husbandman 772176 772176 Wynker, William, of Sutton atte Hone, husbandman 0
4887493 2322926 2322926 defendant Wynker William husbandman 772176 772176 Wynker, William, of Sutton atte Hone, husbandman 1
4912624 2330451 2330451 defendant Clerk William carpenter 772176 772176 Clerk, William, of Sutton atte Hone, carpenter 0
4958521 2344517 2344517 defendant Horne Henry husbandman 772176 772176 Horne, Henry, of Sutton atte Hone, husbandman 1
4961228 2345325 2345325 defendant Wynkere William husbandman 772176 772176 Wynkere, William, of Sutton atte Hone, husbandman 0
4978517 2350524 2350524 defendant West John husbandman 772176 772176 West, John, of Sutton atte Hone, husbandman 1
4998879 2356548 2356548 defendant Lyllyngston John tailor 772176 772176 Lyllyngston, John, of Sutton atte Hone, tailor 2
5005634 2358547 2358547 defendant Taillour Thomas clerk 772176 772176 Taillour, Thomas, of Sutton atte Hone, clerk 1
5012246 2360432 2360432 defendant West John husbandman 772176 772176 West, John, of Sutton atte Hone, husbandman 0
5017698 2362052 2362052 defendant Howeles Richard butcher 772176 772176 Howeles, Richard, of Sutton atte Hone, butcher 1
5018637 2362337 2362337 defendant Goderede John carpenter 772176 772176 Goderede, John, of Sutton atte Hone, carpenter 1
5018638 2362337 2362337 defendant Symond Thomas laborer 772176 772176 Symond, Thomas, of Sutton atte Hone, laborer 2
5018639 2362337 2362337 defendant Brygge Thomas husbandman 772176 772176 Brygge, Thomas, of Sutton atte Hone, husbandman 3
5027525 2364928 2364928 defendant Hale William laborer 772176 772176 Hale, William, of Sutton atte Hone, laborer 4
5043791 2369771 2369771 plaintiff Calverton John   772176 772176 (Calverton, John, of Sutton atte Hone, vicar 1
5052867 2372448 2372448 defendant Heweles Henry butcher 772176 772176 Heweles, Henry, of Sutton atte Hone, butcher 0
5069798 2377460 2377460 defendant Goderode William, junior husbandman 772176 772176 Goderode, William, junior, of Sutton atte Hone, husbandman 2
5141289 2398575 2398575 defendant Couper John husbandman 772176 772176 Couper, John, of Sutton atte Hone, husbandman 0
5210729 2418869 2418869 defendant Couper John husbandman 772176 772176 Couper, John, of Sutton atte Hone, husbandman 0
5234459 2425669 2425669 defendant Couper John husbandman 772176 772176 Couper, John, of Sutton atte Hone, husbandman 0
5242572 2428034 2428034 defendant Symon Thomas laborer 772176 772176 Symon, Thomas, of Sutton atte Hone, laborer 1
5273521 2437330 2437330 defendant Cotes Robert gent 772176 772176 Cotes, Robert, of Sutton atte Hone, gent 0
5327395 2453265 2453265 defendant Dey Thomas husbandman 772176 772176 Dey, Thomas, of Sutton atte Hone, husbandman 2
5377754 2468625 2468625 defendant Kyngesmell Robert laborer 772176 772176 Kyngesmell, Robert, of Sutton atte Hone, laborer 1
5431688 2484441 2484441 defendant Higham Hugh husbandman 772176 772176 Higham, Hugh, of Sutton atte Hone, husbandman 0
5436839 2485947 2485947 defendant Roche John husbandman 772176 772176 Roche, John, of Sutton atte Hone, husbandman 2
5487843 2501252 2501252 defendant Raynold William husbandman 772176 772176 Raynold, William, of Sutton atte Hone, husbandman 3
5503143 2505894 2505894 defendant Randalf Thomas yeoman 772176 772176 Randalf, Thomas, of Sutton atte Hone, yeoman 3

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