names

58 rows where place_id = 586201

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588152 1863945 1863945 defendant Fuller John butcher 586201 586201 Fuller, John, of Spryngfeld, butcher 2
3613075 1871740 1871740 plaintiff Artour Richard   586201 586201 Artour, Richard, of Spryngfeld 0
3615748 1872566 1872566 defendant Sandyche John husbandman 586201 586201 Sandyche, John, of Spryngfeld, husbandman 1
3615772 1872575 1872575 defendant Osburn John, senior husbandman 586201 586201 Osburn, John, senior, of Spryngfeld, husbandman 0
3627323 1903395 1903395 defendant Sexwekys William draper 586201 586201 Sexwekys, William, of Spryngfeld, draper 0
3662636 1914232 1914232 defendant Pynchyn William laborer 586201 586201 Pynchyn, William, of Spryngfeld, laborer 1
3673974 1917898 1917898 defendant Coke John yeoman 586201 586201 Coke, John, of Spryngfeld, yeoman 3
3684048 1921145 1921145 defendant Gylder John husbandman 586201 586201 Gylder, John, of Spryngfeld, husbandman 2
3753009 1942874 1942874 defendant Pese Richard husbandman 586201 586201 Pese, Richard, of Spryngfeld, husbandman 1
3843520 1971511 1971511 defendant Carre Margeret widow 586201 586201 Carre, Margeret, of Spryngfeld, widow 0
3877035 1982560 1982560 defendant Pese Richard, junior husbandman 586201 586201 Pese, Richard, junior, of Spryngfeld, husbandman 0
3908932 1993281 1993281 defendant Eton Robert yeoman 586201 586201 Eton, Robert, of Spryngfeld, yeoman 0
3914836 1995308 1995308 defendant Crenche Thomas laborer 586201 586201 Crenche, Thomas, of Spryngfeld, laborer 1
4472639 2192109 2192109 plaintiff Colvyle Geoffrey   586201 586201 Colvyle, Geoffrey, of Spryngfeld 0
4545707 2214584 2214584 defendant Duk Guy   586201 586201 Duk, Guy, of Spryngfeld 0
4545709 2214585 2214585 defendant Duk Guy   586201 586201 Duk, Guy, of Spryngfeld 0
4554228 2217250 2217250 plaintiff Grayland Amice   586201 586201 Grayland, Amice, of Spryngfeld 0
4595322 2229789 2229789 defendant Tredegolde John   586201 586201 Tredegolde, John, of Spryngfeld 2
4655856 2247709 2247709 defendant Lyon John husbandman 586201 586201 Lyon, John, of Spryngfeld, husbandman 1
4655857 2247709 2247709 defendant Gardyn John husbandman 586201 586201 Gardyn, John, of Spryngfeld, husbandman 2
4655858 2247709 2247709 defendant Sawen John husbandman 586201 586201 Sawen, John, of Spryngfeld, husbandman 3
4655859 2247709 2247709 defendant Pese John husbandman 586201 586201 Pese, John, of Spryngfeld, husbandman 4
4655860 2247709 2247709 defendant Bisshop John husbandman 586201 586201 Bisshop, John, of Spryngfeld, husbandman 5
4655884 2247718 2247718 defendant Lyon John husbandman 586201 586201 Lyon, John, of Spryngfeld, husbandman 1
4655885 2247718 2247718 defendant Gardyn John husbandman 586201 586201 Gardyn, John, of Spryngfeld, husbandman 2
4655886 2247718 2247718 defendant Sawen John husbandman 586201 586201 Sawen, John, of Spryngfeld, husbandman 3
4655887 2247718 2247718 defendant Pese John husbandman 586201 586201 Pese, John, of Spryngfeld, husbandman 4
4655888 2247718 2247718 defendant Bisshop John husbandman 586201 586201 Bisshop, John, of Spryngfeld, husbandman 5
4669210 2256075 2256075 defendant Ardele John yeoman 586201 586201 Ardele, John, of Spryngfeld, yeoman 0
4669211 2256075 2256075 defendant Kent John yeoman 586201 586201 Kent, John, of Spryngfeld, yeoman 1
4694393 2263745 2263745 defendant Ardele John yeoman 586201 586201 Ardele, John, of Spryngfeld, yeoman 0
4772584 2287395 2287395 defendant Wylle Richard tailor 586201 586201 Wylle, Richard, of Spryngfeld, tailor 0
4784888 2291281 2291281 defendant Hervy John fuller 586201 586201 Hervy, John, of Spryngfeld, fuller 2
4795584 2294771 2294771 defendant Beneyt Thomas yeoman 586201 586201 Beneyt, Thomas, of Spryngfeld, yeoman 0
4796416 2295032 2295032 defendant Rote Geoffrey farmer 586201 586201 Rote, Geoffrey, of Spryngfeld, farmer 0
4810270 2299357 2299357 defendant Roote Geoffrey husbandman 586201 586201 Roote, Geoffrey, of Spryngfeld, husbandman 1
4831769 2305956 2305956 defendant Bysshop John husbandman 586201 586201 Bysshop, John, of Spryngfeld, husbandman 0
4840120 2308458 2308458 plaintiff Heyward William   586201 586201 Heyward, William, of Spryngfeld 0
4867011 2316647 2316647 plaintiff Hayward William   586201 586201 Hayward, William, of Spryngfeld 0
4870041 2317596 2317596 defendant Wylle Richard huabandman 586201 586201 Wylle, Richard, of Spryngfeld, huabandman 0
4875799 2319392 2319392 defendant Bosy John husbandman 586201 586201 Bosy, John, of Spryngfeld, husbandman 0
4906276 2328551 2328551 defendant Phelip Thomas gent 586201 586201 Phelip, Thomas, of Spryngfeld, gent 2
4906279 2328551 2328551 defendant Boukstrete John yeoman 586201 586201 Boukstrete, John, of Spryngfeld, yeoman 5
4908815 2329307 2329307 defendant Billeston Walter yeoman 586201 586201 Billeston, Walter, of Spryngfeld, yeoman 0
4974913 2349470 2349470 defendant Mountney John husbandman 586201 586201 Mountney, John, of Spryngfeld, husbandman 0
5187357 2412027 2412027 defendant Sawyn Thomas husbandman 586201 586201 Sawyn, Thomas, of Spryngfeld, husbandman 3
5188977 2412511 2412511 defendant Bovydon John yeoman 586201 586201 Bovydon, John, of Spryngfeld, yeoman 0
5188984 2412512 2412512 defendant Bovydon John yeoman 586201 586201 Bovydon, John, of Spryngfeld, yeoman 0
5205572 2417375 2417375 defendant Sawyn Thomas husbandman 586201 586201 Sawyn, Thomas, of Spryngfeld, husbandman 3
5206321 2417586 2417586 defendant Bovydon John yeoman 586201 586201 Bovydon, John, of Spryngfeld, yeoman 0
5216336 2420519 2420519 defendant Stonard John maltman 586201 586201 Stonard, John, of Spryngfeld, maltman 3
5392206 2472858 2472858 defendant Harry Robert laborer 586201 586201 Harry, Robert, of Spryngfeld, laborer 0
5428722 2483503 2483503 defendant Neale John husbandman 586201 586201 Neale, John, of Spryngfeld, husbandman 1
5505708 2506704 2506704 defendant Fuller Richard tailor 586201 586201 Fuller, Richard, of Spryngfeld, tailor 0
5505709 2506704 2506704 defendant Fuller John butcher 586201 586201 Fuller, John, of Spryngfeld, butcher 1
5518331 2510560 2510560 defendant Brekenome John, senior miller 586201 586201 Brekenome, John, senior, of Spryngfeld, miller 0
5550011 2520040 2520040 defendant Brewer Thomas husbandman 586201 586201 Brewer, Thomas, of Spryngfeld, husbandman 0
5618168 2549499 2549499 defendant Parrok John   586201 586201 Parrok, John, of Spryngfeld, parson 2

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