names

20 rows where place_id = 755824

✎ 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
4431657 2174668 2174668 defendant Underdyk Lambert   755824 755824 Underdyk, Lambert, of Fosdyk 2
4501732 2201142 2201142 defendant Welby Thomas   755824 755824 Welby, Thomas, of Fosdyk 0
4508309 2203085 2203085 defendant Welle William   755824 755824 Welle, William, of Fosdyk 3
4559460 2218907 2218907 defendant Welby Thomas de   755824 755824 Welby, Thomas de, of Fosdyk 0
4829247 2305187 2305187 defendant Welby Richard gent 755824 755824 Welby, Richard, of Fosdyk, gent 1
4843480 2309479 2309479 defendant Williamson Roger ostler 755824 755824 Williamson, Roger, of Fosdyk, ostler 0
4908826 2329311 2329311 defendant Welby Richard   755824 755824 Welby, Richard, of Fosdyk, gent, son & heir of Thomas Welby 0
4940234 2338975 2338975 defendant Wymer William husbandman 755824 755824 Wymer, William, of Fosdyk, husbandman 2
5220286 2421630 2421630 plaintiff Hunnyng Simon (legal representative) 755824 755824 Hunnyng, Simon, of Fosdyk, executors of 0
5228495 2423938 2423938 defendant Pulvertoft Robert gent 755824 755824 Pulvertoft, Robert, of Fosdyk, gent 1
5238739 2426923 2426923 defendant Slye John husbandman 755824 755824 (Slye, John, of Fosdyk, husbandman 3
5238740 2426923 2426923 defendant Pery John husbandman 755824 755824 Pery, John, of Fosdyk, husbandman 4
5238741 2426923 2426923 defendant Bailly Robert husbandman 755824 755824 Bailly, Robert, of Fosdyk, husbandman 5
5315930 2449839 2449839 defendant Hongate Thomas innholder 755824 755824 Hongate, Thomas, of Fosdyk, innholder 0
5495857 2503657 2503657 defendant Welby Thomas gent 755824 755824 Welby, Thomas, of Fosdyk, gent 0
5510594 2508151 2508151 defendant Welby Thomas gent 755824 755824 Welby, Thomas, of Fosdyk, gent 0
5588427 2531385 2531385 plaintiff Robertson Thomas merchant of the staple 755824 755824 Robertson, Thomas, of Fosdyk, merchant of the staple 1
5588430 2531386 2531386 plaintiff Robertson Thomas merchant of the staple 755824 755824 Robertson, Thomas, of Fosdyk, merchant of the staple 1
5628181 2552775 2552775 defendant Colynson Thomas husbandman 755824 755824 Colynson, Thomas, of Fosdyk, husbandman 1
5635411 2555040 2555040 plaintiff Welby Thomas   755824 755824 Welby, Thomas, of Fosdyk 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);