names

23 rows where place_id = 637650

✎ 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
3837719 1969710 1969710 defendant Nevyll John clerk 637650 637650 Nevyll, John, of Halywell, clerk 0
4429371 2173992 2173992 plaintiff Vescy Robert   637650 637650 Vescy, Robert, of Halywell 0
4489850 2197533 2197533 defendant Potter Thomas   637650 637650 Potter, Thomas, of Halywell 0
4499155 2200381 2200381 plaintiff Griffyn Edith   637650 637650 Griffyn, Edith, of Halywell, prioress 0
4586787 2227265 2227265 plaintiff Hoggeson Robert   637650 637650 Hoggeson, Robert, of Halywell 0
4657262 2248160 2248160 plaintiff Clerk Robert   637650 637650 Clerk, Robert, of Halywell 0
4802609 2297002 2297002 plaintiff (not given) Elizabeth prioress of Arundel 637650 637650 Arundel, Elizabeth, of Halywell, prioress of the house of St. John Baptist 0
4808751 2298904 2298904 plaintiff (not given) Elizabeth prioress of Darundell 637650 637650 Darundell, Elizabeth, of Halywell, prioress of St John Baptist priory 0
4852698 2312265 2312265 defendant Bocher Stephen laborer 637650 637650 Bocher, Stephen, of Halywell, laborer 0
5031426 2366048 2366048 defendant Kyng John husbandman 637650 637650 Kyng, John, of Halywell, husbandman 0
5031427 2366048 2366048 defendant Bryon William husbandman 637650 637650 Bryon, William, of Halywell, husbandman 1
5165132 2405547 2405547 defendant Croke John husbandman 637650 637650 Croke, John, of Halywell, husbandman 0
5178825 2409531 2409531 defendant Croke John husbandman 637650 637650 Croke, John, of Halywell, husbandman 0
5178827 2409532 2409532 defendant Croke John husbandman 637650 637650 Croke, John, of Halywell, husbandman 0
5178829 2409533 2409533 defendant Croke John husbandman 637650 637650 Croke, John, of Halywell, husbandman 0
5178831 2409534 2409534 defendant Croke John husbandman 637650 637650 Croke, John, of Halywell, husbandman 0
5476276 2497912 2497912 defendant (not given) Elizabeth prioress of Prudde 637650 637650 Prudde, Elizabeth, of Halywell, prioress of St John Baptist 0
5476280 2497913 2497913 defendant (not given) Elizabeth prioress of Prudde 637650 637650 Prudde, Elizabeth, of Halywell, prioress of St John Baptist 0
5563230 2523844 2523844 defendant Kyng John, junior fisher 637650 637650 Kyng, John, junior, of Halywell, fisher 1
5563231 2523844 2523844 defendant Kyng Simon fisher 637650 637650 Kyng, Simon, of Halywell, fisher 2
5563245 2523846 2523846 defendant Kyng John, junior fisher 637650 637650 Kyng, John, junior, of Halywell, fisher 2
5563246 2523846 2523846 defendant Kyng Simon fisher 637650 637650 Kyng, Simon, of Halywell, fisher 3
5575499 2527429 2527429 defendant Smyth Walter husbandman 637650 637650 Smyth, Walter, of Halywell, husbandman 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);