names

35 rows where place_id = 586890

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589907 1864483 1864483 defendant Grene Richard esq 586890 586890 Grene, Richard, of Neweby, esq 1
3589910 1864484 1864484 defendant Grene Richard esq 586890 586890 Grene, Richard, of Neweby, esq 1
3604441 1869058 1869058 plaintiff Grene Richard esq 586890 586890 Grene, Richard, of Neweby, esq 0
3988053 2020473 2020473 defendant Lamburn John gent 586890 586890 Lamburn, John, of Neweby, gent 0
4613226 2235177 2235177 defendant Moyses Robert   586890 586890 Moyses, Robert, of Neweby 3
4613231 2235178 2235178 defendant Moyses Robert   586890 586890 Moyses, Robert, of Neweby 3
4632449 2241039 2241039 defendant Robynson William   586890 586890 Robynson, William, of Neweby 0
4679042 2259054 2259054 defendant Harper Thomas   586890 586890 Harper, Thomas, of Neweby yeoman 0
4733231 2275574 2275574 defendant Sawedan Thomas husbandman 586890 586890 Sawedan, Thomas, of Neweby, husbandman 0
4733232 2275574 2275574 defendant Harryson William husbandman 586890 586890 Harryson, William, of Neweby, husbandman 1
4733234 2275574 2275574 defendant Danby Thomas husbandman 586890 586890 Danby, Thomas, of Neweby, husbandman 3
4733237 2275574 2275574 defendant Wantesforth Richard husbandman 586890 586890 Wantesforth, Richard, of Neweby, husbandman 6
4733238 2275574 2275574 defendant Wantesforth Robert husbandman 586890 586890 Wantesforth, Robert, of Neweby, husbandman 7
4795327 2294690 2294690 defendant Warde William   586890 586890 Warde, William, of Neweby, franklin 0
4799226 2295937 2295937 defendant Meires Robert husbandman 586890 586890 Meires, Robert, of Neweby, husbandman 3
4807277 2298476 2298476 defendant Bakhous John husbandman 586890 586890 Bakhous, John, of Neweby, husbandman 2
4815221 2300873 2300873 defendant Couper John cooper 586890 586890 Couper, John, of Neweby, cooper 1
4821599 2302838 2302838 defendant Smyth John husbandman 586890 586890 Smyth, John, of Neweby, husbandman 0
4822796 2303211 2303211 defendant Smyth Thomas   586890 586890 Smyth, Thomas, of Neweby yeoman 4
4827762 2304730 2304730 defendant Neweby Robert de gent 586890 586890 Neweby, Robert de, of Neweby, gent 0
4928863 2335448 2335448 defendant Nicholason Thomas yeoman 586890 586890 Nicholason, Thomas, of Neweby, yeoman 0
4928864 2335448 2335448 defendant Bryham John yeoman 586890 586890 Bryham, John, of Neweby, yeoman 1
4928865 2335448 2335448 defendant Bakhous John yeoman 586890 586890 Bakhous, John, of Neweby, yeoman 2
4928866 2335448 2335448 defendant Robynson Richard yeoman 586890 586890 Robynson, Richard, of Neweby, yeoman 3
4948364 2341471 2341471 defendant Robynson Richard yeoman 586890 586890 Robynson, Richard, of Neweby, yeoman 0
4965286 2346543 2346543 defendant Wad John husbandman 586890 586890 Wad, John, of Neweby, husbandman 0
4965287 2346543 2346543 defendant Wad William husbandman 586890 586890 Wad, William, of Neweby, husbandman 1
5018385 2362262 2362262 defendant Solbergh Thomas husbandman 586890 586890 Solbergh, Thomas, of Neweby, husbandman 8
5069857 2377479 2377479 defendant Herryson Richard husbandman 586890 586890 Herryson, Richard, of Neweby, husbandman 0
5069858 2377479 2377479 defendant Stevenson John husbandman 586890 586890 Stevenson, John, of Neweby, husbandman 1
5318543 2450644 2450644 defendant Proctour Mathew husbandman 586890 586890 Proctour, Mathew, of Neweby, husbandman 2
5494919 2503378 2503378 plaintiff Grene Richard gent 586890 586890 Grene, Richard, of Neweby, gent 0
5498114 2504380 2504380 defendant Manchill Robert gent 586890 586890 Manchill, Robert, of Neweby, gent 0
5539663 2516885 2516885 plaintiff Grene Robert gent 586890 586890 Grene, Robert, of Neweby, gent 0
5584017 2530072 2530072 plaintiff Grene Richard   586890 586890 Grene, Richard, of Neweby, gent, administrators of 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);