names

15 rows where place_id = 588402

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594368 1865870 1865870 defendant Jamys William husbandman 588402 588402 Jamys, William, of Brokworth, husbandman 1
3715546 1931147 1931147 defendant Theyer John husbandman 588402 588402 Theyer, John, of Brokworth, husbandman 0
3715547 1931147 1931147 defendant Theyer Thomas husbandman 588402 588402 Theyer, Thomas, of Brokworth, husbandman 1
4449341 2184742 2184742 defendant Boner or Bover Walter   588402 588402 Boner or Bover, Walter, of Brokworth 1
4526734 2208640 2208640 defendant Clerk John   588402 588402 Clerk, John, of Brokworth 7
4526738 2208640 2208640 defendant Smyth John   588402 588402 Smyth, John, of Brokworth 11
4526742 2208640 2208640 defendant Walker John   588402 588402 Walker, John, of Brokworth 15
4541421 2213214 2213214 defendant Sherston Thomas   588402 588402 Sherston, Thomas, of Brokworth 0
4783122 2290737 2290737 defendant Ives John husbandman 588402 588402 Ives, John, of Brokworth, husbandman 0
4792765 2293825 2293825 defendant Inys or Ivys John husbandman 588402 588402 Inys or Ivys, John, of Brokworth, husbandman 0
4825484 2304016 2304016 defendant Sely Walter laborer 588402 588402 Sely, Walter, of Brokworth, laborer 0
4883800 2321840 2321840 defendant Clerke John husbandman 588402 588402 Clerke, John, of Brokworth, husbandman 2
5381255 2469692 2469692 defendant Hobbes John husbandman 588402 588402 Hobbes, John, of Brokworth, husbandman 0
5429047 2483610 2483610 defendant Draper John   588402 588402 Draper, John, of Brokworth 0
5505726 2506709 2506709 defendant Chapman John husbandman 588402 588402 Chapman, John, of Brokworth, 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);