names

68 rows where place_id = 585969

✎ 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
3587603 1863770 1863770 defendant Edward Thomas gent 585969 585969 Edward, Thomas, of Lewys, Sussex, gent 0
3596401 1866504 1866504 defendant Sherman Thomas, junior gent 585969 585969 Sherman, Thomas, junior, of Lewys, Sussex, gent 2
3768812 1947894 1947894 defendant Prewley alias Lumbard John merchant 585969 585969 Prewley alias Lumbard, John, of Lewys, Sussex, merchant 2
3775340 1950026 1950026 defendant Walsted John beer brewer 585969 585969 Walsted, John, of Lewys, Sussex, beer brewer 2
3775346 1950028 1950028 defendant Walsted John beer brewer 585969 585969 Walsted, John, of Lewys, Sussex, beer brewer 2
3845633 1972177 1972177 plaintiff Flussher Peter mercer 585969 585969 Flussher, Peter, of Lewys, Sussex, mercer 0
3858414 1976291 1976291 defendant Wylkyns John yeoman 585969 585969 Wylkyns, John, of Lewys, Sussex, yeoman 2
3877670 1982773 1982773 defendant Jenyns Nicholas draper 585969 585969 (Jenyns, Nicholas, of Lewys, Sussex, draper 4
3903048 1991246 1991246 defendant Bell Richard pewterer 585969 585969 Bell, Richard, of Lewys, Sussex, pewterer 0
3981068 2017989 2017989 defendant Vyncent Francis goldsmith 585969 585969 Vyncent, Francis, of Lewys, Sussex, gent, goldsmith 0
4069150 2049259 2049259 defendant Jurden John clerk 585969 585969 Jurden, John, of Lewys, Sussex, clerk 2
4206213 2097719 2097719 defendant Morley Anthony gent 585969 585969 Morley, Anthony, of Lewys, Sussex, or of Llannonno, Glamorgan, gent 0
4259044 2115996 2115996 defendant Keetche Richard merchant 585969 585969 Keetche, Richard, of Lewys, Sussex, merchant 0
4751067 2280796 2280796 defendant Gylus Richard   585969 585969 Gylus, Richard, of Lewys, Sussex, brass worker 0
4769007 2286283 2286283 defendant Fylchyng Richard chapman 585969 585969 Fylchyng, Richard, of Lewys, Sussex, chapman 3
4894303 2324902 2324902 defendant Grove John gent 585969 585969 Grove, John, of Lewys, Sussex, gent 3
4958163 2344408 2344408 defendant Kendale John draper 585969 585969 Kendale, John, of Lewys, Sussex, draper 0
4986371 2352851 2352851 defendant Denys Robert skinner 585969 585969 Denys, Robert, of Lewys, Sussex, skinner 0
5002715 2357707 2357707 defendant Potter John chapman 585969 585969 Potter, John, of Lewys, Sussex, chapman 0
5002721 2357708 2357708 defendant Potter John chapman 585969 585969 Potter, John, of Lewys, Sussex, chapman 0
5002752 2357713 2357713 defendant Porter John chapman 585969 585969 Porter, John, of Lewys, Sussex, chapman 0
5002759 2357714 2357714 defendant Potter John chapman 585969 585969 Potter, John, of Lewys, Sussex, chapman 0
5004914 2358337 2358337 defendant Colvyle Robert (legal representative) 585969 585969 Colvyle, Robert, of Lewys, Sussex, administrator of 0
5005035 2358371 2358371 defendant Porter John chapman 585969 585969 Porter, John, of Lewys, Sussex, chapman 0
5005038 2358372 2358372 defendant Potter John chapman 585969 585969 Potter, John, of Lewys, Sussex, chapman 0
5042106 2369245 2369245 defendant Mone John   585969 585969 Mone, John, of Lewys, Sussex, yeomen 0
5058064 2373980 2373980 defendant Mone John yeoman 585969 585969 Mone, John, of Lewys, Sussex, yeoman 0
5064296 2375866 2375866 defendant Bekwyth Thomas gent 585969 585969 Bekwyth, Thomas, of Lewys, Sussex, ,gent 2
5064300 2375867 2375867 defendant Bekwyth Thomas gent 585969 585969 Bekwyth, Thomas, of Lewys, Sussex, gent 2
5099871 2386398 2386398 defendant Dene Robert   585969 585969 Dene, Robert, of Lewys, Sussex, woollen weaver 3
5105890 2388163 2388163 defendant Gregory John yeoman 585969 585969 Gregory, John, of Lewys, Sussex, yeoman 1
5124808 2393729 2393729 defendant Suthwell John esq 585969 585969 Suthwell, John, of Lewys, Sussex, esq 0
5127871 2394630 2394630 defendant Bekwyth John yeoman 585969 585969 Bekwyth, John, of Lewys, Sussex, yeoman 1
5127915 2394642 2394642 defendant Bekwyt John yeoman 585969 585969 Bekwyt, John, of Lewys, Sussex, yeoman 1
5138046 2397632 2397632 defendant Mone John dyer 585969 585969 Mone, John, of Lewys, Sussex, dyer 1
5143366 2399199 2399199 defendant Suthwell John esq 585969 585969 Suthwell, John, of Lewys, Sussex, esq 0
5143368 2399200 2399200 defendant Suthwell John esq 585969 585969 Suthwell, John, of Lewys, Sussex, esq 0
5143568 2399255 2399255 defendant Malham John butcher 585969 585969 Malham, John, of Lewys, Sussex, butcher 0
5146965 2400252 2400252 defendant Bekwyth John yeoman 585969 585969 Bekwyth, John, of Lewys, Sussex, yeoman 1
5157019 2403194 2403194 defendant Toller John chapman 585969 585969 Toller, John, of Lewys, Sussex, chapman 3
5158717 2403670 2403670 defendant Mone or Move John dyer 585969 585969 Mone or Move, John, of Lewys, Sussex, dyer 1
5158718 2403670 2403670 defendant Cole Richard chapman 585969 585969 Cole, Richard, of Lewys, Sussex, chapman 2
5173078 2407836 2407836 defendant Toller John chapman 585969 585969 Toller, John, of Lewys, Sussex, chapman 2
5174145 2408140 2408140 defendant Mone or Move John dyer 585969 585969 Mone or Move, John, of Lewys, Sussex, dyer 1
5174146 2408140 2408140 defendant Cole Richard chapman 585969 585969 Cole, Richard, of Lewys, Sussex, chapman 2
5177979 2409266 2409266 defendant Suthwell John esq 585969 585969 Suthwell, John, of Lewys, Sussex, esq 0
5181001 2410181 2410181 defendant Cheseman William butcher 585969 585969 Cheseman, William, of Lewys, Sussex, butcher 2
5192885 2413642 2413642 defendant Toller John chapman 585969 585969 Toller, John, of Lewys, Sussex, chapman 2
5194636 2414164 2414164 defendant Mone or Move John dyer 585969 585969 Mone or Move, John, of Lewys, Sussex, dyer 1
5201202 2416110 2416110 defendant Suthwell John esq 585969 585969 Suthwell, John, of Lewys, Sussex, esq 0
5202435 2416476 2416476 defendant Cheseman William butcher 585969 585969 Cheseman, William, of Lewys, Sussex, butcher 2
5211887 2419215 2419215 defendant Suthwell John esq 585969 585969 Suthwell, John, of Lewys, Sussex, or of London, esq 0
5214240 2419897 2419897 defendant Cheseman alias Qwhite William butcher 585969 585969 Cheseman alias Qwhite, William, of Lewys, Sussex, butcher 0
5241239 2427641 2427641 defendant Oneste Richard yeoman 585969 585969 Oneste, Richard, of Lewys, Sussex, yeoman 3
5241245 2427642 2427642 defendant Duest Richard yeoman 585969 585969 Duest, Richard, of Lewys, Sussex, yeoman 3
5241820 2427808 2427808 defendant Beest Thomas gent 585969 585969 Beest, Thomas, of Lewys, Sussex, gent 1
5247986 2429546 2429546 defendant Cok John chapman 585969 585969 Cok, John, of Lewys, Sussex, chapman 4
5294657 2443418 2443418 defendant Idell Roger chapman 585969 585969 Idell, Roger, of Lewys, Sussex, chapman 3
5310451 2448162 2448162 defendant Idell Roger   585969 585969 Idell, Roger, of Lewys, Sussex 0
5321109 2451411 2451411 defendant Knotte John   585969 585969 Knotte, John, of Lewys, Sussex, attorney 0
5324566 2452428 2452428 defendant Wolwyn Thomas draper 585969 585969 Wolwyn, Thomas, of Lewys, Sussex, draper 6
5381225 2469685 2469685 defendant Toller John mercer 585969 585969 Toller, John, of Lewys, Sussex, mercer 1
5388004 2471625 2471625 defendant Toller John mercer 585969 585969 Toller, John, of Lewys, Sussex, mercer 0
5470456 2496084 2496084 defendant Premer Robert draper 585969 585969 Premer, Robert, of Lewys, Sussex, draper 0
5481787 2499485 2499485 defendant Falke John hardwareman 585969 585969 Falke, John, of Lewys, Sussex, hardwareman 1
5568858 2525441 2525441 defendant Erlle John husbandman 585969 585969 (Erlle, John, of Lewys, Sussex, husbandman 4
5635914 2555193 2555193 defendant Was Thomas woolpacker 585969 585969 Was, Thomas, of Lewys, Sussex, woolpacker 1
5635921 2555194 2555194 defendant Was Thomas woolpacker 585969 585969 Was, Thomas, of Lewys, Sussex, woolpacker 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);