names

19 rows where place_id = 600323

✎ 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
3640594 1907499 1907499 defendant Beilby Robert husbandman 600323 600323 Beilby, Robert, of Ellerton, husbandman 2
3640595 1907499 1907499 defendant Broune John husbandman 600323 600323 Broune, John, of Ellerton, husbandman 3
3686277 1921861 1921861 defendant Broun Joan widow 600323 600323 Broun, Joan, of Ellerton, widow 0
3803627 1959048 1959048 defendant Peerson Richard glover 600323 600323 Peerson, Richard, of Ellerton, glover 0
3988680 2020693 2020693 defendant Blancher Richard yeoman 600323 600323 Blancher, Richard, of Ellerton, yeoman 0
3990348 2021302 2021302 plaintiff Bethell Hugh gent 600323 600323 Bethell, Hugh, of Ellerton, gent 0
4067396 2048645 2048645 defendant Metcalf Edmund yeoman 600323 600323 Metcalf, Edmund, of Ellerton, yeoman 0
4217426 2101588 2101588 defendant Bethell Hugh esq 600323 600323 Bethell, Hugh, of Ellerton, esq 1
4254076 2114362 2114362 defendant Bethell Hugh esq 600323 600323 Bethell, Hugh, of Ellerton, esq 1
4546647 2214876 2214876 defendant Raper John   600323 600323 Raper, John, of Ellerton 2
4564845 2220570 2220570 defendant Walker John   600323 600323 Walker, John, of Ellerton 5
4751005 2280774 2280774 defendant Pennar William yeoman 600323 600323 Pennar, William, of Ellerton, yeoman 0
4810776 2299495 2299495 plaintiff Flesshewer Thomas   600323 600323 Flesshewer, Thomas, of Ellerton 0
4995181 2355410 2355410 defendant Bullyngton John   600323 600323 Bullyngton, John, of Ellerton, prior 0
5145765 2399903 2399903 defendant Kelyngton Ralph yeoman 600323 600323 Kelyngton, Ralph, of Ellerton, yeoman 0
5145770 2399903 2399903 defendant Stowete Richard tanner 600323 600323 Stowete, Richard, of Ellerton, tanner 5
5166105 2405826 2405826 defendant Kelyngton Ralph yeoman 600323 600323 Kelyngton, Ralph, of Ellerton, yeoman 0
5166111 2405826 2405826 defendant Stowte Richard tanner 600323 600323 Stowte, Richard, of Ellerton, tanner 6
5177842 2409221 2409221 defendant Shipley William yeoman 600323 600323 Shipley, William, of Ellerton, yeoman 5

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