names

20 rows where place_id = 613799

✎ 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
3700341 1926346 1926346 defendant Hussher John yeoman 613799 613799 Hussher, John, of Hokyngton, yeoman 1
3724144 1933835 1933835 defendant Ussher John yeoman 613799 613799 Ussher, John, of Hokyngton, yeoman 0
3823677 1965303 1965303 defendant Roger Edmund husbandman 613799 613799 Roger, Edmund, of Hokyngton, husbandman 0
4477540 2193644 2193644 defendant Grene Robert   613799 613799 Grene, Robert, of Hokyngton 0
4495571 2199297 2199297 defendant Free John   613799 613799 Free, John, of Hokyngton 0
4499955 2200624 2200624 defendant Pet--- Robert   613799 613799 Pet---, Robert, of Hokyngton 1
4575340 2223801 2223801 plaintiff Boston Thomas   613799 613799 Boston, Thomas, of Hokyngton 0
4671645 2256777 2256777 defendant Bocher Nicholas butcher 613799 613799 Bocher, Nicholas, of Hokyngton, butcher 0
4671646 2256777 2256777 defendant Davy John husbandman 613799 613799 Davy, John, of Hokyngton, husbandman 1
4773902 2287816 2287816 defendant Spencer (illegible) husbandman 613799 613799 Spencer, _, of Hokyngton, husbandman 1
4897270 2325805 2325805 defendant Hokyngton Simon gent 613799 613799 Hokyngton, Simon, of Hokyngton, gent 0
5052950 2372473 2372473 defendant Smyth Robert smith 613799 613799 Smyth, Robert, of Hokyngton, smith 0
5307619 2447294 2447294 defendant Wighton John gent 613799 613799 Wighton, John, of Hokyngton, gent 1
5320621 2451260 2451260 defendant Barbour John husbandman 613799 613799 Barbour, John, of Hokyngton, husbandman 0
5320622 2451260 2451260 defendant Wode Thomas husbandman 613799 613799 Wode, Thomas, of Hokyngton, husbandman 1
5335823 2455778 2455778 defendant Wyghton William gent 613799 613799 Wyghton, William, of Hokyngton, gent 0
5353745 2461237 2461237 defendant Wyghton William gent 613799 613799 Wyghton, William, of Hokyngton, gent 0
5495904 2503670 2503670 defendant Wode atte Grene Thomas husbandman 613799 613799 Wode atte Grene, Thomas, of Hokyngton, husbandman 0
5495905 2503670 2503670 defendant Warde James husbandman 613799 613799 Warde, James, of Hokyngton, husbandman 1
5510903 2508250 2508250 defendant Impyngton William husbandman 613799 613799 Impyngton, William, of Hokyngton, husbandman 1

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