names

39 rows where place_id = 587188

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590710 1864737 1864737 defendant Freyer Henry chapman 587188 587188 Freyer, Henry, of Devyses, Wilts, chapman 0
3764641 1946603 1946603 defendant Lymbery William clothier 587188 587188 Lymbery, William, of Devyses, Wilts, clothier 1
3799217 1957667 1957667 defendant Lymbury William, senior clothier 587188 587188 Lymbury, William, senior, of Devyses, Wilts, clothier 0
3952171 2007832 2007832 defendant Harryson Robert tailor 587188 587188 Harryson, Robert, of Devyses, Wilts, tailor 0
3955748 2009084 2009084 defendant Haynes Edward clothier 587188 587188 Haynes, Edward, of Devyses, Wilts, clothier 0
3976313 2016288 2016288 defendant Jeffrey William mercer 587188 587188 Jeffrey, William, of Devyses, Wilts, mercer 0
4150892 2078445 2078445 defendant Blare Patrick clerk 587188 587188 Blare, Patrick, of Devyses, Wilts, clerk 0
4272523 2120386 2120386 defendant Gregory George   587188 587188 Gregory, George, of Devyses, Wilts, tallow chandler 0
4331755 2140915 2140915 defendant Barrett William chapman 587188 587188 Barrett, William, of Devyses, Wilts, chapman 1
4332880 2141280 2141280 defendant Sherer Richard chapman 587188 587188 Sherer, Richard, of Devyses, Wilts, chapman 0
4381833 2158607 2158607 defendant Baylye Thomas gent 587188 587188 Baylye, Thomas, of Devyses, Wilts, gent 0
4400294 2164691 2164691 defendant Cordraye Robert chapman 587188 587188 Cordraye, Robert, of Devyses, Wilts, chapman 0
4653775 2247096 2247096 defendant Renewhey John   587188 587188 Renewhey, John, of Devyses, Wilts, net maker 11
4898372 2326146 2326146 defendant Petyrton John loader 587188 587188 Petyrton, John, of Devyses, Wilts, loader 1
4934917 2337324 2337324 defendant Sunnyng alias Wever Ralph butcher 587188 587188 Sunnyng alias Wever, Ralph, of Devyses, Wilts, butcher 0
4960253 2345041 2345041 defendant Sonnyng Ralph weaver 587188 587188 Sonnyng, Ralph, of Devyses, Wilts, weaver 1
5075986 2379312 2379312 plaintiff atte Water Philip   587188 587188 atte Water, Philip, of Devyses, Wilts, merchant, administrators of 0
5212328 2419348 2419348 defendant Cope John weaver 587188 587188 Cope, John, of Devyses, Wilts, weaver 0
5339120 2456812 2456812 defendant Tayllour John clothman 587188 587188 Tayllour, John, of Devyses, Wilts, clothman 0
5383870 2470473 2470473 defendant Gylbard William weaver 587188 587188 Gylbard, William, of Devyses, Wilts, weaver 0
5409004 2477655 2477655 plaintiff Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5414704 2479335 2479335 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5414736 2479343 2479343 defendant Noreys Thomas gent 587188 587188 Noreys, Thomas, of Devyses, Wilts, gent 0
5430379 2484021 2484021 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5430382 2484022 2484022 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5430573 2484079 2484079 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5430605 2484090 2484090 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5447243 2489063 2489063 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5447253 2489067 2489067 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5459601 2492785 2492785 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5459718 2492827 2492827 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5459732 2492832 2492832 defendant Baker William gent 587188 587188 Baker, William, of Devyses, Wilts, gent 0
5506753 2507032 2507032 defendant Mere Nicholas clothman 587188 587188 Mere, Nicholas, of Devyses, Wilts, clothman 0
5512943 2508898 2508898 defendant Senyer John clothier 587188 587188 Senyer, John, of Devyses, Wilts, clothier 2
5518125 2510504 2510504 defendant Mere Nicholas clothman 587188 587188 Mere, Nicholas, of Devyses, Wilts, clothman 0
5531154 2514260 2514260 defendant Reynold John clothmaker 587188 587188 Reynold, John, of Devyses, Wilts, clothmaker 0
5536409 2515878 2515878 defendant Lymbury Richard clothier 587188 587188 Lymbury, Richard, of Devyses, Wilts, clothier 0
5567101 2524959 2524959 defendant Page William gent 587188 587188 Page, William, of Devyses, Wilts, gent 0
5589671 2531767 2531767 defendant Page William gent or merchant 587188 587188 Page, William, of Devyses, Wilts, gent or merchant 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);