names

45 rows where place_id = 624750

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3760120 1945161 1945161 defendant Wyndell Henry husbandman 624750 624750 Wyndell, Henry, of Bysshop Norton, husbandman 1
3760121 1945161 1945161 defendant Hobson John husbandman 624750 624750 Hobson, John, of Bysshop Norton, husbandman 2
3760122 1945161 1945161 defendant Dalle John husbandman 624750 624750 Dalle, John, of Bysshop Norton, husbandman 3
3777490 1950711 1950711 plaintiff Coke John tanner 624750 624750 Coke, John, of Bysshop Norton, tanner 0
3833920 1968546 1968546 defendant Snarforthe John husbandman 624750 624750 Snarforthe, John, of Bysshop Norton, husbandman 1
3857952 1976131 1976131 defendant Wytton John husbandman 624750 624750 Wytton, John, of Bysshop Norton, husbandman 0
3866715 1979101 1979101 defendant Wytton John husbandman 624750 624750 Wytton, John, of Bysshop Norton, husbandman 0
3881180 1983973 1983973 defendant Coke John tanner 624750 624750 Coke, John,of Bysshop Norton, tanner 0
4499530 2200500 2200500 defendant Proktour John   624750 624750 Proktour, John, of Bysshop Norton 0
4600716 2231450 2231450 defendant Spycenall John   624750 624750 Spycenall, John, of Bysshop Norton 0
4640132 2243230 2243230 defendant Taillour John horse dealer 624750 624750 Taillour John, of Bysshop Norton, horse dealer 3
4750935 2280757 2280757 defendant Taillour alias Mason William husbandman 624750 624750 Taillour alias Mason, William, of Bysshop Norton, husbandman 1
4773002 2287528 2287528 defendant Magotum William husbandman 624750 624750 Magotum, William, of Bysshop Norton, husbandman 0
4831370 2305842 2305842 defendant Barden John yeoman 624750 624750 Barden, John, of Bysshop Norton, yeoman 0
4833737 2306561 2306561 defendant Magotson William husbandman 624750 624750 Magotson, William, of Bysshop Norton, husbandman 0
4862345 2315231 2315231 defendant Cokeswalde John   624750 624750 Cokeswalde, John, of Bysshop Norton, servant 0
4874259 2318894 2318894 defendant Mason William   624750 624750 Mason, William, of Bysshop Norton, bailiff 2
4909885 2329614 2329614 defendant Carter William husbandman 624750 624750 Carter, William, of Bysshop Norton, husbandman 2
4916826 2331767 2331767 defendant Mason William   624750 624750 Mason, William, of Bysshop Norton, bailiff 1
4940996 2339205 2339205 defendant Mason William laborer 624750 624750 Mason, William, of Bysshop Norton, laborer 5
4942322 2339586 2339586 defendant Mason William   624750 624750 Mason, William, of Bysshop Norton, bailiff 3
4948024 2341364 2341364 defendant Mason William   624750 624750 Mason, William, of Bysshop Norton, bailiff 0
4948044 2341367 2341367 defendant Mason William   624750 624750 Mason, William, of Bysshop Norton, bailiff 0
4961996 2345546 2345546 defendant Mason William yeoman 624750 624750 Mason, William, of Bysshop Norton, yeoman 0
4961997 2345546 2345546 defendant Burnand Robert   624750 624750 Burnand, Robert, of Bysshop Norton, wright 1
4967960 2347358 2347358 defendant Mason William   624750 624750 Mason, William, of Bysshop Norton, bailiff 3
4989394 2353763 2353763 defendant Taillour John tailor 624750 624750 Taillour, John, of Bysshop Norton, tailor 0
4990486 2354062 2354062 defendant Mauby John gent 624750 624750 Mauby, John, of Bysshop Norton, gent 0
5090670 2383656 2383656 defendant Mason William husbandman 624750 624750 Mason, William, of Bysshop Norton, husbandman 0
5115033 2390814 2390814 defendant Mason William husbandman 624750 624750 Mason, William, of Bysshop Norton, husbandman 0
5120195 2392347 2392347 defendant Smyth William husbandman 624750 624750 Smyth, William, of Bysshop Norton, husbandman 1
5127544 2394536 2394536 defendant Waryngton Henry husbandman 624750 624750 Waryngton, Henry, of Bysshop Norton, husbandman 1
5127545 2394536 2394536 defendant Tayllour John husbandman 624750 624750 Tayllour, John, of Bysshop Norton, husbandman 2
5139614 2398064 2398064 defendant Davy Henry husbandman 624750 624750 Davy, Henry, of Bysshop Norton, husbandman 3
5139620 2398065 2398065 defendant Davy Henry husbandman 624750 624750 Davy, Henry, of Bysshop Norton, husbandman 3
5146448 2400092 2400092 defendant Waryngton Henry husbandman 624750 624750 Waryngton, Henry, of Bysshop Norton, husbandman 1
5146449 2400092 2400092 defendant Taillour John husbandman 624750 624750 Taillour, John, of Bysshop Norton, husbandman 2
5155739 2402840 2402840 defendant Mason William husbandman 624750 624750 Mason, William, of Bysshop Norton, husbandman 0
5159590 2403921 2403921 defendant Mason William yeoman 624750 624750 Mason, William, of Bysshop Norton, yeoman 0
5191486 2413252 2413252 defendant Mason William husbandman 624750 624750 Mason, William, of Bysshop Norton, husbandman 0
5283941 2440331 2440331 defendant Tayllour Robert husbandman 624750 624750 Tayllour, Robert, of Bysshop Norton, husbandman 11
5297974 2444419 2444419 defendant Mason John husbandman 624750 624750 Mason, John, of Bysshop Norton, husbandman 1
5297975 2444419 2444419 defendant Wadyngton Henry husbandman 624750 624750 Wadyngton, Henry, of Bysshop Norton, husbandman 2
5628464 2552872 2552872 defendant Douve John yeoman 624750 624750 Douve, John, of Bysshop Norton, yeoman 0
5631322 2553797 2553797 defendant Magotson John courser 624750 624750 Magotson, John, of Bysshop Norton, courser 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);