names

46 rows where place_id = 587109

✎ 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
3590493 1864672 1864672 plaintiff Couper William mercer 587109 587109 Couper, William, of Est Grenested, mercer 0
3593864 1865719 1865719 defendant Lullyngden Thomas butcher 587109 587109 Lullyngden, Thomas, of Est Grenested, butcher 2
3614118 1872081 1872081 defendant Marshall William yeoman or gent 587109 587109 Marshall, William, of Est Grenested, or of Westminster, yeoman or gent 0
3735658 1937387 1937387 defendant Harrowden Thomas carpenter 587109 587109 Harrowden, Thomas, of Est Grenested, carpenter 0
3809071 1960721 1960721 defendant Cocheforth Thomas yeoman 587109 587109 Cocheforth, Thomas, of Est Grenested, yeoman 0
3809074 1960722 1960722 defendant Homwod John yeoman 587109 587109 Homwod, John, of Est Grenested, yeoman 0
3959863 2010541 2010541 defendant Oymond or Ormond John husbandman 587109 587109 Oymond or Ormond, John, of Est Grenested, husbandman 0
3959866 2010542 2010542 defendant Symond John husbandman 587109 587109 Symond, John, of Est Grenested, husbandman 0
3965222 2012448 2012448 defendant Camefyld or Cainefyld Anthony husbandman 587109 587109 Camefyld or Cainefyld, Anthony, of Est Grenested, husbandman 0
3969577 2013969 2013969 defendant Kydder Thomas tailor 587109 587109 Kydder, Thomas, of Est Grenested, tailor 0
3977837 2016820 2016820 plaintiff Lystney Richard tailor 587109 587109 Lystney, Richard, of Est Grenested, tailor 0
3987003 2020092 2020092 defendant Camefeld or Cainefeld Anthony husbandman 587109 587109 Camefeld or Cainefeld, Anthony, of Est Grenested, husbandman 0
4005900 2026880 2026880 defendant Taylor Francis husbandman 587109 587109 Taylor, Francis, of Est Grenested, husbandman 1
4018185 2031227 2031227 defendant Sackevyle Gilbert gent 587109 587109 Sackevyle, Gilbert, of Est Grenested, gent 0
4074174 2051061 2051061 defendant Payne Henry husbandman 587109 587109 Payne, Henry, of Est Grenested, husbandman 0
4220896 2102803 2102803 defendant Rydges William (legal representative) 587109 587109 Rydges, William, of Est Grenested, yeoman, executrix of 0
4247976 2112310 2112310 defendant Standen Morgan hammer man 587109 587109 Standen, Morgan, of East Grenested, or of Lamberherst, hammer man 0
4361280 2151197 2151197 defendant Lullingden Thomas (legal representative) 587109 587109 Lullingden, Thomas, of East Grenested, smith, executor of 0
4371892 2155008 2155008 defendant Johnson Robert tailor 587109 587109 Johnson, Robert, of Est Grenested, tailor 0
4693905 2263596 2263596 defendant Wodye Thomas husbandman 587109 587109 Wodye, Thomas, of East Grenested, husbandman 0
4904503 2328016 2328016 defendant Otewey John laborer 587109 587109 Otewey, John, of Est Grenested, laborer 0
5194674 2414177 2414177 defendant Bust Thomas yeoman 587109 587109 Bust, Thomas, of East Grenested, yeoman 0
5234769 2425758 2425758 defendant Cooke John tailor 587109 587109 Cooke, John, of Est Grenested, tailor 0
5254130 2431413 2431413 defendant Skynner Richard husbandman 587109 587109 Skynner, Richard, of Est Grenested, husbandman 0
5255939 2431981 2431981 defendant Skynner Richard yeoman 587109 587109 Skynner, Richard, of Est Grenested, yeoman 3
5265399 2434935 2434935 defendant Arnold John tanner 587109 587109 Arnold, John, of Est Grenested, tanner 0
5342856 2457960 2457960 defendant Lullyngden James husbandman 587109 587109 Lullyngden, James, of Est Grenested, husbandman 1
5364396 2464527 2464527 plaintiff Alfray John (legal representative) 587109 587109 Alfray, John, of East Grenested, administrator of 0
5364397 2464527 2464527 plaintiff Alfray Richard   587109 587109 Alfray, Richard, of East Grenested 1
5493596 2502998 2502998 defendant Alfrey Peter gent 587109 587109 Alfrey, Peter, of Est Grenested, gent 0
5493598 2502999 2502999 defendant Alfrey Peter gent 587109 587109 Alfrey, Peter, of Est Grenested, gent 0
5493907 2503084 2503084 defendant Rednes Thomas yeoman 587109 587109 Rednes, Thomas, of Est Grenested, yeoman 3
5496490 2503859 2503859 defendant Wody William yeoman 587109 587109 Wody, William, of Est Grenested, yeoman 0
5498198 2504415 2504415 defendant Honyngton or Hovyngton Paul laborer 587109 587109 Honyngton or Hovyngton, Paul, of Est Grenested, laborer 0
5501656 2505449 2505449 defendant Hasylden Richard laborer 587109 587109 Hasylden, Richard, of Est Grenested, laborer 2
5501657 2505449 2505449 defendant Marchall John, junior laborer 587109 587109 Marchall, John, junior, of Est Grenested, laborer 3
5501658 2505449 2505449 defendant Graunford John laborer 587109 587109 Graunford, John, of Est Grenested, laborer 4
5507404 2507210 2507210 plaintiff Couper William mercer 587109 587109 Couper, William, of Est Grenested, mercer 0
5507407 2507211 2507211 plaintiff Couper William mercer 587109 587109 Couper, William, of Est Grenested, mercer 0
5507410 2507212 2507212 plaintiff Couper William mercer 587109 587109 Couper, William, of Est Grenested, mercer 0
5523363 2512138 2512138 defendant Mill William husbandman 587109 587109 Mill, William, of Est Grenested, husbandman 1
5527256 2513102 2513102 defendant Lullyngdene Thomas, junior   587109 587109 Lullyngdene, Thomas, junior, of Est Grenested 0
5537340 2516171 2516171 plaintiff Coper Peter   587109 587109 Coper, Peter, of Est Grenested 0
5537341 2516171 2516171 defendant Duffeld Henry tanner 587109 587109 Duffeld, Henry, of Est Grenested, tanner 0
5563996 2524085 2524085 defendant Hill or Hall Richard husbandman 587109 587109 Hill or Hall, Richard, of Est Grenested, husbandman 1
5586826 2530919 2530919 defendant Duffyld Henry tanner 587109 587109 Duffyld, Henry, of Est Grenested, tanner 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);