names

26 rows where place_id = 615261

✎ 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
3707971 1928788 1928788 plaintiff Milford Lawrence yeoman 615261 615261 Milford, Lawrence, of Bardeney, yeoman 0
3707977 1928789 1928789 plaintiff Milford Lawrence yeoman 615261 615261 Milford, Lawrence, of Bardeney, yeoman 0
3707980 1928790 1928790 plaintiff Milford Lawrence yeoman 615261 615261 Milford, Lawrence, of Bardeney, yeoman 0
3722530 1933307 1933307 plaintiff Mikford Lawrence   615261 615261 Mikford, Lawrence, of Bardeney 0
3738264 1938182 1938182 plaintiff Milford Lawrence yeoman 615261 615261 Milford, Lawrence, of Bardeney, yeoman 0
3920726 1997279 1997279 defendant Laneham Clemence widow 615261 615261 Laneham, Clemence, of Bardeney, widow 0
3920727 1997279 1997279 defendant Lee William clerk 615261 615261 Lee, William, of Bardeney, clerk 1
4648196 2245537 2245537 defendant Phippe Thomas   615261 615261 Phippe, Thomas, of Bardeney 1
4728833 2274256 2274256 defendant Warde Thomas husbandman 615261 615261 Warde, Thomas, of Bardeney, husbandman 2
4746821 2279571 2279571 defendant Warde Thomas husbandman 615261 615261 Warde, Thomas, of Bardeney, husbandman 0
4968582 2347568 2347568 plaintiff Gayton John woolman 615261 615261 Gayton, John, of Bardeney, woolman 0
5053436 2372632 2372632 defendant Erle Robert laborer 615261 615261 Erle, Robert, of Bardeney, laborer 0
5053437 2372632 2372632 defendant Keleby John laborer 615261 615261 Keleby, John, of Bardeney, laborer 1
5076955 2379604 2379604 defendant Borell John laborer 615261 615261 Borell, John, of Bardeney, laborer 0
5101701 2386918 2386918 defendant Kelyng John husbandman 615261 615261 Kelyng, John, of Bardeney, husbandman 0
5192525 2413547 2413547 defendant Mavonson Robert laborer 615261 615261 Mavonson, Robert, of Bardeney, laborer 0
5207753 2418007 2418007 defendant Mabonson Robert laborer 615261 615261 Mabonson, Robert, of Bardeney, laborer 0
5230423 2424513 2424513 defendant Kelyng John husbandman 615261 615261 Kelyng, John, of Bardeney, husbandman 0
5230424 2424513 2424513 defendant Barker John shoemaker 615261 615261 Barker, John, of Bardeney, shoemaker 1
5230426 2424514 2424514 defendant Gare John tailor 615261 615261 Gare, John, of Bardeney, tailor 0
5233140 2425280 2425280 defendant Ledale John laborer 615261 615261 Ledale, John, of Bardeney, laborer 1
5256298 2432091 2432091 defendant Bardeney Robert husbandman 615261 615261 Bardeney, Robert, of Bardeney, husbandman 1
5311010 2448330 2448330 defendant Horncastell Richard   615261 615261 Horncastell, Richard, of Bardeney, abbot of the monastery of the BM 0
5349583 2460004 2460004 defendant Jolyffe John husbandman 615261 615261 Jolyffe, John, of Bardeney, husbandman 0
5527623 2513216 2513216 defendant Thorp Robert laborer 615261 615261 Thorp, Robert, of Bardeney, laborer 0
5564409 2524207 2524207 defendant Sewall John barber 615261 615261 Sewall, John, of Bardeney, barber 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);