names

31 rows where place_id = 758623

✎ 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
4455517 2186731 2186731 defendant Taillour William   758623 758623 Taillour, William, of Dunsterre 0
4462487 2188961 2188961 plaintiff Taillour William   758623 758623 Taillour, William, of Dunsterre 0
4462489 2188962 2188962 plaintiff Taillour William   758623 758623 Taillour, William, of Dunsterre 0
4462491 2188963 2188963 plaintiff Taillour William   758623 758623 Taillour, William, of Dunsterre 0
4462493 2188964 2188964 plaintiff Taillour William   758623 758623 Taillour, William, of Dunsterre 0
4462495 2188965 2188965 plaintiff Taillour William   758623 758623 Taillour, William, of Dunsterre 0
4463301 2189215 2189215 defendant Melow John   758623 758623 Melow, John, of Dunsterre 0
4496233 2199496 2199496 defendant Mareys John   758623 758623 Mareys, John, of Dunsterre 0
4508522 2203140 2203140 defendant Mohun Joan   758623 758623 Mohun, Joan, of Dunsterre 0
4517788 2205956 2205956 defendant Sterre John   758623 758623 Sterre, John, of Dunsterre 5
4536672 2211748 2211748 defendant Trote Walter   758623 758623 Trote, Walter, of Dunsterre 4
4552195 2216640 2216640 defendant Sterre Thomas   758623 758623 Sterre, Thomas, of Dunsterre 1
4658266 2248466 2248466 defendant Stamforde John ostler 758623 758623 Stamforde, John, of Dunsterre, ostler 0
4858709 2314097 2314097 defendant Blakwylle John laborer 758623 758623 Blakwylle, John, of Dunsterre, laborer 0
4894594 2324980 2324980 defendant Chapman Thomas husbandman 758623 758623 Chapman, Thomas, of Dunsterre, husbandman 0
5282715 2440006 2440006 defendant Cokkes John yeoman 758623 758623 Cokkes, John, of Dunsterre, yeoman 3
5282716 2440006 2440006 defendant Hilton John brewer 758623 758623 Hilton, John, of Dunsterre, brewer 4
5282717 2440006 2440006 defendant Symons John yeoman 758623 758623 Symons, John, of Dunsterre, yeoman 5
5282718 2440006 2440006 defendant Adam Joan widow 758623 758623 Adam, Joan, of Dunsterre, widow 6
5287411 2441341 2441341 defendant Pyement William chaplain 758623 758623 Pyement, William, of Dunsterre, chaplain 0
5287412 2441341 2441341 defendant Davy Hugh yeoman 758623 758623 Davy, Hugh, of Dunsterre, yeoman 1
5610432 2546979 2546979 defendant Lombe John   758623 758623 Lombe, John, of Dunsterre 0
5612444 2547640 2547640 plaintiff Carter Thomas   758623 758623 Carter, Thomas, of Dunsterre 0
5612449 2547642 2547642 plaintiff Cartere Thomas   758623 758623 Cartere, Thomas, of Dunsterre 0
5612451 2547643 2547643 plaintiff Cartere Thomas   758623 758623 Cartere, Thomas, of Dunsterre 0
5612712 2547724 2547724 plaintiff Chepman John   758623 758623 Chepman, John, of Dunsterre 0
5612778 2547750 2547750 plaintiff Chopman John   758623 758623 Chopman, John, of Dunsterre 0
5612779 2547750 2547750 defendant Elys Henry   758623 758623 Elys, Henry, of Dunsterre 0
5621718 2550699 2550699 plaintiff Taillour William   758623 758623 Taillour, William, of Dunsterre 0
5630328 2553492 2553492 defendant Traventer Thomas fisher 758623 758623 Traventer, Thomas, of Dunsterre, fisher 0
5637050 2555537 2555537 defendant Stamford John   758623 758623 Stamford, John, of Dunsterre 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);