names

98 rows where place_id = 588182

✎ 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
3593650 1865647 1865647 defendant Cosyn Thomas laborer 588182 588182 Cosyn, Thomas, of Stapilherst, laborer 0
3604033 1868927 1868927 defendant Perot John husbandman 588182 588182 Perot, John, of Stapilherst, husbandman 0
3604920 1869205 1869205 plaintiff Herenden John   588182 588182 Herenden, John, of Stapilherst 0
3614841 1872294 1872294 defendant Hershet John, senior yeoman 588182 588182 Hershet, John, senior, of Stapilherst, yeoman 0
3620785 1874073 1874073 defendant Atcok William clothman 588182 588182 Atcok, William, of Stapilherst, clothman 0
3621844 1874372 1874372 defendant Adcoke William clothier 588182 588182 Adcoke, William, of Stapilherst, clothier 2
3621919 1874398 1874398 defendant Southlond Robert yeoman 588182 588182 Southlond, Robert, of Stapilherst, yeoman 0
3631465 1904654 1904654 defendant Marden James yeoman 588182 588182 Marden, James, of Stapilherst, yeoman 0
3631466 1904654 1904654 defendant Breseland John tanner 588182 588182 Breseland, John, of Stapilherst, tanner 1
3638206 1906768 1906768 defendant Kyng James laborer 588182 588182 Kyng, James, of Stapilherst, laborer 0
3638333 1906806 1906806 defendant Kyng James butcher 588182 588182 Kyng, James, of Stapilherst, butcher 0
3640638 1907513 1907513 defendant Girdeler John fuller 588182 588182 Girdeler, John, of Stapilherst, fuller 0
3640640 1907513 1907513 defendant Nelethorpe Christopher laborer 588182 588182 Nelethorpe, Christopher, of Stapilherst, laborer 2
3656379 1912241 1912241 defendant Langley William yeoman 588182 588182 Langley, William, of Stapilherst, yeoman 1
3698739 1925821 1925821 defendant Batherst Thomas clothmaker 588182 588182 Batherst, Thomas, of Stapilherst, clothmaker 0
3712332 1930174 1930174 defendant Batherst Thomas clothmaker 588182 588182 Batherst, Thomas, of Stapilherst, clothmaker 0
4438423 2181307 2181307 defendant Foleherth John   588182 588182 Foleherth, John, of Stapilherst 6
4500850 2200885 2200885 defendant Corne Thomas   588182 588182 Corne, Thomas, of Stapilherst 0
4618800 2236878 2236878 defendant Hamme William   588182 588182 Hamme, William, of Stapilherst 3
4657367 2248195 2248195 defendant Knocke William husbandman 588182 588182 Knocke, William, of Stapilherst, husbandman 1
4664426 2250353 2250353 defendant Larke John carter 588182 588182 Larke, John, of Stapilherst, carter 1
4664428 2250354 2250354 plaintiff atte Frythe Thomas   588182 588182 atte Frythe, Thomas, of Stapilherst 1
4685250 2260983 2260983 defendant Somery John esq 588182 588182 Somery, John, of Stapilherst, esq 0
4685251 2260983 2260983 defendant Turbut James tailor 588182 588182 Turbut, James, of Stapilherst, tailor 1
4686168 2261269 2261269 defendant Larke John, junior carter 588182 588182 Larke, John, junior, of Stapilherst, carter 0
4686701 2261453 2261453 defendant Becheman John   588182 588182 Becheman, John, of Stapilherst 0
4702787 2266271 2266271 defendant Jolyf William   588182 588182 Jolyf, William, of Stapilherst, lattthe or lather maker 0
4711104 2268827 2268827 defendant Somery John esq 588182 588182 Somery, John, of Stapilherst, esq 0
4744469 2278903 2278903 defendant Norton Stephen husbandman 588182 588182 Norton, Stephen, of Stapilherst, husbandman 0
4746372 2279437 2279437 defendant Nowell William sawyer 588182 588182 Nowell, William, of Stapilherst, sawyer 0
4746373 2279437 2279437 defendant Esillynden William latther 588182 588182 Esillynden, William, of Stapilherst, latther 1
4785180 2291380 2291380 defendant Norton Stephen husbandman 588182 588182 Norton, Stephen, of Stapilherst, husbandman 0
4805009 2297773 2297773 defendant Cobbeham William esq 588182 588182 Cobbeham, William, of Stapilherst, esq 0
4876687 2319679 2319679 defendant Sare William laborer 588182 588182 Sare, William, of Stapilherst, laborer 1
4876688 2319679 2319679 defendant Stevene Thomas thatcher 588182 588182 Stevene, Thomas, of Stapilherst, thatcher 2
4957125 2344090 2344090 defendant Chirche John husbandman 588182 588182 Chirche, John, of Stapilherst, husbandman 0
4957128 2344090 2344090 defendant Herpynnope Simon husbandman 588182 588182 Herpynnope, Simon, of Stapilherst, husbandman 3
4961052 2345267 2345267 defendant Elys James husbandman 588182 588182 Elys, James, of Stapilherst, husbandman 0
4975775 2349719 2349719 defendant Moys John carpenter 588182 588182 Moys, John, of Stapilherst, carpenter 0
4997564 2356123 2356123 defendant Moys John carpenter 588182 588182 Moys, John, of Stapilherst, carpenter 2
5054013 2372792 2372792 defendant Hershete James husbandman 588182 588182 (Hershete, James, of Stapilherst, husbandman 1
5056899 2373638 2373638 defendant Harry Richard laborer 588182 588182 Harry, Richard, of Stapilherst, laborer 3
5056906 2373641 2373641 defendant Herstherte James husbandman 588182 588182 Herstherte, James, of Stapilherst, husbandman 0
5056907 2373641 2373641 defendant More William wheeler 588182 588182 More, William, of Stapilherst, wheeler 1
5069622 2377410 2377410 defendant atte Forde John husbandman 588182 588182 atte Forde, John, of Stapilherst, husbandman 1
5093543 2384510 2384510 defendant Chirche John yeoman 588182 588182 Chirche, John, of Stapilherst, yeoman 0
5118304 2391789 2391789 defendant Moys John carpenter 588182 588182 Moys, John, of Stapilherst, carpenter 0
5132594 2396029 2396029 defendant Chirche John husbandman 588182 588182 Chirche, John, of Stapilherst, husbandman 0
5258718 2432844 2432844 defendant Cook John laborer 588182 588182 Cook, John, of Stapilherst, laborer 0
5258720 2432845 2432845 defendant Cook John laborer 588182 588182 Cook, John, of Stapilherst, laborer 0
5258721 2432845 2432845 defendant Scorne John husbandman 588182 588182 together with Scorne, John, of Stapilherst, husbandman 1
5269409 2436148 2436148 defendant Borell William fuller 588182 588182 Borell, William, of Stapilherst, fuller 0
5285907 2440894 2440894 defendant Dey Roger sherman 588182 588182 Dey, Roger, of Stapilherst, sherman 0
5317035 2450170 2450170 defendant Hopper Robert, junior laborer 588182 588182 Hopper, Robert, junior, of Stapilherst, laborer 1
5330468 2454194 2454194 defendant Goldham John husbandman 588182 588182 Goldham, John, of Stapilherst, husbandman 0
5330469 2454194 2454194 defendant Dey John husbandman 588182 588182 Dey, John, of Stapilherst, husbandman 1
5358736 2462793 2462793 defendant Borell William clothmaker 588182 588182 Borell, William, of Stapilherst, clothmaker 1
5365537 2464895 2464895 defendant Middelton John husbandman 588182 588182 Middelton, John, of Stapilherst, husbandman 0
5367362 2465448 2465448 defendant Hershert Alexander hsubandman 588182 588182 Hershert, Alexander, of Stapilherst, hsubandman 0
5373050 2467162 2467162 defendant Atcok William   588182 588182 Atcok, William, of Stapilherst, cloth maker 0
5383394 2470330 2470330 defendant Attok William clothmaker 588182 588182 Attok, William, of Stapilherst, clothmaker 0
5383451 2470348 2470348 defendant Atcok or Atook William clothmaker 588182 588182 Atcok or Atook, William, of Stapilherst, clothmaker 0
5385459 2470912 2470912 defendant Middelton John husbandman 588182 588182 Middelton, John, of Stapilherst, husbandman 0
5393712 2473263 2473263 defendant Atcok William clothmaker 588182 588182 Atcok, William, of Stapilherst, clothmaker 0
5401033 2475358 2475358 defendant (illegible) William   588182 588182 ---, William, of Stapilherst, cloth maker 0
5401560 2475516 2475516 plaintiff Ward Richard   588182 588182 Ward, Richard, of Stapilherst, 2
5406169 2476844 2476844 plaintiff Southlan Robert   588182 588182 Southlan, Robert, of Stapilherst 0
5410224 2478010 2478010 defendant Ilchynden William husbandman 588182 588182 Ilchynden, William, of Stapilherst, husbandman 1
5414596 2479303 2479303 plaintiff Herynden John gent 588182 588182 Herynden, John, of Stapilherst, gent 0
5416716 2479919 2479919 defendant (illegible) John husbandman 588182 588182 _, John, of Stapilherst, husbandman 0
5423962 2482120 2482120 defendant Ilchynden William husbandman 588182 588182 Ilchynden, William, of Stapilherst, husbandman 0
5427175 2483069 2483069 defendant Attok William clothmaker 588182 588182 Attok, William, of Stapilherst, clothmaker 1
5429152 2483647 2483647 plaintiff Goldham John husbandman 588182 588182 Goldham, John, of Stapilherst, husbandman 0
5430343 2484011 2484011 plaintiff Wanden Richard   588182 588182 Wanden, Richard, of Stapilherst 2
5444846 2488351 2488351 defendant Attok William clothmaker 588182 588182 Attok, William, of Stapilherst, clothmaker 1
5448845 2489548 2489548 defendant Partriche Stephen butcher 588182 588182 Partriche, Stephen, of Stapilherst, butcher 0
5448846 2489548 2489548 defendant Hopper Richard yeoman 588182 588182 Hopper, Richard, of Stapilherst, yeoman 1
5463743 2494073 2494073 plaintiff Southlond Robert   588182 588182 Southlond, Robert, of Stapilherst 0
5472742 2496816 2496816 defendant Partriche Stephen butcher 588182 588182 Partriche, Stephen, of Stapilherst, butcher 0
5472743 2496816 2496816 defendant Hopper Richard yeoman 588182 588182 Hopper, Richard, of Stapilherst, yeoman 1
5473088 2496909 2496909 defendant Southland Robert yeoman 588182 588182 Southland, Robert, of Stapilherst, yeoman 0
5473089 2496909 2496909 defendant Goldham John husbandman 588182 588182 Goldham, John, of Stapilherst, husbandman 1
5475328 2497611 2497611 plaintiff Southlond Robert   588182 588182 Southlond, Robert, of Stapilherst 0
5475330 2497612 2497612 plaintiff Southlond Robert   588182 588182 Southlond, Robert, of Stapilherst 0
5477413 2498260 2498260 defendant Atcok William clothmaker 588182 588182 Atcok, William, of Stapilherst, clothmaker 1
5478161 2498494 2498494 defendant Benet William laborer 588182 588182 Benet, William, of Stapilherst, laborer 0
5478798 2498676 2498676 defendant Ilchynden William yeoman 588182 588182 Ilchynden, William, of Stapilherst, yeoman 7
5478885 2498704 2498704 defendant Ilchynden William yeoman 588182 588182 Ilchynden, William, of Stapilherst, yeoman 2
5482912 2499832 2499832 defendant Ilchynden William clothmaker 588182 588182 Ilchynden, William, of Stapilherst, clothmaker 2
5486074 2500718 2500718 defendant William John husbandman 588182 588182 William, John, of Stapilherst, husbandman 3
5486836 2500964 2500964 plaintiff Southlond Robert   588182 588182 Southlond, Robert, of Stapilherst 0
5500091 2504981 2504981 defendant Suthland Robert yeoman 588182 588182 Suthland, Robert, of Stapilherst, yeoman 0
5508956 2507656 2507656 defendant Southland Robert yeoman 588182 588182 Southland, Robert, of Stapilherst, yeoman 0
5568164 2525236 2525236 defendant Feraff Stephen yeoman 588182 588182 Feraff, Stephen, of Stapilherst, yeoman 1
5592031 2532497 2532497 plaintiff Usbarne Thomas tanner 588182 588182 Usbarne, Thomas, of Stapilherst, tanner 0
5609128 2537760 2537760 defendant Adcok William clothmaker 588182 588182 Adcok, William, of Stapilherst, clothmaker 2
5625602 2551948 2551948 plaintiff Mapelysden Thomas   588182 588182 Mapelysden, Thomas, of Stapilherst 0
5633540 2554487 2554487 defendant Middelton Nicholas chaplain 588182 588182 Middelton, Nicholas, of Stapilherst, chaplain 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);