names

23 rows where place_id = 603707

✎ 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
3655508 1911981 1911981 defendant Sparowe William yeoman 603707 603707 Sparowe, William, of Salcote, yeoman 1
3746997 1940980 1940980 defendant Feke Richard brewer 603707 603707 Feke, Richard, of Salcote, brewer 0
4416117 2169928 2169928 plaintiff Lor_ Robert   603707 603707 Lor_, Robert, of Salcote 0
4441553 2182292 2182292 defendant Hierde John (legal representative) 603707 603707 Hierde, John, of Salcote, executors of 0
4679527 2259213 2259213 defendant Wyard Andrew husbandman 603707 603707 Wyard, Andrew, of Salcote, husbandman 0
4679529 2259213 2259213 defendant Geryngton John dredger 603707 603707 Geryngton, John, of Salcote, dredger 2
4799831 2296129 2296129 defendant Pycot John butcher 603707 603707 Pycot, John, of Salcote, butcher 2
5065038 2376072 2376072 defendant Hunte Robert husbandman 603707 603707 Hunte, Robert, of Salcote, husbandman 4
5077822 2379857 2379857 defendant Hunt Robert cordwainer 603707 603707 Hunt, Robert, of Salcote, cordwainer 1
5079576 2380381 2380381 defendant Stamp Robert repier or fishmonger 603707 603707 Stamp, Robert, of Salcote, repier or fishmonger 0
5220388 2421659 2421659 defendant Songer John waterman 603707 603707 Songer, John, of Salcote, waterman 2
5269700 2436251 2436251 defendant Baron John husbandman 603707 603707 Baron, John, of Salcote, husbandman 0
5286721 2441125 2441125 defendant Algar William husbanman 603707 603707 Algar, William, of Salcote, husbanman 0
5286727 2441126 2441126 defendant Algar William husbanman 603707 603707 Algar, William, of Salcote, husbanman 0
5363890 2464357 2464357 plaintiff Wyk Stephen   603707 603707 Wyk, Stephen, of Salcote 3
5366438 2465157 2465157 defendant Wythes William laborer 603707 603707 Wythes, William, of Salcote, laborer 0
5436093 2485733 2485733 defendant Neweton John yeoman 603707 603707 Neweton, John, of Salcote, yeoman 6
5447702 2489187 2489187 defendant Neweton John yeoman 603707 603707 Neweton, John, of Salcote, yeoman 6
5491959 2502505 2502505 plaintiff Clerk John   603707 603707 Clerk, John, of Salcote 0
5497173 2504094 2504094 defendant Hyde William husbandman 603707 603707 Hyde, William, of Salcote, husbandman 0
5561013 2523191 2523191 defendant Clerk John, senior mercer 603707 603707 Clerk, John, senior, of Salcote, mercer 3
5561018 2523192 2523192 defendant Clerk John mercer 603707 603707 Clerk, John, of Salcote, mercer 3
5635450 2555054 2555054 defendant Gylot Thomas yeoman 603707 603707 Gylot, Thomas, of Salcote, yeoman 1

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