names

33 rows where place_id = 589768

✎ 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
3598679 1867212 1867212 defendant Havyn or Hanyn William husbandman 589768 589768 Havyn or Hanyn, William, of Wrytell, husbandman 0
3598680 1867212 1867212 defendant Havyn or Hanyn Thomas husbandman 589768 589768 Havyn or Hanyn, Thomas, of Wrytell, husbandman 1
3598684 1867213 1867213 defendant Havyn William husbandman 589768 589768 Havyn, William, of Wrytell, husbandman 1
3598685 1867213 1867213 defendant Havyn Thomas husbandman 589768 589768 Havyn, Thomas, of Wrytell, husbandman 2
3663089 1914365 1914365 defendant Woode John   589768 589768 Woode, John, of Wrytell 0
3711906 1930040 1930040 defendant Grenehurste Richard yeoman 589768 589768 Grenehurste, Richard, of Wrytell, yeoman 0
3749906 1941886 1941886 defendant Wode John yeoman 589768 589768 Wode, John, of Wrytell, yeoman 1
3749910 1941887 1941887 defendant Wode John yeoman 589768 589768 Wode, John, of Wrytell, yeoman 1
3834295 1968670 1968670 defendant Palmer Robert husbandman 589768 589768 Palmer, Robert, of Wrytell, husbandman 0
3886796 1985845 1985845 defendant Couche John laborer 589768 589768 Couche, John, of Wrytell, laborer 1
4784878 2291278 2291278 defendant Trot John glover 589768 589768 Trot, John, of Wrytell, glover 2
4797963 2295546 2295546 defendant Yonge John husbandman 589768 589768 Yonge, John, of Wrytell, husbandman 1
4814357 2300599 2300599 defendant Swetyng John husbandman 589768 589768 Swetyng, John, of Wrytell, husbandman 3
4937755 2338188 2338188 defendant Bysshop John husbandman 589768 589768 Bysshop, John, of Wrytell, husbandman 1
4961167 2345303 2345303 defendant Eld Thomas yeoman 589768 589768 Eld, Thomas, of Wrytell, yeoman 1
5038105 2368030 2368030 defendant Bedyll William husbandman 589768 589768 Bedyll, William, of Wrytell, husbandman 0
5039238 2368378 2368378 plaintiff Bedell William   589768 589768 Bedell, William, of Wrytell 0
5039244 2368379 2368379 plaintiff Bedell William   589768 589768 Bedell, William, of Wrytell 0
5104908 2387870 2387870 defendant Pece Robert husbandman 589768 589768 Pece, Robert, of Wrytell, husbandman 1
5125794 2394030 2394030 defendant Chastlyon Roger yeoman 589768 589768 Chastlyon, Roger, of Wrytell, yeoman 0
5125795 2394030 2394030 defendant Brook Thomas miller 589768 589768 Brook, Thomas, of Wrytell, miller 1
5125796 2394030 2394030 defendant Stones John clerk 589768 589768 Stones, John, of Wrytell, clerk 2
5144407 2399523 2399523 defendant Chastlyon Roger yeoman 589768 589768 Chastlyon, Roger, of Wrytell, yeoman 0
5144408 2399523 2399523 defendant Brook Thomas miller 589768 589768 Brook, Thomas, of Wrytell, miller 1
5220387 2421659 2421659 defendant Hervy John dyer 589768 589768 Hervy, John, of Wrytell, dyer 1
5273271 2437250 2437250 defendant Bode John husbandman 589768 589768 Bode, John, of Wrytell, husbandman 1
5352578 2460903 2460903 defendant Gryme John husbandman 589768 589768 Gryme, John, of Wrytell, husbandman 0
5352583 2460904 2460904 defendant Gryme John husbandman 589768 589768 Gryme, John, of Wrytell, husbandman 0
5392841 2473026 2473026 plaintiff Skypwyth Nicholas clerk 589768 589768 Skypwyth, Nicholas, of Wrytell, clerk 0
5501824 2505496 2505496 defendant Attewode William chapman 589768 589768 Attewode, William, of Wrytell, chapman 0
5516116 2509889 2509889 defendant Attewode William husbandman 589768 589768 Attewode, William, of Wrytell, husbandman 3
5516208 2509904 2509904 defendant Atte Wode William husbandman 589768 589768 Atte Wode, William, of Wrytell, husbandman 3
5608757 2537639 2537639 plaintiff Forster William gent 589768 589768 Forster, William, of Wrytell, gent 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);