names

21 rows where place_id = 602334

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649593 1910262 1910262 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 0
3649594 1910262 1910262 defendant Gwyn or Elkyn William husbandman 602334 602334 Gwyn or Elkyn, William, of Hutton Ruffe, husbandman 1
3649595 1910262 1910262 defendant Harlyng John husbandman 602334 602334 Harlyng, John, of Hutton Ruffe, husbandman 2
3649596 1910262 1910262 defendant Smyth Reginald husbandman 602334 602334 Smyth, Reginald, of Hutton Ruffe, husbandman 3
3649597 1910262 1910262 defendant More George husbandman 602334 602334 More, George, of Hutton Ruffe, husbandman 4
3649611 1910263 1910263 defendant Conder Christopher husbandman 602334 602334 Conder, Christopher, of Hutton Ruffe, husbandman 0
3649612 1910263 1910263 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 1
3649629 1910264 1910264 defendant Conder Christopher husbandman 602334 602334 Conder, Christopher, of Hutton Ruffe, husbandman 0
3649630 1910264 1910264 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 1
3649631 1910264 1910264 defendant Gwyn William husbandman 602334 602334 Gwyn, William, of Hutton Ruffe, husbandman 2
3649632 1910264 1910264 defendant Harwode Thomas husbandman 602334 602334 Harwode, Thomas, of Hutton Ruffe, husbandman 3
3649633 1910264 1910264 defendant Harlyng John husbandman 602334 602334 Harlyng, John, of Hutton Ruffe, husbandman 4
3649634 1910264 1910264 defendant Smyth Reginald husbandman 602334 602334 Smyth, Reginald, of Hutton Ruffe, husbandman 5
3649635 1910264 1910264 defendant More George husbandman 602334 602334 More, George, of Hutton Ruffe, husbandman 6
3649647 1910265 1910265 defendant Conder Christopher husbandman 602334 602334 Conder, Christopher, of Hutton Ruffe, husbandman 0
3649648 1910265 1910265 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 1
3649649 1910265 1910265 defendant Gwyn William husbandman 602334 602334 Gwyn, William, of Hutton Ruffe, husbandman 2
3649650 1910265 1910265 defendant Harwode Thomas husbandman 602334 602334 Harwode, Thomas, of Hutton Ruffe, husbandman 3
3649651 1910265 1910265 defendant Harlyng John husbandman 602334 602334 Harlyng, John, of Hutton Ruffe, husbandman 4
3649652 1910265 1910265 defendant Smyth Reginald husbandman 602334 602334 Smyth, Reginald, of Hutton Ruffe, husbandman 5
3649653 1910265 1910265 defendant More George husbandman 602334 602334 More, George, of Hutton Ruffe, husbandman 6

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