names

33 rows where place_id = 599033

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634925 1905724 1905724 defendant Cokschote Christopher yeoman 599033 599033 Cokschote, Christopher, of Laxton, Notts, yeoman 0
3846779 1972544 1972544 defendant Roos Humphrey   599033 599033 Roos, Humphrey, of Laxton, Notts, gent, son of Roos, Humphrey, of Laxton 0
3846784 1972545 1972545 defendant Roos Humphrey (legal representative) 599033 599033 Roos, Humphrey, of Laxton, Notts, administratrix of 0
3962612 2011515 2011515 defendant Nevell George gent 599033 599033 Nevell, George, of Laxton, Notts, gent 0
3986663 2019970 2019970 defendant Nevyll George esq 599033 599033 Nevyll, George, of Laxton, Notts, esq 0
4121885 2068125 2068125 defendant Roos Peter esq 599033 599033 Roos, Peter, of Laxton, Notts, esq 0
4157547 2080713 2080713 defendant Roos Peter esq 599033 599033 Roos, Peter, of Laxton, Notts, esq 1
4166147 2083665 2083665 defendant Parthorpe John   599033 599033 Parthorpe, John, of Laxton, Notts, tallow chandler 0
4341202 2144193 2144193 defendant Roos Peter esq 599033 599033 Roos, Peter, of Laxton, Notts, esq 0
4694588 2263803 2263803 defendant Bekeryng Thomas gent 599033 599033 Bekeryng, Thomas, of Laxton, Notts, gent 1
4849979 2311463 2311463 defendant Etton Al_   599033 599033 Etton, Al_, of Laxton, Notts, parson 3
4988512 2353522 2353522 defendant Roos John esq 599033 599033 together with Roos, John, of Laxton, Notts, esq 12
4988518 2353523 2353523 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
4995479 2355488 2355488 defendant Roos John esq 599033 599033 together with Roos, John, of Laxton, Notts, esq 12
4995485 2355489 2355489 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5002417 2357616 2357616 defendant Ecton Alexander clerk 599033 599033 Ecton, Alexander, of Laxton, Notts, clerk 0
5005506 2358511 2358511 defendant Roos John esq 599033 599033 together with Roos, John, of Laxton, Notts, esq 12
5005517 2358514 2358514 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5028241 2365135 2365135 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5056074 2373389 2373389 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5060041 2374567 2374567 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5066305 2376449 2376449 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5079189 2380266 2380266 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5082359 2381220 2381220 defendant Roos John esq 599033 599033 Roos, John, of Laxton, Notts, esq 0
5140610 2398362 2398362 defendant Roos Richard   599033 599033 Roos, Richard, of Laxton, Notts 4
5161735 2404534 2404534 defendant Roos Richard gent 599033 599033 Roos, Richard, of Laxton, Notts, gent 4
5231713 2424844 2424844 defendant Roos Robert esq 599033 599033 Roos, Robert, of Laxton, Notts, esq 4
5322137 2451692 2451692 defendant Roos Robert esq 599033 599033 Roos, Robert, of Laxton, Notts, esq 0
5323966 2452254 2452254 defendant Roos Robert esq 599033 599033 Roos, Robert, of Laxton, Notts, esq 0
5389901 2472175 2472175 defendant Mason Robert yeoman 599033 599033 Mason, Robert, of Laxton, Notts, yeoman 1
5402699 2475847 2475847 defendant Taylor John husbandman 599033 599033 Taylor, John, of Laxton, Notts, husbandman 0
5536304 2515844 2515844 defendant Plommer Richard yeoman 599033 599033 Plommer, Richard, of Laxton, Notts, yeoman 0
5572344 2526465 2526465 defendant Rosse William gent 599033 599033 Rosse, William, of Laxton, Notts, gent 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);