names

39 rows where place_id = 608265

✎ 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
3655406 1911951 1911951 plaintiff Boswell Hugh   608265 608265 Boswell, Hugh, of Derfeld, Rector 0
3672927 1917545 1917545 defendant Holgate John miller 608265 608265 Holgate, John, of Derfeld, miller 0
3696321 1925070 1925070 defendant Draxe Thomas clerk 608265 608265 Draxe, Thomas, of Derfeld, clerk 0
3710175 1929497 1929497 defendant Drax Thomas clerk 608265 608265 Drax, Thomas, of Derfeld, clerk 0
3826117 1966010 1966010 defendant Wadylove Thomas chaplain 608265 608265 Wadylove, Thomas, of Derfeld, chaplain 0
3826118 1966010 1966010 defendant Fletcher Robert husbandman 608265 608265 Fletcher, Robert, of Derfeld, husbandman 1
3826119 1966010 1966010 defendant White Thomas husbandman 608265 608265 White, Thomas, of Derfeld, husbandman 2
3838709 1970034 1970034 defendant Masuret William carver 608265 608265 Masuret, William, of Derfeld, carver 0
4493560 2198690 2198690 plaintiff Basevyll John   608265 608265 Basevyll, John, of Derfeld, on his own account 0
4602251 2231921 2231921 defendant Midylwode Robert   608265 608265 Midylwode, Robert, of Derfeld 1
4602257 2231922 2231922 defendant Midylwode Robert   608265 608265 Midylwode, Robert, of Derfeld 1
4650072 2246035 2246035 defendant Wyrsop William   608265 608265 Wyrsop, William, of Derfeld, vicar 0
4724538 2272971 2272971 defendant Wykerslay Thomas   608265 608265 Wykerslay, Thomas, of Derfeld, parson of half the church 0
4748798 2280134 2280134 defendant Sotheron John milner 608265 608265 Sotheron, John, of Derfeld, milner 2
4792621 2293781 2293781 defendant Sothoron John miller 608265 608265 Sothoron, John, of Derfeld, miller 3
4853782 2312595 2312595 plaintiff Wykerslay Thomas   608265 608265 Wykerslay, Thomas, of Derfeld, parson of half the church 0
4854286 2312750 2312750 defendant Toppyng William husbandman 608265 608265 Toppyng, William, of Derfeld, husbandman 0
4854332 2312759 2312759 defendant Fleccher John husbandman 608265 608265 Fleccher, John, of Derfeld, husbandman 1
4877056 2319795 2319795 defendant Henson Robert husbandman 608265 608265 Henson, Robert, of Derfeld, husbandman 0
4895870 2325376 2325376 defendant Machet John husbandman 608265 608265 Machet, John, of Derfeld, husbandman 0
4900481 2326793 2326793 defendant Brige William husbandman 608265 608265 Brige, William, of Derfeld, husbandman 2
4914926 2331177 2331177 plaintiff de Halle Thomas   608265 608265 de Halle, Thomas, of Derfeld 0
4972178 2348620 2348620 defendant Koke William quarrier 608265 608265 Koke, William, of Derfeld, quarrier 0
4972180 2348621 2348621 defendant Koke William quarrier 608265 608265 Koke, William, of Derfeld, quarrier 0
5051831 2372162 2372162 defendant Mason Thomas butcher 608265 608265 Mason, Thomas, of Derfeld, butcher 1
5119167 2392035 2392035 defendant Wodhall William yeoman 608265 608265 Wodhall, William, of Derfeld, yeoman 0
5240719 2427496 2427496 defendant Jubbe Richard yeoman 608265 608265 Jubbe, Richard, of Derfeld, yeoman 3
5268643 2435950 2435950 plaintiff Boswell John   608265 608265 Boswell, John, of Derfeld, parson 0
5268649 2435951 2435951 plaintiff Boswell John   608265 608265 Boswell, John, of Derfeld, parson 0
5282381 2439909 2439909 defendant Parkyn John husbandman 608265 608265 Parkyn, John, of Derfeld, husbandman 0
5282386 2439909 2439909 defendant Carter William husbandman 608265 608265 Carter, William, of Derfeld, husbandman 5
5301263 2445332 2445332 defendant Barmby William   608265 608265 Barmby, William, of Derfeld, vicar 0
5351432 2460548 2460548 defendant Wodall Elizabeth widow 608265 608265 Wodall, Elizabeth, of Derfeld, widow 2
5489998 2501896 2501896 defendant Esot William cordwainer 608265 608265 Esot, William, of Derfeld, cordwainer 3
5490002 2501896 2501896 defendant Oldom Edmund cordwainer 608265 608265 Oldom, Edmund, of Derfeld, cordwainer 7
5495337 2503504 2503504 defendant Strafford Alice widow 608265 608265 Strafford, Alice, of Derfeld, widow 2
5542606 2517810 2517810 defendant Wodhall Robert yeoman 608265 608265 Wodhall, Robert, of Derfeld, yeoman 3
5563158 2523821 2523821 defendant Wodhall Robert yeoman 608265 608265 Wodhall, Robert, of Derfeld, yeoman 0
5563162 2523823 2523823 defendant Wodhall Robert yeoman 608265 608265 Wodhall, Robert, of Derfeld, yeoman 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);