names

29 rows where place_id = 613141

✎ 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
3696824 1925230 1925230 defendant Tukfeld John husbandman 613141 613141 Tukfeld, John, of Asshewater, husbandman 0
3696825 1925230 1925230 defendant Ryche Robert husbandman 613141 613141 Ryche, Robert, of Asshewater, husbandman 1
3696826 1925230 1925230 defendant Hokday John husbandman 613141 613141 Hokday, John, of Asshewater, husbandman 2
4570269 2222275 2222275 defendant Ryche Mathew   613141 613141 Ryche, Mathew, of Asshewater 1
4589433 2228069 2228069 defendant Fynamour John   613141 613141 Fynamour, John, of Asshewater 2
4619555 2237108 2237108 defendant Kymthorn John   613141 613141 Kymthorn, John, of Asshewater 0
4673964 2257473 2257473 defendant Harry John husbandman 613141 613141 Harry, John, of Asshewater, husbandman 1
4759991 2283463 2283463 defendant Hurde William husbandman 613141 613141 Hurde, William, of Asshewater, husbandman 2
4786173 2291712 2291712 defendant Smale Walter husbandman 613141 613141 Smale, Walter, of Asshewater, husbandman 0
4825540 2304029 2304029 defendant Smyth Robert husbandman 613141 613141 Smyth, Robert, of Asshewater, husbandman 4
5017809 2362089 2362089 defendant Blakedon Thomas yeoman 613141 613141 Blakedon, Thomas, of Asshewater, yeoman 3
5017814 2362090 2362090 defendant Blakedon Thomas yeoman 613141 613141 Blakedon, Thomas, of Asshewater, yeoman 3
5034033 2366821 2366821 defendant Jane Stephen husbandman 613141 613141 Jane, Stephen, of Asshewater, husbandman 0
5034034 2366821 2366821 defendant Wolf Walter husbandman 613141 613141 Wolf, Walter, of Asshewater, husbandman 1
5034039 2366822 2366822 defendant Jaye Stephen husbandman 613141 613141 Jaye, Stephen, of Asshewater, husbandman 0
5034040 2366822 2366822 defendant Wolf Walter husbandman 613141 613141 Wolf, Walter, of Asshewater, husbandman 1
5076836 2379567 2379567 defendant Jane Stephen husbandman 613141 613141 Jane, Stephen, of Asshewater, husbandman 0
5103294 2387393 2387393 defendant Fenston John husbandman 613141 613141 Fenston, John, of Asshewater, husbandman 3
5117602 2391583 2391583 defendant Jane Stephen yeoman 613141 613141 Jane, Stephen, of Asshewater, yeoman 0
5117603 2391583 2391583 defendant Wolfe John, senior husbandman 613141 613141 together with Wolfe, John, senior, of Asshewater, husbandman 1
5117604 2391583 2391583 defendant Andrewe John husbandman 613141 613141 Andrewe, John, of Asshewater, husbandman 2
5117606 2391584 2391584 defendant Wolfe John, senior husbandman 613141 613141 Wolfe, John, senior, of Asshewater, husbandman 0
5117607 2391584 2391584 defendant Andrewe John husbandman 613141 613141 Andrewe, John, of Asshewater, husbandman 1
5366518 2465182 2465182 defendant Hokday John tailor 613141 613141 Hokday, John, of Asshewater, tailor 2
5368297 2465702 2465702 defendant Roggerman John husbandman 613141 613141 Roggerman, John, of Asshewater, husbandman 0
5368298 2465702 2465702 defendant Roggerman William husbandman 613141 613141 Roggerman, William, of Asshewater, husbandman 1
5503857 2506122 2506122 defendant Malyverer Halnathan esq 613141 613141 Malyverer, Halnathan, of Asshewater, esq 0
5588436 2531388 2531388 defendant Toll John miller 613141 613141 Toll, John, of Asshewater, miller 1
5627752 2552651 2552651 defendant Langedon John husbandman 613141 613141 Langedon, John, of Asshewater, husbandman 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);