names

63 rows where place_id = 595278

✎ 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
3619787 1873762 1873762 defendant Ingram John clerk 595278 595278 Ingram, John, of Horndon, clerk 0
4413551 2169129 2169129 defendant Spilcok John   595278 595278 Spilcok, John, of Horndon 1
4420695 2171369 2171369 defendant Burre Peter, senior   595278 595278 Burre, Peter, senior, of Horndon 0
4420696 2171369 2171369 defendant Burre Peter, junior   595278 595278 Burre, Peter, junior, of Horndon 1
4421223 2171531 2171531 defendant Ive Simon   595278 595278 Ive, Simon, of Horndon 0
4425941 2172915 2172915 defendant Ive Simon   595278 595278 Ive, Simon, of Horndon 0
4425945 2172916 2172916 defendant Ive Simon   595278 595278 Ive, Simon, of Horndon 0
4441721 2182348 2182348 defendant Malgraf Hugh   595278 595278 Malgraf, Hugh, of Horndon 0
4444986 2183406 2183406 defendant Sherman John   595278 595278 Sherman, John, of Horndon 1
4515472 2205258 2205258 defendant Malgrave Thomas   595278 595278 Malgrave, Thomas, of Horndon 0
4572167 2222845 2222845 defendant Kyngessey John   595278 595278 Kyngessey, John, of Horndon 6
4616596 2236191 2236191 defendant Orpud Bartholomew   595278 595278 Orpud, Bartholomew, of Horndon 0
4645748 2244821 2244821 plaintiff Orpid Bartholomew   595278 595278 Orpid, Bartholomew, of Horndon 0
4661251 2249340 2249340 plaintiff Dyker William   595278 595278 Dyker, William, of Horndon 0
4723265 2272587 2272587 defendant Spencer John yeoman 595278 595278 Spencer, John, of Horndon, yeoman 0
4734292 2275899 2275899 defendant Dodelee John yeoman 595278 595278 Dodelee, John, of Horndon, yeoman 0
4741751 2278082 2278082 defendant Yrland Thomas husbandman 595278 595278 Yrland, Thomas, of Horndon, husbandman 0
4771350 2287022 2287022 defendant Dodelee John yeoman 595278 595278 Dodelee, John, of Horndon, yeoman 0
4773397 2287655 2287655 plaintiff Tabour Henry   595278 595278 Tabour, Henry, of Horndon 0
4779651 2289623 2289623 defendant Partrich John skinner 595278 595278 Partrich, John, of Horndon, skinner 0
4796326 2294999 2294999 defendant Dodelee John yeoman 595278 595278 Dodelee, John, of Horndon, yeoman 0
4822541 2303125 2303125 plaintiff Daysone John   595278 595278 (Daysone, John, of Horndon, vicar 1
4826090 2304191 2304191 defendant Dodley John yeoman 595278 595278 Dodley, John, of Horndon, yeoman 0
4845469 2310096 2310096 defendant Dudeley John yeoman 595278 595278 Dudeley, John, of Horndon, yeoman 0
4855785 2313183 2313183 defendant Smyth Robert cordwainer 595278 595278 Smyth, Robert, of Horndon, cordwainer 0
4859224 2314261 2314261 defendant Horndon John husbandman 595278 595278 Horndon, John, of Horndon, husbandman 2
4859227 2314261 2314261 defendant Tody John husbandman 595278 595278 Tody, John, of Horndon, husbandman 5
4859765 2314421 2314421 defendant Bette John farmer 595278 595278 Bette, John, of Horndon, farmer 1
4859766 2314421 2314421 defendant Orped Robert husbandman 595278 595278 Orped, Robert, of Horndon, husbandman 2
4861107 2314832 2314832 plaintiff Cook Thomas, junior   595278 595278 Cook, Thomas, junior, of Horndon 0
4861108 2314832 2314832 defendant Smyth Robert cordwainer 595278 595278 Smyth, Robert, of Horndon, cordwainer 0
4863050 2315420 2315420 defendant Spencer John yeoman 595278 595278 Spencer, John, of Horndon, yeoman 4
4872990 2318510 2318510 defendant Dudeley John yeoman 595278 595278 Dudeley, John, of Horndon, yeoman 0
4876797 2319714 2319714 defendant Sebern Thomas tailor 595278 595278 Sebern, Thomas, of Horndon, tailor 0
4881405 2321083 2321083 defendant Fynche William husbandman 595278 595278 Fynche, William, of Horndon, husbandman 0
4947871 2341316 2341316 defendant Brenley or Breuley John yeoman 595278 595278 Brenley or Breuley, John, of Horndon, yeoman 0
4984795 2352383 2352383 defendant Salman John husbandman 595278 595278 Salman, John, of Horndon, husbandman 0
4997824 2356206 2356206 plaintiff Horndon John   595278 595278 Horndon, John, of Horndon 0
5000723 2357087 2357087 defendant Cok John smith 595278 595278 Cok, John, of Horndon, smith 1
5000724 2357087 2357087 defendant Houton Thomas barber 595278 595278 Houton, Thomas, of Horndon, barber 2
5000728 2357088 2357088 defendant Cok John smith 595278 595278 Cok, John, of Horndon, smith 1
5009780 2359740 2359740 defendant Spencer John yeoman 595278 595278 Spencer, John, of Horndon, yeoman 0
5009785 2359741 2359741 defendant Spencer John yeoman 595278 595278 Spencer, John, of Horndon, yeoman 0
5014191 2361001 2361001 defendant Spencer John yeoman 595278 595278 Spencer, John, of Horndon, yeoman 2
5107520 2388629 2388629 defendant Cok John smith 595278 595278 Cok, John, of Horndon, smith 0
5107522 2388629 2388629 defendant Cok Lawrence smith 595278 595278 Cok, Lawrence, of Horndon, smith 2
5108019 2388784 2388784 defendant Vyncent John   595278 595278 Vyncent, John, of Horndon, or of Dounton, "hierd" or herdsman 0
5108021 2388785 2388785 defendant Vyncent John   595278 595278 Vyncent, John, of Horndon, or of Dounton, "hierd" 0
5123651 2393376 2393376 defendant Bate John smith 595278 595278 Bate, John, of Horndon, smith 0
5128675 2394870 2394870 defendant Blunte John laborer 595278 595278 Blunte, John, of Horndon, laborer 5
5147824 2400506 2400506 defendant Damyon William husbandman 595278 595278 Damyon, William, of Horndon, husbandman 3
5161049 2404334 2404334 defendant Cok John smith 595278 595278 Cok, John, of Horndon, smith 3
5174732 2408310 2408310 defendant Cok John smith 595278 595278 Cok, John, of Horndon, smith 3
5182839 2410733 2410733 defendant Blunte John laborer 595278 595278 Blunte, John, of Horndon, laborer 2
5233894 2425499 2425499 defendant Gale Thomas clerk 595278 595278 Gale, Thomas, of Horndon, clerk 0
5254810 2431621 2431621 defendant Gybbe John husbandman 595278 595278 Gybbe, John, of Horndon, husbandman 2
5300884 2445225 2445225 defendant Salmon John laborer 595278 595278 Salmon, John, of Horndon, laborer 3
5315545 2449716 2449716 defendant Wodehille Robert butcher 595278 595278 Wodehille, Robert, of Horndon, butcher 0
5338244 2456529 2456529 defendant Thomas John clerk 595278 595278 Thomas, John, of Horndon, clerk 0
5338246 2456530 2456530 defendant Thomas John clerk 595278 595278 Thomas, John, of Horndon, clerk 0
5340645 2457276 2457276 defendant Janyn John smith 595278 595278 Janyn, John, of Horndon, smith 0
5625546 2551933 2551933 defendant Dudeley John yeoman 595278 595278 Dudeley, John, of Horndon, yeoman 1
5633391 2554438 2554438 defendant Sherman John, senior husbandman 595278 595278 Sherman, John, senior, of Horndon, husbandman 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);