names

93 rows where place_id = 587005

✎ 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
3590216 1864581 1864581 defendant Saunderson William tailor 587005 587005 Saunderson, William, of Navestok, tailor 0
3590218 1864582 1864582 defendant Saunderson William tailor 587005 587005 Saunderson, William, of Navestok, tailor 0
3601712 1868189 1868189 defendant Hanke or Hauke John husbandman 587005 587005 Hanke or Hauke, John, of Navestok, husbandman 0
3603286 1868700 1868700 defendant Feer William yeoman 587005 587005 Feer, William, of Navestok, yeoman 1
3636352 1906162 1906162 defendant Gravys John husbandman 587005 587005 Gravys, John, of Navestok, husbandman 0
3636353 1906162 1906162 defendant Hawke John husbandman 587005 587005 Hawke, John, of Navestok, husbandman 1
3636354 1906162 1906162 defendant Bett Thomas husbandman 587005 587005 Bett, Thomas, of Navestok, husbandman 2
3693721 1924230 1924230 defendant Staple William husbandman 587005 587005 Staple, William, of Navestok, husbandman 0
3693722 1924230 1924230 defendant Staple Thomas husbandman 587005 587005 Staple, Thomas, of Navestok, husbandman 1
3698281 1925680 1925680 defendant Magoke Thomas husbandman 587005 587005 Magoke, Thomas, of Navestok, husbandman 3
3707451 1928625 1928625 defendant Nevelok John husbandman 587005 587005 Nevelok, John, of Navestok, husbandman 0
3707467 1928628 1928628 defendant Glascok William drover 587005 587005 Glascok, William, of Navestok, drover 4
3710916 1929732 1929732 defendant Halke or Hawe John, senior husbandman 587005 587005 Halke or Hawe, John, senior, of Navestok, husbandman 3
3710921 1929733 1929733 defendant Halke or Hawe John, senior husbandman 587005 587005 Halke or Hawe, John, senior, of Navestok, husbandman 3
3750097 1941944 1941944 defendant Bett Thomas husbandman 587005 587005 Bett, Thomas, of Navestok, husbandman 0
3843561 1971523 1971523 defendant Bette William husbandman 587005 587005 Bette, William, of Navestok, husbandman 0
3853026 1974565 1974565 defendant Comyng Roger tanner 587005 587005 Comyng, Roger, of Navestok, tanner 3
3880368 1983689 1983689 defendant Partriche Bartholomew yeoman 587005 587005 Partriche, Bartholomew, of Navestok, yeoman 0
3880369 1983689 1983689 defendant Salkyn William husbandman 587005 587005 Salkyn, William, of Navestok, husbandman 1
3880370 1983689 1983689 defendant Edall John laborer 587005 587005 Edall, John, of Navestok, laborer 2
3880371 1983689 1983689 defendant Mullyng Robert laborer 587005 587005 Mullyng, Robert, of Navestok, laborer 3
3906871 1992587 1992587 defendant Colford Thomas husbandman 587005 587005 Colford, Thomas, of Navestok, husbandman 0
4425992 2172932 2172932 defendant Medfray Robert   587005 587005 Medfray, Robert, of Navestok 1
4472175 2191962 2191962 defendant del Ayre John   587005 587005 del Ayre, John, of Navestok 0
4476742 2193387 2193387 plaintiff Hount Richard   587005 587005 Hount, Richard, of Navestok 1
4690418 2262563 2262563 defendant Gardyner Francis husbandman 587005 587005 Gardyner, Francis, of Navestok, husbandman 0
4690421 2262564 2262564 defendant Gardyner Franics husbandman 587005 587005 Gardyner, Franics, of Navestok, husbandman 0
4719062 2271311 2271311 defendant Clerk John   587005 587005 Clerk, John, of Navestok, corn monger 0
4894238 2324884 2324884 defendant Ferrour or Smith John   587005 587005 Ferrour or Smith, John, of Navestok 0
4894239 2324884 2324884 defendant Bury John   587005 587005 Bury, John, of Navestok 1
4894240 2324884 2324884 defendant Donshede Robert   587005 587005 Donshede, Robert, of Navestok 2
4986461 2352878 2352878 defendant Sobarn Walter carpenter 587005 587005 Sobarn, Walter, of Navestok, carpenter 0
4987538 2353228 2353228 defendant Conners John husbandman 587005 587005 Conners, John, of Navestok, husbandman 2
4999706 2356791 2356791 defendant Harlyng John   587005 587005 Harlyng, John, of Navestok, wool man 1
4999707 2356791 2356791 defendant Harlyng John butcher 587005 587005 Harlyng, John, of Navestok, butcher 2
5023164 2363676 2363676 defendant Clerk John husbandman 587005 587005 Clerk, John, of Navestok, husbandman 0
5100730 2386639 2386639 defendant Martyn Thomas husbandman 587005 587005 Martyn, Thomas, of Navestok, husbandman 0
5160173 2404076 2404076 defendant Colforth Thomas husbandman 587005 587005 Colforth, Thomas, of Navestok, husbandman 0
5160174 2404076 2404076 defendant Martyn Thomas laborer 587005 587005 Martyn, Thomas, of Navestok, laborer 1
5160755 2404243 2404243 defendant Bette William yeoman 587005 587005 Bette, William, of Navestok, yeoman 0
5175050 2408396 2408396 defendant Colford Thomas husbandman 587005 587005 Colford, Thomas, of Navestok, husbandman 0
5175051 2408396 2408396 defendant Martyn Thomas laborer 587005 587005 Martyn, Thomas, of Navestok, laborer 1
5175467 2408513 2408513 defendant Bette William yeoman 587005 587005 Bette, William, of Navestok, yeoman 0
5196043 2414590 2414590 defendant Martyn Thomas laborer 587005 587005 Martyn, Thomas, of Navestok, laborer 1
5209492 2418516 2418516 defendant Colford Thomas husbandman 587005 587005 Colford, Thomas, of Navestok, husbandman 0
5209493 2418516 2418516 defendant Martyn Thomas laborer 587005 587005 Martyn, Thomas, of Navestok, laborer 1
5217152 2420751 2420751 defendant Rokke John, senior (legal representative) 587005 587005 Rokke, John, senior, of Navestok, husbandman, executor of 1
5248627 2429721 2429721 defendant Rukke John butcher 587005 587005 Rukke, John, of Navestok, butcher 2
5257006 2432321 2432321 plaintiff Everton John   587005 587005 Everton, John, of Navestok, esq, administrators of 0
5291920 2442643 2442643 defendant Rowk William husbandman 587005 587005 Rowk, William, of Navestok, or of Dagnam Hall, Essex, husbandman 1
5314939 2449518 2449518 defendant Scarlet John carpenter 587005 587005 Scarlet, John, of Navestok, carpenter 1
5319482 2450919 2450919 defendant Manger William carpenter 587005 587005 Manger, William, of Navestok, carpenter 2
5320108 2451103 2451103 defendant Brygges Edward husbandman 587005 587005 Brygges, Edward, of Navestok, husbandman 0
5320112 2451104 2451104 defendant Brygges Edward husbandman 587005 587005 Brygges, Edward, of Navestok, husbandman 0
5322473 2451793 2451793 defendant Marram Robert husbandman 587005 587005 Marram, Robert, of Navestok, husbandman 0
5328515 2453605 2453605 defendant Conners John husbandman 587005 587005 Conners, John, of Navestok, husbandman 0
5332775 2454869 2454869 defendant Toller John husbandman 587005 587005 Toller, John, of Navestok, husbandman 2
5332776 2454869 2454869 defendant Glorwych John husbandman 587005 587005 Glorwych, John, of Navestok, husbandman 3
5332780 2454870 2454870 defendant Jenyn Richard husbandman 587005 587005 Jenyn, Richard, of Navestok, husbandman 0
5343518 2458163 2458163 defendant Everdon Robert gent 587005 587005 Everdon, Robert, of Navestok, gent 0
5343520 2458164 2458164 defendant Everdon Robert gent 587005 587005 Everdon, Robert, of Navestok, gent 0
5352913 2460998 2460998 defendant Lambe John butcher 587005 587005 Lambe, John, of Navestok, butcher 1
5366514 2465181 2465181 defendant Partrych Roger yeoman 587005 587005 Partrych, Roger, of Navestok, yeoman 1
5369418 2466029 2466029 defendant Sparowe (illegible) husbandman 587005 587005 Sparowe, -, of Navestok, husbandman 3
5371310 2466605 2466605 defendant Haweke John husbandman 587005 587005 Haweke, John, of Navestok, husbandman 3
5371943 2466814 2466814 plaintiff Jatteyn Richard yeoman 587005 587005 Jatteyn, Richard, of Navestok, yeoman 0
5381474 2469762 2469762 defendant Pelham John tanner 587005 587005 Pelham, John, of Navestok, tanner 0
5388675 2471817 2471817 defendant Pelham John tanner 587005 587005 Pelham, John, of Navestok, tanner 0
5388977 2471901 2471901 defendant Pelham John tanner 587005 587005 Pelham, John, of Navestok, tanner 0
5388982 2471902 2471902 defendant Pelham John   587005 587005 Pelham, John, of Navestok 0
5403568 2476092 2476092 defendant Lambe John laborer 587005 587005 Lambe, John, of Navestok, laborer 1
5434711 2485318 2485318 defendant Pelham John husbandman 587005 587005 Pelham, John, of Navestok, husbandman 0
5434712 2485318 2485318 defendant Barker John husbandman 587005 587005 Barker, John, of Navestok, husbandman 1
5434713 2485318 2485318 defendant Radley Thomas husbandman 587005 587005 Radley, Thomas, of Navestok, husbandman 2
5434715 2485318 2485318 defendant Colfford John smith 587005 587005 Colfford, John, of Navestok, smith 4
5450018 2489894 2489894 defendant Pelham John husbandman 587005 587005 Pelham, John, of Navestok, husbandman, Barker, John, of Navestok, husbandman 0
5450019 2489894 2489894 defendant Radley Thomas husbandman 587005 587005 Radley, Thomas, of Navestok, husbandman 1
5450021 2489894 2489894 defendant Colford John smith 587005 587005 Colford, John, of Navestok, smith 3
5487875 2501260 2501260 defendant Pelham John tanner 587005 587005 Pelham, John, of Navestok, tanner 0
5487877 2501261 2501261 defendant Pelham John tanner 587005 587005 Pelham, John, of Navestok, tanner 0
5489753 2501818 2501818 defendant Pelham John tanner 587005 587005 Pelham, John, of Navestok, tanner 1
5489755 2501818 2501818 defendant Dyse Simon husbandman 587005 587005 Dyse, Simon, of Navestok, husbandman 3
5517179 2510208 2510208 defendant Haweke John, junior husbandman 587005 587005 Haweke, John, junior, of Navestok, husbandman 0
5517180 2510208 2510208 defendant Haweke John, senior husbandman 587005 587005 Haweke, John, senior, of Navestok, husbandman 1
5517181 2510208 2510208 defendant Horseley Roger laborer 587005 587005 Horseley, Roger, of Navestok, laborer 2
5537042 2516069 2516069 defendant Skot John gent 587005 587005 Skot, John, of Navestok, gent 0
5537045 2516070 2516070 defendant Skot John gent 587005 587005 Skot, John, of Navestok, gent 0
5541213 2517372 2517372 defendant Bette William yeoman 587005 587005 Bette, William, of Navestok, yeoman, son of Bette, Richard, of Theydon atte Mounte, yeoman 0
5542545 2517792 2517792 defendant Brokes Geoffrey husbandman 587005 587005 Brokes, Geoffrey, of Navestok, husbandman 3
5545091 2518569 2518569 defendant Kyrwyn Robert husbandman 587005 587005 Kyrwyn, Robert, of Navestok, husbandman 0
5591657 2532372 2532372 defendant Colford John smith 587005 587005 Colford, John, of Navestok, smith 1
5591658 2532372 2532372 defendant Colford Elizabeth widow 587005 587005 Colford, Elizabeth, of Navestok, widow 2
5602449 2535658 2535658 defendant Hauke or Hanke John husbandman 587005 587005 Hauke or Hanke, John, of Navestok, 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);