names

35 rows where place_id = 599957

✎ 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
3639019 1907025 1907025 defendant Peele John husbandman 599957 599957 Peele, John, of Sprotton, husbandman 0
3694645 1924531 1924531 defendant Clypsam William husbandman 599957 599957 Clypsam, William, of Sprotton, husbandman 0
3737697 1938013 1938013 defendant Sutton William miller 599957 599957 Sutton, William, of Sprotton, miller 0
3975014 2015823 2015823 defendant Hodges Edward husbandman 599957 599957 Hodges, Edward, of Sprotton, husbandman 0
4163341 2082705 2082705 defendant Heyward William yeoman 599957 599957 Heyward, William, of Sprotton, yeoman 0
4236318 2108274 2108274 defendant Manley Francis yeoman 599957 599957 Manley, Francis, of Sprotton, yeoman 0
4352240 2148019 2148019 defendant Sturdy alias Grosse William butcher 599957 599957 Sturdy alias Grosse, William, of Sprotton, butcher 0
4464719 2189633 2189633 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 0
4483337 2195490 2195490 defendant Denes John   599957 599957 Denes, John, of Sprotton 0
4483351 2195490 2195490 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 14
4483358 2195493 2195493 defendant Denes John   599957 599957 Denes, John, of Sprotton 0
4483371 2195493 2195493 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 13
4483398 2195496 2195496 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 13
4551125 2216295 2216295 defendant Miller John   599957 599957 Miller, John, of Sprotton 0
4551127 2216295 2216295 defendant Hikson William   599957 599957 Hikson, William, of Sprotton 2
4581401 2225649 2225649 defendant Miller John   599957 599957 Miller, John, of Sprotton 0
4633073 2241213 2241213 plaintiff Walter John   599957 599957 Walter, John, of Sprotton 0
4675067 2257811 2257811 defendant Chaumbre Thomas esq 599957 599957 Chaumbre, Thomas, of Sprotton, esq 2
4680604 2259544 2259544 plaintiff Lorimer John   599957 599957 Lorimer, John, of Sprotton 0
4715318 2270124 2270124 defendant Miller John yeoman 599957 599957 Miller, John, of Sprotton, yeoman 0
4736595 2276575 2276575 defendant Milm_ John husbandman 599957 599957 Milm_, John, of Sprotton, husbandman 0
4746511 2279471 2279471 defendant Milner Henry milner 599957 599957 Milner, Henry, of Sprotton, milner 1
4752549 2281205 2281205 defendant Milner John husbandman 599957 599957 Milner, John, of Sprotton, husbandman 0
4755955 2282244 2282244 defendant Groby Simon husbandman 599957 599957 Groby, Simon, of Sprotton, husbandman 0
4824484 2303706 2303706 defendant Groby Simon husbandman 599957 599957 Groby, Simon, of Sprotton, husbandman 0
4865881 2316302 2316302 defendant Milner John weaver 599957 599957 Milner, John, of Sprotton, weaver 1
4990251 2353992 2353992 defendant Ardern Henry yeoman 599957 599957 Ardern, Henry, of Sprotton, yeoman 4
5041024 2368942 2368942 defendant Miller Emma widow 599957 599957 Miller, Emma, of Sprotton, widow 0
5108727 2388989 2388989 defendant Chambre William gent 599957 599957 Chambre, William, of Sprotton, gent 0
5147113 2400293 2400293 defendant Myllyn Emma widow 599957 599957 Myllyn, Emma, of Sprotton, widow 2
5166948 2406062 2406062 defendant Myllyn Emma widow 599957 599957 Myllyn, Emma, of Sprotton, widow 2
5203215 2416703 2416703 defendant Myllyn Emma widow 599957 599957 Myllyn, Emma, of Sprotton, widow 2
5222386 2422256 2422256 defendant Ardern William yeoman 599957 599957 Ardern, William, of Sprotton, yeoman 2
5225424 2423114 2423114 defendant Wale John husbandman 599957 599957 Wale, John, of Sprotton, husbandman 0
5626364 2552213 2552213 plaintiff Milner John   599957 599957 Milner, John, of Sprotton 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);