names

21 rows where place_id = 688211

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4074659 2051241 2051241 plaintiff Reavys John   688211 688211 Reavys, John, of Maperton 0
4079290 2052895 2052895 plaintiff Travys John   688211 688211 Travys, John, of Maperton 0
4140350 2074792 2074792 defendant Dowche Christian miller 688211 688211 Dowche, Christian, of Maperton, miller 3
4173292 2086119 2086119 defendant Barnard Thomas husbandman 688211 688211 Barnard, Thomas, of Maperton, husbandman 1
4365869 2152829 2152829 defendant Crokett John husbandman 688211 688211 Crokett, John, of Maperton, husbandman 0
4452742 2185869 2185869 defendant Bromfeld Robert   688211 688211 Bromfeld, Robert, of Maperton 0
4452744 2185870 2185870 defendant Lysty John   688211 688211 Lysty, John, of Maperton 0
4551822 2216515 2216515 defendant Crokkeshale John   688211 688211 Crokkeshale, John, of Maperton 0
4570538 2222359 2222359 defendant Maperton Hilbrandus de   688211 688211 Maperton, Hilbrandus de, of Maperton 2
4660123 2249012 2249012 defendant Poyns John clerk 688211 688211 Poyns, John, of Maperton, clerk 0
4660125 2249013 2249013 defendant Poyns John clerk 688211 688211 Poyns, John, of Maperton, clerk 0
5053888 2372757 2372757 defendant Fabell Roger clerk 688211 688211 Fabell, Roger, of Maperton, clerk 0
5167309 2406171 2406171 defendant Smyth Robert husbandman 688211 688211 Smyth, Robert, of Maperton, husbandman 0
5182711 2410701 2410701 defendant Smyth Robert husbandman 688211 688211 Smyth, Robert, of Maperton, husbandman 0
5203544 2416789 2416789 defendant Smyth Robert husbandman 688211 688211 Smyth, Robert, of Maperton, husbandman 0
5380557 2469490 2469490 defendant Bukhorn William chaplain 688211 688211 Bukhorn, William, of Maperton, chaplain 2
5380630 2469508 2469508 defendant Bukhorn William chaplain 688211 688211 Bukhorn, William, of Maperton, chaplain 2
5383845 2470466 2470466 defendant Bukhorn William chaplain 688211 688211 Bukhorn, William, of Maperton, chaplain 2
5383852 2470467 2470467 defendant Bukhorn William chaplain 688211 688211 Bukhorn, William, of Maperton, chaplain 2
5462042 2493542 2493542 defendant Hawey John husbandman 688211 688211 Hawey, John, of Maperton, husbandman 1
5625242 2551834 2551834 defendant Dymmoge Stephen husbandman 688211 688211 Dymmoge, Stephen, of Maperton, husbandman 1

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