names

39 rows where place_id = 592353

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607445 1869986 1869986 defendant Person William husbandman 592353 592353 Person, William, of Roxton, husbandman 1
3761398 1945577 1945577 defendant Chylde Richard husbandman 592353 592353 Chylde, Richard, of Roxton, husbandman 0
3790502 1954851 1954851 defendant Gune John husbandman 592353 592353 Gune, John, of Roxton, husbandman 2
3865327 1978613 1978613 defendant Chylde Thomas husbandman 592353 592353 Chylde, Thomas, of Roxton, husbandman 0
3905494 1992108 1992108 defendant Chersham John butcher 592353 592353 Chersham, John, of Roxton, butcher 0
4044789 2040588 2040588 plaintiff Robynson John   592353 592353 Robynson, John, of Roxton 0
4074254 2051090 2051090 defendant Aglett Gilbert husbandman 592353 592353 Aglett, Gilbert, of Roxton, husbandman 1
4132731 2072031 2072031 defendant Urre Thomas gent 592353 592353 Urre, Thomas, of Roxton, gent 0
4150987 2078476 2078476 defendant Pope John (legal representative) 592353 592353 Pope, John, of Roxton, esq, administratrix of 0
4601307 2231645 2231645 defendant Scaryard John   592353 592353 Scaryard, John, of Roxton 2
4601308 2231645 2231645 defendant Sotyll John   592353 592353 Sotyll, John, of Roxton 3
4622304 2237955 2237955 defendant Golde Thomas   592353 592353 Golde, Thomas, of Roxton 1
4632477 2241047 2241047 defendant Sotill John   592353 592353 Sotill, John, of Roxton 3
4632479 2241047 2241047 defendant Fille John   592353 592353 Fille, John, of Roxton 5
4639995 2243203 2243203 defendant Austyn Philip   592353 592353 Austyn, Philip, of Roxton 1
4898641 2326221 2326221 defendant Wryght John miller 592353 592353 Wryght, John, of Roxton, miller 0
5085325 2382100 2382100 defendant Byrtvyle William gent 592353 592353 Byrtvyle, William, of Roxton, gent 3
5188027 2412207 2412207 defendant Childe John husbandman 592353 592353 Childe, John, of Roxton, husbandman 0
5188029 2412208 2412208 defendant Chylde John husbandman 592353 592353 Chylde, John, of Roxton, husbandman 0
5205840 2417443 2417443 defendant Chylde John husbandman 592353 592353 Chylde, John, of Roxton, husbandman 0
5287936 2441486 2441486 defendant Tukke William yeoman 592353 592353 Tukke, William, of Roxton, yeoman 2
5287937 2441486 2441486 defendant Petyr William smith 592353 592353 Petyr, William, of Roxton, smith 3
5287938 2441486 2441486 defendant Stokton Roger husbandman 592353 592353 Stokton, Roger, of Roxton, husbandman 4
5344831 2458545 2458545 defendant Child Richard husbandman 592353 592353 Child, Richard, of Roxton, husbandman 0
5353153 2461064 2461064 defendant Childe Richard maltman 592353 592353 Childe, Richard, of Roxton, maltman 0
5353155 2461064 2461064 defendant Phelip Thomas maltman 592353 592353 Phelip, Thomas, of Roxton, maltman 2
5353156 2461064 2461064 defendant Cokkoo William maltman 592353 592353 Cokkoo, William, of Roxton, maltman 3
5353158 2461064 2461064 defendant Richard Thomas yeoman 592353 592353 Richard, Thomas, of Roxton, yeoman 5
5353159 2461064 2461064 defendant Bruer Thomas yeoman or weaver 592353 592353 Bruer, Thomas, of Roxton, yeoman or weaver 6
5353161 2461064 2461064 defendant Felowe John, senior husbandman 592353 592353 Felowe, John, senior, of Roxton, husbandman 8
5353162 2461064 2461064 defendant Felowe John, junior husbandman 592353 592353 Felowe, John, junior, of Roxton, husbandman 9
5353163 2461064 2461064 defendant Sexten William husbandman 592353 592353 Sexten, William, of Roxton, husbandman 10
5353165 2461064 2461064 defendant Phelip George laborer 592353 592353 Phelip, George, of Roxton, laborer 12
5353166 2461064 2461064 defendant Stokker William husbandman 592353 592353 Stokker, William, of Roxton, husbandman 13
5353167 2461064 2461064 defendant Child Thomas husbandman 592353 592353 Child, Thomas, of Roxton, husbandman 14
5451995 2490479 2490479 defendant Cukke William yeoman 592353 592353 Cukke, William, of Roxton, yeoman 1
5463948 2494135 2494135 defendant Cukke William yeoman 592353 592353 Cukke, William, of Roxton, yeoman 1
5470706 2496159 2496159 defendant Chylde Richard husbandman 592353 592353 Chylde, Richard, of Roxton, husbandman 1
5475480 2497666 2497666 defendant Cukke William yeoman 592353 592353 Cukke, William, of Roxton, yeoman 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);