names

19 rows where place_id = 770222

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4565808 2220862 2220862 defendant Pycot John   770222 770222 Pycot, John, of Britford 0
4565809 2220862 2220862 defendant Body Philip   770222 770222 Body, Philip, of Britford 1
4594608 2229571 2229571 defendant Cook Walter   770222 770222 Cook, Walter, of Britford 0
4638435 2242784 2242784 defendant Irmonger Martin   770222 770222 Irmonger, Martin, of Britford 1
4653848 2247110 2247110 defendant Bryd Nicholas fisher 770222 770222 Bryd, Nicholas, of Britford, fisher 0
4712926 2269355 2269355 defendant Clerk John husbandman 770222 770222 Clerk, John, of Britford, husbandman 0
4870033 2317593 2317593 defendant Grey John husbandman 770222 770222 Grey, John, of Britford, husbandman 1
4872330 2318308 2318308 defendant Brice Henry husbandman 770222 770222 Brice, Henry, of Britford, husbandman 2
4876923 2319750 2319750 defendant Stratford John clerk 770222 770222 together with Stratford, John, of Britford, clerk 3
5001396 2357294 2357294 defendant Wygmore Henry merchant 770222 770222 Wygmore, Henry, of Britford, merchant 0
5017239 2361925 2361925 defendant Wygmore Henry clerk 770222 770222 Wygmore, Henry, of Britford, clerk 0
5184432 2411184 2411184 defendant Bordell John husbandman 770222 770222 Bordell, John, of Britford, husbandman 4
5184434 2411185 2411185 defendant Vyntener John husbandman 770222 770222 Vyntener, John, of Britford, husbandman 0
5204330 2417019 2417019 defendant Vyntener John husbandman 770222 770222 Vyntener, John, of Britford, husbandman 0
5221694 2422041 2422041 defendant Wygmore Henry clerk 770222 770222 Wygmore, Henry, of Britford, clerk 0
5257066 2432340 2432340 defendant Farnehill John forster 770222 770222 Farnehill, John, of Britford, forster 0
5362734 2463990 2463990 defendant Affernhille John yeoman 770222 770222 Affernhille, John, of Britford, yeoman 3
5627962 2552715 2552715 defendant Yonge John ploughman 770222 770222 Yonge, John, of Britford, ploughman 0
5627964 2552716 2552716 defendant Yonge John ploughman 770222 770222 Yonge, John, of Britford, ploughman 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);