names

73 rows where place_id = 759202

✎ 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
4459841 2188131 2188131 defendant Jecob John turner 759202 759202 Jecob, John, of Felstede, turner 2
4464211 2189478 2189478 defendant Shepherd Alexander   759202 759202 Shepherd, Alexander, of Felstede 2
4470115 2191304 2191304 plaintiff Bray John   759202 759202 Bray, John, of Felstede 0
4470116 2191304 2191304 defendant Edwyne Richard   759202 759202 Edwyne, Richard, of Felstede 0
4474957 2192835 2192835 plaintiff Edwyn William carpenter 759202 759202 Edwyn, William, of Felstede, carpenter 0
4495919 2199402 2199402 defendant Bochere John   759202 759202 Bochere, John, of Felstede 5
4505451 2202234 2202234 defendant Prat Richard   759202 759202 Prat, Richard, of Felstede 0
4506633 2202554 2202554 defendant Archer John butcher 759202 759202 Archer, John, of Felstede, butcher 0
4516053 2205435 2205435 defendant atte Bregge Robert   759202 759202 atte Bregge, Robert, of Felstede 0
4527055 2208741 2208741 defendant Herde John   759202 759202 Herde, John, of Felstede, son of Gilbert, of Great Waltham 0
4532502 2210432 2210432 defendant Archer John   759202 759202 Archer, John, of Felstede 1
4532508 2210433 2210433 defendant Archer John   759202 759202 Archer, John, of Felstede 1
4532514 2210434 2210434 defendant Archer John   759202 759202 Archer, John, of Felstede 1
4540514 2212929 2212929 defendant Reyne John butcher 759202 759202 Reyne, John, of Felstede, butcher 0
4551175 2216309 2216309 defendant Prentys John   759202 759202 Prentys, John, of Felstede 0
4551177 2216310 2216310 defendant Prentys John   759202 759202 Prentys, John, of Felstede 0
4554301 2217272 2217272 defendant Kent John   759202 759202 Kent, John, of Felstede 2
4583775 2226341 2226341 defendant Cook Thomas   759202 759202 Cook, Thomas, of Felstede 2
4586143 2227088 2227088 defendant Riche Simon   759202 759202 Riche, Simon, of Felstede 2
4586214 2227112 2227112 defendant Archer John   759202 759202 Archer, John, of Felstede 0
4587831 2227597 2227597 defendant Wymbyssh Andrew   759202 759202 Wymbyssh, Andrew, of Felstede 0
4604973 2232716 2232716 defendant Lakford Geoffrey   759202 759202 Lakford, Geoffrey, of Felstede 1
4628723 2239909 2239909 defendant Rout Simon   759202 759202 Rout, Simon, of Felstede 0
4633184 2241247 2241247 defendant Smyth John   759202 759202 Smyth, John, of Felstede, execuctor of 3
4633185 2241247 2241247 defendant Bregge Robert   759202 759202 Bregge, Robert, of Felstede 4
4633186 2241247 2241247 defendant Clement Stephen (legal representative) 759202 759202 Clement, Stephen, of Felstede, executor of 5
4658069 2248403 2248403 plaintiff Cook Thomas   759202 759202 Cook, Thomas, of Felstede 0
4658071 2248403 2248403 defendant Lakford Geoffrey cordwainer 759202 759202 Lakford, Geoffrey, of Felstede, cordwainer 0
4660942 2249247 2249247 defendant Gravele John carter 759202 759202 Gravele, John, of Felstede, carter 3
4665036 2250543 2250543 defendant Kent John fuller 759202 759202 Kent, John, of Felstede, fuller 0
4665040 2250544 2250544 defendant Kent John fuller 759202 759202 Kent, John, of Felstede, fuller 0
4686530 2261394 2261394 defendant Kent John yeoman 759202 759202 Kent, John, of Felstede, yeoman 2
4689808 2262373 2262373 defendant Lalford Geoffrey shoemaker 759202 759202 Lalford, Geoffrey, of Felstede, shoemaker 1
4696845 2264492 2264492 defendant Edwyn Richard husbandman 759202 759202 Edwyn, Richard, of Felstede, husbandman 0
4715495 2270183 2270183 plaintiff Frenssh Richard   759202 759202 Frenssh, Richard, of Felstede 4
4715506 2270184 2270184 plaintiff French Richard   759202 759202 French, Richard, of Felstede 4
4715516 2270185 2270185 plaintiff French Richard   759202 759202 French, Richard, of Felstede 4
4718552 2271140 2271140 defendant Swetyng John tailor 759202 759202 Swetyng, John, of Felstede, tailor 0
4718554 2271141 2271141 defendant Swetyng John tailor 759202 759202 Swetyng, John, of Felstede, tailor 0
4725783 2273351 2273351 defendant Archer John husbandman 759202 759202 Archer, John, of Felstede, husbandman 4
4737515 2276846 2276846 defendant Kent John husbandman 759202 759202 Kent, John, of Felstede, husbandman 2
4754880 2281905 2281905 defendant Whe_ William yeoman 759202 759202 Whe_, William, of Felstede, yeoman 0
4770892 2286874 2286874 defendant Wheler John   759202 759202 Wheler, John, of Felstede, wheel wright 2
4770893 2286874 2286874 defendant Spencer Richard   759202 759202 together with Spencer, Richard, of Felstede, plough man 3
4772974 2287520 2287520 plaintiff Streyt John   759202 759202 Streyt, John, of Felstede 0
4774648 2288058 2288058 defendant Kent John   759202 759202 Kent, John, of Felstede, wool man 0
4787023 2292005 2292005 defendant Kent John yeoman 759202 759202 Kent, John, of Felstede, yeoman 0
4790547 2293134 2293134 defendant Dagenet John husbandman 759202 759202 Dagenet, John, of Felstede, or of Black Nottele, husbandman 0
4795721 2294812 2294812 defendant Whelere John wheeler 759202 759202 Whelere, John, of Felstede, wheeler 1
4795722 2294812 2294812 defendant Sponer Richard ploughman 759202 759202 together with Sponer, Richard, of Felstede, ploughman 2
4813733 2300405 2300405 defendant Hawekyn William yeoman 759202 759202 Hawekyn, William, of Felstede, yeoman 0
4894232 2324882 2324882 defendant Frere John husbandman 759202 759202 Frere, John, of Felstede, husbandman 0
4894233 2324882 2324882 defendant Cavyll John smith 759202 759202 Cavyll, John, of Felstede, smith 1
4895520 2325266 2325266 defendant Vykeers John yeoman 759202 759202 Vykeers, John, of Felstede, yeoman 3
4985408 2352557 2352557 defendant Rothyng Richard husbandman 759202 759202 Rothyng, Richard, of Felstede, husbandman 2
5005263 2358438 2358438 defendant Haukyn William husbandman 759202 759202 Haukyn, William, of Felstede, husbandman 0
5009711 2359722 2359722 defendant Cavyll John husbandman 759202 759202 Cavyll, John, of Felstede, husbandman 0
5064444 2375906 2375906 defendant Chalke Thomas yeoman 759202 759202 Chalke, Thomas, of Felstede, yeoman 1
5064445 2375906 2375906 defendant Brigge Roger husbandman 759202 759202 Brigge, Roger, of Felstede, husbandman 2
5089502 2383301 2383301 defendant Eye or Gye John husbandman 759202 759202 Eye or Gye, John, of Felstede, husbandman 0
5220403 2421663 2421663 defendant Hose Roger clerk 759202 759202 Hose, Roger, of Felstede, clerk 0
5220405 2421664 2421664 defendant Hose Roger clerk 759202 759202 Hose, Roger, of Felstede, clerk 0
5252451 2430877 2430877 defendant Alberd John husbandman 759202 759202 Alberd, John, of Felstede, husbandman 0
5254290 2431469 2431469 defendant Sponer John husbandman 759202 759202 Sponer, John, of Felstede, husbandman 6
5276272 2438130 2438130 defendant Bury John gent 759202 759202 Bury, John, of Felstede, gent 0
5296612 2443996 2443996 defendant Holmestede Richard   759202 759202 Holmestede, Richard, of Felstede, yeoman, administrtrix of 1
5393697 2473258 2473258 defendant Wode John husbandman 759202 759202 (Wode, John, of Felstede, husbandman 1
5420034 2480909 2480909 defendant Wode John husbandman 759202 759202 (Wode, John, of Felstede, husbandman 1
5475420 2497646 2497646 defendant Bery Robert gent 759202 759202 Bery, Robert, of Felstede, gent 1
5492954 2502799 2502799 defendant Wolmer Joan widow 759202 759202 Wolmer, Joan, of Felstede, widow 1
5535531 2515640 2515640 defendant Feste Thomas clothman 759202 759202 Feste, Thomas, of Felstede, clothman 0
5618459 2549595 2549595 defendant Twynere John   759202 759202 Twynere, John, of Felstede 0
5634305 2554718 2554718 defendant Kent John yeoman 759202 759202 Kent, John, of Felstede, 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);