names

23 rows where place_id = 616747

✎ 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
3715882 1931253 1931253 defendant Hyk Walter tailor 616747 616747 Hyk, Walter, of Trewen, tailor 0
4040905 2039236 2039236 defendant Heny John   616747 616747 Heny, John, of Trewen, mason 2
4040906 2039236 2039236 defendant Northey Bartholomew husbandman 616747 616747 Northey, Bartholomew, of Trewen, husbandman 3
4085311 2055027 2055027 defendant Wooger Thomas husbandman 616747 616747 Wooger, Thomas, of Trewen, husbandman 0
4085312 2055027 2055027 defendant Browne William husbandman 616747 616747 Browne, William, of Trewen, husbandman 1
4085315 2055028 2055028 defendant Wooger Thomas husbandman 616747 616747 Wooger, Thomas, of Trewen, husbandman 0
4085316 2055028 2055028 defendant Browne William husbandman 616747 616747 Browne, William, of Trewen, husbandman 1
4085319 2055029 2055029 defendant Browne William husbandman 616747 616747 Browne, William, of Trewen, husbandman 0
4117617 2066596 2066596 defendant Browne William husbandman 616747 616747 Browne, William, of Trewen, husbandman 1
4166066 2083637 2083637 defendant Burnbery Mathew husbandman 616747 616747 Burnbery, Mathew, of Trewen, husbandman 0
4171346 2085442 2085442 defendant Browne William husbandman 616747 616747 Browne, William, of Trewen, husbandman 0
4171347 2085442 2085442 defendant Burneberie Mathew husbandman 616747 616747 Burneberie, Mathew, of Trewen, husbandman 1
4180845 2088780 2088780 defendant Wynston Thomas gent 616747 616747 Wynston, Thomas, of Trewen, gent 1
4248220 2112396 2112396 defendant Nuttinge Richard husbandman 616747 616747 Nuttinge, Richard, of Trewen, husbandman 0
4248221 2112396 2112396 defendant Gimlett Richard husbandman 616747 616747 Gimlett, Richard, of Trewen, husbandman 1
4322103 2137810 2137810 defendant Wooger John husbandman 616747 616747 Wooger, John, of Trewen, husbandman 2
4325570 2138926 2138926 defendant Reynoles John miller 616747 616747 Reynoles, John, of Trewen, miller 0
4463217 2189191 2189191 defendant Priour John   616747 616747 Priour, John, of Trewen 0
4768312 2286059 2286059 defendant Tregartha William husbandman 616747 616747 Tregartha, William, of Trewen, husbandman 1
4859468 2314336 2314336 defendant Pye John husbandman 616747 616747 Pye, John, of Trewen, husbandman 5
5008588 2359405 2359405 defendant Rayn Richard husbandman 616747 616747 together with Rayn, Richard, of Trewen, husbandman 1
5035123 2367136 2367136 defendant Rayn Richard husbandman 616747 616747 Rayn, Richard, of Trewen, husbandman 0
5295198 2443588 2443588 defendant Trewen Stephem husbandman 616747 616747 Trewen, Stephem, of Trewen, husbandman 3

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