names

21 rows where case_id = 2404770

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5162533 2404770 2404770 plaintiff Vampage John, sen     Vampage, John, sen 0
5162534 2404770 2404770 defendant Wollashill Edmund     Wollashill, Edmund 0
5162535 2404770 2404770 defendant Ledyn Richard     Ledyn, Richard 1
5162536 2404770 2404770 defendant Dobbys John     Dobbys, John 2
5162537 2404770 2404770 defendant Maynard Robert     Maynard, Robert 3
5162538 2404770 2404770 defendant Jenkyns Robert     Jenkyns, Robert 4
5162539 2404770 2404770 defendant Jenkyns William     Jenkyns, William 5
5162540 2404770 2404770 defendant all of Great Comberton   husbandman   all of Great Comberton, husbandman 6
5162541 2404770 2404770 defendant Mason Robert mason   Mason, Robert, mason 7
5162542 2404770 2404770 defendant Cornewayle William clerk   Cornewayle, William, clerk 8
5162543 2404770 2404770 defendant Haukyns Thomas clerk 604163 604163 Haukyns, Thomas, of Ekyngton, clerk 9
5162544 2404770 2404770 defendant Walker Robert husbandman 586204 586204 Walker, Robert, of Bengeworth, husbandman 10
5162545 2404770 2404770 defendant Stacy John husbandman 585945 585945 Stacy, John, of Pershore, husbandman 11
5162546 2404770 2404770 defendant Stacy Thomas butcher 585945 585945 Stacy, Thomas, of Pershore, butcher 12
5162547 2404770 2404770 defendant Pollard Simon husbandman 797197 797197 Pollard, Simon, of Great Comberton, husbandman 13
5162548 2404770 2404770 defendant George Thomas husbandman 852200 852200 George, Thomas, of Norton by Bredon, husbandman 14
5162549 2404770 2404770 defendant Toune Ralph husbandman 604163 604163 Toune, Ralph, of Ekyngton, husbandman 15
5162550 2404770 2404770 defendant Baker Ralph butcher 854903 854903 Baker, Ralph, of Persyore, butcher 16
5162551 2404770 2404770 defendant Wynslowe Richard husbandman 592644 592644 Wynslowe, Richard, of Erles Crombe, husbandman 17
5162552 2404770 2404770 defendant Fulwell John husbandman 758057 758057 Fulwell, John, of Wyke by Pershore, husbandman 18
5162553 2404770 2404770 defendant Smyth Thomas husbandman 797197 797197 Smyth, Thomas, of Great Comberton, husbandman 19

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