names

56 rows where place_id = 595857

✎ 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
3622139 1874460 1874460 defendant Burwell Robert yeoman 595857 595857 Burwell, Robert, of Alnewyk, yeoman 1
3622140 1874460 1874460 defendant Neddall Thomas yeoman 595857 595857 Neddall, Thomas, of Alnewyk, yeoman 2
3788915 1954344 1954344 defendant Galand Hugh yeoman 595857 595857 Galand, Hugh, of Alnewyk, yeoman 0
4447902 2184271 2184271 defendant Porter William   595857 595857 Porter, William, of Alnewyk 0
4476839 2193417 2193417 defendant Sadier Thomas   595857 595857 Sadier, Thomas, of Alnewyk 6
4496814 2199672 2199672 defendant Clerk Thomas   595857 595857 Clerk, Thomas, of Alnewyk 0
4515740 2205350 2205350 plaintiff Clerk Thomas   595857 595857 Clerk, Thomas, of Alnewyk, son of Thomas 0
4515741 2205350 2205350 defendant Edall John   595857 595857 Edall, John, of Alnewyk 0
4519913 2206570 2206570 defendant Clerk William   595857 595857 Clerk, William, of Alnewyk 5
4553710 2217083 2217083 defendant Sadeler Thomas   595857 595857 Sadeler, Thomas, of Alnewyk, son of Thomas 0
4555216 2217568 2217568 plaintiff Haywerby John   595857 595857 Haywerby, John, of Alnewyk 0
4556862 2218081 2218081 plaintiff Kawardby John draper 595857 595857 Kawardby, John, of Alnewyk, draper 0
4575582 2223873 2223873 defendant Colt John   595857 595857 Colt, John, of Alnewyk, arrow maker 2
4580163 2225283 2225283 defendant Clerk Thomas   595857 595857 Clerk, Thomas, of Alnewyk 2
4581793 2225748 2225748 defendant Boucher John   595857 595857 Boucher, John, of Alnewyk 0
4586902 2227304 2227304 defendant Clerk Thomas   595857 595857 Clerk, Thomas, of Alnewyk 0
4617802 2236571 2236571 defendant Leche William   595857 595857 Leche, William, of Alnewyk 0
4652766 2246797 2246797 defendant Syondson John yeoman 595857 595857 Syondson, John, of Alnewyk, yeoman 0
4655474 2247607 2247607 defendant Patonson John draper 595857 595857 Patonson, John, of Alnewyk, draper 4
4657231 2248147 2248147 defendant Durem William clerk 595857 595857 Durem, William, of Alnewyk, clerk 0
4676043 2258119 2258119 defendant Lesbery Thomas tailor 595857 595857 Lesbery, Thomas, of Alnewyk, tailor 0
4707422 2267699 2267699 defendant Roos William chapman 595857 595857 Roos, William, of Alnewyk, chapman 0
4717869 2270929 2270929 defendant Forster Thomas paleser or park keeper 595857 595857 Forster, Thomas, of Alnewyk, paleser or park keeper 0
4731087 2274924 2274924 defendant Symondson John yeoman 595857 595857 Symondson, John, of Alnewyk, yeoman 2
4731088 2274924 2274924 defendant Messanger Richard yeoman 595857 595857 Messanger, Richard, of Alnewyk, yeoman 3
4731089 2274924 2274924 defendant Barnyngham William chapman 595857 595857 Barnyngham, William, of Alnewyk, chapman 4
4737353 2276800 2276800 defendant Neweson Thomas yeoman 595857 595857 Neweson, Thomas, of Alnewyk, yeoman 0
4753099 2281356 2281356 defendant Trollop Henry gent 595857 595857 Trollop, Henry, of Alnewyk, gent 0
4755085 2281975 2281975 defendant Bolton William yeoman 595857 595857 Bolton, William, of Alnewyk, yeoman 1
4776902 2288763 2288763 defendant Bolton William yeoman 595857 595857 Bolton, William, of Alnewyk, yeoman 1
4848308 2310941 2310941 defendant Galon William gent 595857 595857 Galon, William, of Alnewyk, gent 2
4857107 2313602 2313602 defendant Chapman John, junior chapman 595857 595857 Chapman, John, junior, of Alnewyk, chapman 1
4870661 2317802 2317802 defendant Beer John merchant 595857 595857 together with Beer, John, of Alnewyk, merchant 1
4876570 2319637 2319637 defendant Boutemond or Bontemond Richard chapman 595857 595857 Boutemond or Bontemond, Richard, of Alnewyk, chapman 0
4876571 2319637 2319637 defendant Staneford John smith 595857 595857 Staneford, John, of Alnewyk, smith 1
4881095 2320996 2320996 defendant Forster Robert uepman 595857 595857 Forster, Robert, of Alnewyk, uepman 3
4907073 2328784 2328784 defendant Ilderton Thomas esq 595857 595857 Ilderton, Thomas, of Alnewyk, esq 2
4936192 2337720 2337720 defendant Algode John chapman 595857 595857 Algode, John, of Alnewyk, chapman 1
4961124 2345290 2345290 defendant Rogerson John yeoman 595857 595857 Rogerson, John, of Alnewyk, yeoman 5
4970619 2348150 2348150 defendant Redell William yeoman 595857 595857 Redell, William, of Alnewyk, yeoman 10
4970620 2348150 2348150 defendant Rogerson John yeoman 595857 595857 Rogerson, John, of Alnewyk, yeoman 11
4992326 2354596 2354596 defendant Ridell William yeoman 595857 595857 Ridell, William, of Alnewyk, yeoman 1
5003327 2357871 2357871 defendant Marshall William   595857 595857 Marshall, William, of Alnewyk, abbot, and formerly vicar fot eh church of Chatton 0
5026382 2364604 2364604 defendant Bagot Hugh yeoman 595857 595857 Bagot, Hugh, of Alnewyk, yeoman 3
5090111 2383476 2383476 defendant Percy Ralph   595857 595857 Percy, Ralph, of Alnewyk, knight 3
5137153 2397379 2397379 defendant Ilderton Thomas, junior esq 595857 595857 Ilderton, Thomas, junior, of Alnewyk, esq 1
5190844 2413073 2413073 defendant Rokesburgh John yeoman 595857 595857 Rokesburgh, John, of Alnewyk, yeoman 1
5190848 2413073 2413073 defendant Shell John yeoman 595857 595857 Shell, John, of Alnewyk, yeoman 5
5190868 2413076 2413076 defendant Browell Adam yeoman 595857 595857 Browell, Adam, of Alnewyk, yeoman 4
5190869 2413076 2413076 defendant Patonson John yeoman 595857 595857 Patonson, John, of Alnewyk, yeoman 5
5310227 2448094 2448094 defendant Patunson Robert gent 595857 595857 Patunson, Robert, of Alnewyk, gent 0
5626396 2552225 2552225 defendant Etall John yeoman 595857 595857 Etall, John, of Alnewyk, yeoman 3
5628107 2552762 2552762 defendant Ryle John gent 595857 595857 Ryle, John, of Alnewyk, gent 0
5628108 2552762 2552762 defendant Symondson John yeoman 595857 595857 Symondson, John, of Alnewyk, yeoman 1
5635333 2555015 2555015 defendant Messanger Richard yeoman 595857 595857 Messanger, Richard, of Alnewyk, yeoman 0
5635334 2555015 2555015 defendant Richardson John husbandman 595857 595857 Richardson, John, of Alnewyk, husbandman 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);