names

30 rows where place_id = 641435

✎ 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
3861551 1977325 1977325 defendant Hylde Hugh husbandman 641435 641435 Hylde, Hugh, of Cherryng, husbandman 0
4560454 2219211 2219211 defendant Brocton William   641435 641435 Brocton, William, of Cherryng 0
4567030 2221244 2221244 defendant atte Reye Roger   641435 641435 atte Reye, Roger, of Cherryng 0
4646831 2245137 2245137 defendant Cardere Robert   641435 641435 Cardere, Robert, of Cherryng 0
4651620 2246500 2246500 defendant Gate Thomas husbandman 641435 641435 Gate, Thomas, of Cherryng, husbandman 2
4651755 2246509 2246509 defendant Lpnge Robert yeoman 641435 641435 Lpnge, Robert, of Cherryng, yeoman 1
4743720 2278693 2278693 defendant Toche or toohe William yeoman 641435 641435 Toche or toohe, William, of Cherryng, yeoman 1
4745273 2279128 2279128 plaintiff Fylkys Simon husbandman 641435 641435 Fylkys, Simon, of Cherryng, husbandman 0
4745274 2279128 2279128 defendant Tubbe Richard husbandman 641435 641435 Tubbe, Richard, of Cherryng, husbandman 0
4781248 2290148 2290148 plaintiff Chapman William   641435 641435 Chapman, William, of Cherryng 0
4789923 2292918 2292918 defendant Gates Thomas husbandman 641435 641435 Gates, Thomas, of Cherryng, husbandman 0
4862072 2315147 2315147 defendant Mayhewe Robert carpenter 641435 641435 Mayhewe, Robert, of Cherryng, carpenter 0
4874054 2318825 2318825 defendant Mayhewe Robert carpenter 641435 641435 Mayhewe, Robert, of Cherryng, carpenter 1
4894108 2324853 2324853 defendant Prat William barber 641435 641435 Prat, William, of Cherryng, barber 3
4900931 2326920 2326920 plaintiff Pret William barber 641435 641435 Pret, William, of Cherryng, barber 0
4906554 2328634 2328634 defendant Gilot John husbandman 641435 641435 Gilot, John, of Cherryng, husbandman 8
4908832 2329312 2329312 defendant Prat William husbandman 641435 641435 Prat, William, of Cherryng, husbandman 4
4941972 2339473 2339473 defendant Mayhewe Robert carpenter 641435 641435 Mayhewe, Robert, of Cherryng, carpenter 1
4964454 2346280 2346280 defendant Toche John clothier 641435 641435 Toche, John, of Cherryng, clothier 0
4964456 2346281 2346281 defendant Toche John glover or clothier 641435 641435 Toche, John, of Cherryng, glover or clothier 0
5010407 2359912 2359912 defendant Blybery Thomas laborer 641435 641435 Blybery, Thomas, of Cherryng, laborer 0
5053020 2372500 2372500 defendant Colman John miller 641435 641435 Colman, John, of Cherryng, miller 0
5087262 2382654 2382654 defendant Tubbe Henry laborer 641435 641435 Tubbe, Henry, of Cherryng, laborer 1
5098017 2385850 2385850 plaintiff Tubbe Richard (legal representative) 641435 641435 Tubbe, Richard, of Cherryng, executors of 0
5117967 2391683 2391683 defendant Bryght Simon smith 641435 641435 Bryght, Simon, of Cherryng, smith 0
5126697 2394283 2394283 defendant Ovyngton John gent 641435 641435 Ovyngton, John, of Cherryng, gent 0
5218263 2421072 2421072 defendant Pratte Robert husbandman 641435 641435 Pratte, Robert, of Cherryng, husbandman 0
5492731 2502742 2502742 defendant Baldok Henry yeoman 641435 641435 Baldok, Henry, of Cherryng, yeoman 2
5494213 2503173 2503173 defendant Cherell William husbandman 641435 641435 Cherell, William, of Cherryng, husbandman 0
5633773 2554558 2554558 plaintiff Toche William   641435 641435 Toche, William, of Cherryng 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);