names

56 rows where place_id = 601728

✎ 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
3646729 1909378 1909378 defendant Richardson John yeoman 601728 601728 Richardson, John, of Osset, yeoman 1
3709885 1929406 1929406 defendant Lee William laborer 601728 601728 Lee, William, of Osset, laborer 0
3976483 2016352 2016352 defendant Boyth John husbandman 601728 601728 Boyth, John, of Osset, husbandman 0
4674800 2257732 2257732 defendant Jonson Robert choller 601728 601728 Jonson, Robert, of Osset, choller 2
4674801 2257732 2257732 defendant Jonson William   601728 601728 Jonson, William, of Osset, nail maker 3
4686363 2261343 2261343 defendant Blont William   601728 601728 Blont, William, of Osset, nail maker 0
4686364 2261343 2261343 defendant Blont Agnes   601728 601728 Blont, Agnes, of Osset, servant 1
4788658 2292508 2292508 defendant Blunt William nailer 601728 601728 Blunt, William, of Osset, nailer 6
4811324 2299651 2299651 defendant Blount William   601728 601728 Blount, William, of Osset, nail maker 2
4811325 2299651 2299651 defendant Wylbore William husbandman 601728 601728 Wylbore, William, of Osset, husbandman 3
4858538 2314043 2314043 defendant Aleyn William   601728 601728 Aleyn, William, of Osset, husbandman, son of Aleyn, John 1
4858539 2314043 2314043 defendant Willson John yeoman 601728 601728 Willson, John, of Osset, yeoman 2
4865082 2316054 2316054 defendant Grene Thomas husbandman 601728 601728 Grene, Thomas, of Osset, husbandman 0
4865087 2316054 2316054 defendant Deconson John husbandman 601728 601728 Deconson, John, of Osset, husbandman 5
4868578 2317148 2317148 defendant de Grene Thomas smith 601728 601728 de Grene, Thomas, of Osset, smith 0
4882367 2321398 2321398 defendant Wylson John nailer 601728 601728 Wylson, John, of Osset, nailer 0
4928286 2335273 2335273 defendant Aleyn John husbandman 601728 601728 Aleyn, John, of Osset, husbandman 0
4966270 2346844 2346844 defendant Smyth Thomas smith 601728 601728 Smyth, Thomas, of Osset, smith 1
4968455 2347532 2347532 defendant Birton William yeoman 601728 601728 Birton, William, of Osset, yeoman 0
5050645 2371821 2371821 defendant Grene John yeoman 601728 601728 Grene, John, of Osset, yeoman 0
5096238 2385337 2385337 defendant Grene ohn nailer 601728 601728 Grene, ohn, of Osset, nailer 1
5096239 2385337 2385337 defendant Tyas John husbandman 601728 601728 Tyas, John, of Osset, husbandman 2
5100834 2386659 2386659 plaintiff Aleyn John (legal representative) 601728 601728 Aleyn, John, of Osset, executors of 0
5105845 2388153 2388153 defendant Aleyn William nailer 601728 601728 Aleyn, William, of Osset, nailer 4
5105852 2388154 2388154 defendant Aleyn William nailer 601728 601728 Aleyn, William, of Osset, nailer 4
5133140 2396176 2396176 defendant Grene John yeoman 601728 601728 Grene, John, of Osset, yeoman 2
5137134 2397374 2397374 defendant Tomson John   601728 601728 Tomson, John, of Osset, nail man 0
5177072 2408985 2408985 defendant Grene John yeoman 601728 601728 Grene, John, of Osset, yeoman 4
5221110 2421879 2421879 defendant Robynson William husbandman 601728 601728 Robynson, William, of Osset, husbandman 2
5221116 2421880 2421880 defendant Robynson William husbandman 601728 601728 Robynson, William, of Osset, husbandman 2
5243968 2428426 2428426 defendant Tomson John nailer 601728 601728 Tomson, John, of Osset, nailer 0
5269893 2436302 2436302 defendant Robyson William   601728 601728 Robyson, William, of Osset, nail maker 2
5287827 2441462 2441462 defendant Hill Hugh yeoman 601728 601728 Hill, Hugh, of Osset, yeoman 2
5287828 2441462 2441462 defendant Wilson Robert tailor 601728 601728 Wilson, Robert, of Osset, tailor 3
5305161 2446550 2446550 defendant Pees Hugh husbandman 601728 601728 Pees, Hugh, of Osset, husbandman 0
5306572 2446956 2446956 defendant Fossard (illegible) naler or nail maker 601728 601728 Fossard, _, of Osset, naler or nail maker 0
5306573 2446956 2446956 defendant Hill Hugh naler 601728 601728 Hill, Hugh, of Osset, naler 1
5350647 2460314 2460314 defendant Emson Thomas carpenter 601728 601728 Emson, Thomas, of Osset, carpenter 4
5354315 2461416 2461416 defendant Netylton Richard   601728 601728 Netylton, Richard, of Osset 3
5356122 2461992 2461992 defendant Fletcher John husbandman 601728 601728 Fletcher, John, of Osset, husbandman 0
5356127 2461993 2461993 defendant Case Richard smith 601728 601728 Case, Richard, of Osset, smith 3
5392507 2472930 2472930 defendant Wilson Robert husbandman 601728 601728 Wilson, Robert, of Osset, husbandman 2
5431975 2484532 2484532 defendant Raynold John yeoman 601728 601728 Raynold, John, of Osset, yeoman 4
5443219 2487888 2487888 defendant Nettilton Richard yeoman 601728 601728 Nettilton, Richard, of Osset, yeoman 0
5448202 2489355 2489355 defendant Reynold John yeoman 601728 601728 Reynold, John, of Osset, yeoman 4
5448208 2489356 2489356 defendant Reunold John yeoman 601728 601728 Reunold, John, of Osset, yeoman 4
5455941 2491686 2491686 defendant Nettilton Richard yeoman 601728 601728 Nettilton, Richard, of Osset, yeoman 0
5458571 2492457 2492457 defendant Nettilton Richard yeoman 601728 601728 Nettilton, Richard, of Osset, yeoman 3
5467789 2495304 2495304 defendant Nettilton Richard yeoman 601728 601728 Nettilton, Richard, of Osset, yeoman 0
5467792 2495305 2495305 defendant Nettilton Richard yeoman 601728 601728 Nettilton, Richard, of Osset, yeoman 0
5470206 2496005 2496005 defendant Nettilton Richard yeoman 601728 601728 Nettilton, Richard, of Osset, yeoman 3
5495604 2503584 2503584 defendant Awesley John husbandman 601728 601728 Awesley, John, of Osset, husbandman 0
5563133 2523812 2523812 defendant Aleyn Richard yeoman 601728 601728 Aleyn, Richard, of Osset, yeoman 0
5624657 2551652 2551652 defendant Jonson William nailer 601728 601728 Jonson, William, of Osset, nailer 0
5624678 2551654 2551654 defendant Nayler John yeoman 601728 601728 Nayler, John, of Osset, yeoman 6
5624683 2551654 2551654 defendant Alyen John, junior nailer 601728 601728 Alyen, John, junior, of Osset, nailer 11

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);