names

27 rows where place_id = 592484

✎ 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
3607850 1870105 1870105 defendant Wodde William yeoman 592484 592484 Wodde, William, of Wodhous, yeoman 0
3838867 1970082 1970082 defendant Gryffyth Geoffrey yeoman 592484 592484 Gryffyth, Geoffrey, of Wodhous, yeoman 3
4446494 2183816 2183816 defendant Pikker Robert   592484 592484 Pikker, Robert, of Wodhous 6
4645203 2244667 2244667 defendant Mawer John   592484 592484 Mawer, John, of Wodhous 0
4673845 2257439 2257439 defendant Norman Henry   592484 592484 Norman, Henry, of Wodhous, nail maker 0
4678594 2258911 2258911 defendant Watson William husbandman 592484 592484 Watson, William, of Wodhous, husbandman 0
4729005 2274308 2274308 defendant Watson William husbandman 592484 592484 Watson, William, of Wodhous, husbandman 0
4833154 2306381 2306381 defendant Sette William laborer 592484 592484 Sette, William, of Wodhous, laborer 1
4854590 2312815 2312815 defendant Northfold John husbandman 592484 592484 Northfold, John, of Wodhous, husbandman 2
5107247 2388548 2388548 defendant Vendelok William shipman 592484 592484 Vendelok, William, of Wodhous, shipman 2
5155116 2402645 2402645 defendant Buttirworth Geoffrey husbandman 592484 592484 Buttirworth, Geoffrey, of Wodhous, husbandman 3
5198897 2415429 2415429 defendant Overy John husbandman 592484 592484 Overy, John, of Wodhous, husbandman 1
5239054 2427014 2427014 defendant Skyrlay John yeoman 592484 592484 Skyrlay, John, of Wodhous, yeoman 0
5299061 2444708 2444708 defendant Wodhous William yeoman 592484 592484 Wodhous, William, of Wodhous, yeoman 0
5393872 2473310 2473310 defendant Paternoster William slater 592484 592484 Paternoster, William, of Wodhous, slater 0
5393873 2473310 2473310 defendant Balton Robert husbandman 592484 592484 Balton, Robert, of Wodhous, husbandman 1
5407057 2477080 2477080 defendant Paternoster alias Parker William slater & tiler 592484 592484 Paternoster alias Parker, William, of Wodhous, slater & tiler 0
5407058 2477080 2477080 defendant Dalton Robert husbandman 592484 592484 Dalton, Robert, of Wodhous, husbandman 1
5407059 2477080 2477080 defendant Asser Henry husbandman 592484 592484 Asser, Henry, of Wodhous, husbandman 2
5420241 2480976 2480976 defendant Dalton Robert husbandman 592484 592484 Dalton, Robert, of Wodhous, husbandman 0
5420242 2480976 2480976 defendant Asser John husbandman 592484 592484 Asser, John, of Wodhous, husbandman 1
5420244 2480977 2480977 defendant Dalton Robert husbandman 592484 592484 Dalton, Robert, of Wodhous, husbandman 0
5420245 2480977 2480977 defendant Asser John husbandman 592484 592484 Asser, John, of Wodhous, husbandman 1
5420247 2480978 2480978 defendant Paternoster William slater & tiles 592484 592484 Paternoster, William, of Wodhous, slater & tiles 0
5439030 2486594 2486594 defendant Dalton Robert husbandman 592484 592484 Dalton, Robert, of Wodhous, husbandman 0
5439031 2486594 2486594 defendant Asser John husbandman 592484 592484 Asser, John, of Wodhous, husbandman 1
5504462 2506312 2506312 defendant Atwode William   592484 592484 Atwode, William, of Wodhous 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);