names

116 rows where place_id = 627401

✎ 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
3776041 1950251 1950251 defendant Crosseland Alan butcher 627401 627401 Crosseland, Alan, of Chestrefeld, butcher 0
4422175 2171805 2171805 plaintiff Durant Robert   627401 627401 Durant, Robert, of Chestrefeld 0
4422176 2171805 2171805 defendant Wayser Robert   627401 627401 Wayser, Robert, of Chestrefeld, son of Robert 0
4445085 2183436 2183436 plaintiff Coteneye William   627401 627401 Coteneye, William, of Chestrefeld 0
4449243 2184713 2184713 defendant Godechepe William   627401 627401 Godechepe, William, of Chestrefeld 1
4451206 2185336 2185336 plaintiff Hervy Roger   627401 627401 Hervy, Roger, of Chestrefeld 0
4451208 2185337 2185337 plaintiff Hervy Roger   627401 627401 Hervy, Roger, of Chestrefeld 0
4468081 2190689 2190689 plaintiff Barley John   627401 627401 Barley, John, of Chestrefeld, on his own account 0
4470510 2191422 2191422 plaintiff Broun John   627401 627401 Broun, John, of Chestrefeld 0
4479023 2194100 2194100 plaintiff Barley John de   627401 627401 Barley, John de, of Chestrefeld 3
4487108 2196692 2196692 defendant Maunsfeld Henry de   627401 627401 Maunsfeld, Henry de, of Chestrefeld 0
4494496 2198971 2198971 plaintiff Bover Henry   627401 627401 Bover, Henry, of Chestrefeld 0
4496043 2199440 2199440 defendant Sagher William   627401 627401 Sagher, William, of Chestrefeld 2
4497511 2199865 2199865 plaintiff Draper Hugh   627401 627401 Draper, Hugh, of Chestrefeld 0
4497515 2199866 2199866 plaintiff Draper Hugh   627401 627401 Draper, Hugh, of Chestrefeld 0
4497593 2199893 2199893 defendant Dondeson or Doudeson Robert   627401 627401 Dondeson or Doudeson, Robert, of Chestrefeld 1
4498793 2200255 2200255 defendant Derton William de   627401 627401 Derton, William de, of Chestrefeld 0
4501372 2201036 2201036 defendant Coterl Philip   627401 627401 Coterl, Philip, of Chestrefeld 1
4502946 2201491 2201491 defendant Baret Richard   627401 627401 Baret, Richard, of Chestrefeld 0
4502948 2201492 2201492 defendant Baret Richard   627401 627401 Baret, Richard, of Chestrefeld 0
4503656 2201718 2201718 plaintiff Pogter Richard   627401 627401 Pogter, Richard, of Chestrefeld, vicar 0
4503785 2201747 2201747 plaintiff Porter Richard   627401 627401 Porter, Richard, of Chestrefeld, vicar 0
4503787 2201748 2201748 plaintiff Porter Richard   627401 627401 Porter, Richard, of Chestrefeld, vicar 0
4518862 2206265 2206265 plaintiff Draper Robert   627401 627401 Draper, Robert, of Chestrefeld 0
4518863 2206265 2206265 defendant Poklyngton Roger   627401 627401 Poklyngton, Roger, of Chestrefeld 0
4527605 2208912 2208912 defendant Nettelworth Roger   627401 627401 Nettelworth, Roger, of Chestrefeld 0
4530206 2209738 2209738 plaintiff Normanton John de   627401 627401 Normanton, John de, of Chestrefeld 0
4544227 2214112 2214112 defendant Maweber John   627401 627401 Maweber, John, of Chestrefeld 4
4544553 2214211 2214211 plaintiff Bawekewell Roger   627401 627401 Bawekewell, Roger, of Chestrefeld 0
4547515 2215154 2215154 plaintiff Calale John   627401 627401 Calale, John, of Chestrefeld 0
4550576 2216124 2216124 defendant Pees Roger   627401 627401 Pees, Roger, of Chestrefeld 0
4551226 2216324 2216324 defendant Tekell John   627401 627401 Tekell, John, of Chestrefeld 0
4551227 2216325 2216325 plaintiff Drapure Hugh   627401 627401 Drapure, Hugh, of Chestrefeld 0
4557038 2218127 2218127 defendant Nettilworth Roger   627401 627401 Nettilworth, Roger, of Chestrefeld 0
4557040 2218128 2218128 defendant Nettilworth Roger   627401 627401 Nettilworth, Roger, of Chestrefeld 0
4564152 2220360 2220360 plaintiff Sadeler Adam   627401 627401 Sadeler, Adam, of Chestrefeld 0
4605662 2232891 2232891 plaintiff Assheburn John de draper 627401 627401 Assheburn, John de, of Chestrefeld, draper 0
4615861 2235952 2235952 defendant Brampton William   627401 627401 Brampton, William, of Chestrefeld 0
4615862 2235952 2235952 defendant Coke Richard   627401 627401 Coke, Richard, of Chestrefeld 1
4619964 2237225 2237225 defendant Jordane John   627401 627401 Jordane, John, of Chestrefeld 0
4620259 2237319 2237319 defendant Baxster John   627401 627401 Baxster, John, of Chestrefeld 0
4620884 2237512 2237512 defendant Coke William   627401 627401 Coke, William, of Chestrefeld 0
4620886 2237512 2237512 defendant Coke Richard   627401 627401 Coke, Richard, of Chestrefeld 2
4620887 2237512 2237512 defendant Nayler Peter   627401 627401 Nayler, Peter, of Chestrefeld 3
4620889 2237512 2237512 defendant Grenelef William   627401 627401 Grenelef, William, of Chestrefeld 5
4624012 2238490 2238490 defendant Draper Hugh (legal representative) 627401 627401 Draper, Hugh, of Chestrefeld, executors of 0
4624013 2238490 2238490 defendant Brampton William   627401 627401 (Brampton, William, of Chestrefeld 1
4624014 2238490 2238490 defendant Coke Richard   627401 627401 Coke, Richard, of Chestrefeld 2
4631271 2240676 2240676 defendant Wygley Thomas   627401 627401 Wygley, Thomas, of Chestrefeld 0
4631399 2240711 2240711 defendant Pekelyngton Roger   627401 627401 Pekelyngton, Roger, of Chestrefeld 0
4634183 2241536 2241536 defendant Cuk Thomas   627401 627401 Cuk, Thomas, of Chestrefeld 1
4651177 2246373 2246373 defendant Fyssher Adam ironmonger 627401 627401 Fyssher, Adam, of Chestrefeld, ironmonger 3
4652922 2246845 2246845 defendant Brigg Thomas yeoman 627401 627401 Brigg, Thomas, of Chestrefeld, yeoman 0
4653221 2246944 2246944 defendant Porter William sherman 627401 627401 Porter, William, of Chestrefeld, sherman 0
4654507 2247286 2247286 plaintiff Boler Roger   627401 627401 Boler, Roger, of Chestrefeld 0
4656793 2248020 2248020 defendant Sawer William   627401 627401 Sawer, William, of Chestrefeld 0
4658060 2248399 2248399 plaintiff Cook Richard   627401 627401 Cook, Richard, of Chestrefeld 0
4660704 2249170 2249170 defendant Fleccher Richard fletcher 627401 627401 Fleccher, Richard, of Chestrefeld, fletcher 0
4662580 2249765 2249765 defendant Portar William clerk 627401 627401 Portar, William, of Chestrefeld, clerk 0
4668602 2255890 2255890 defendant Watson Robert collier 627401 627401 Watson, Robert, of Chestrefeld, collier 0
4668603 2255890 2255890 defendant Herm Henry husbandman 627401 627401 Herm, Henry, of Chestrefeld, husbandman 1
4674690 2257693 2257693 defendant Aleyn Thomas sheerman 627401 627401 Aleyn, Thomas, of Chestrefeld, sheerman 0
4679462 2259193 2259193 defendant Milner John milner 627401 627401 Milner, John, of Chestrefeld, milner 0
4689490 2262269 2262269 defendant Boler Roger yeoman 627401 627401 Boler, Roger, of Chestrefeld, yeoman 0
4700831 2265659 2265659 defendant Porter Katherine widow 627401 627401 Porter, Katherine, of Chestrefeld, widow 0
4725001 2273114 2273114 defendant Milner John   627401 627401 Milner, John, of Chestrefeld, knight 0
4725004 2273115 2273115 defendant Halghton John tailor 627401 627401 Halghton, John, of Chestrefeld, tailor 0
4777765 2289040 2289040 plaintiff Baret Thomas   627401 627401 Baret, Thomas, of Chestrefeld 0
4777767 2289041 2289041 plaintiff Baret Thomas   627401 627401 Baret, Thomas, of Chestrefeld 0
4777771 2289041 2289041 defendant Walkeden Richard clerk 627401 627401 Walkeden, Richard, of Chestrefeld, clerk 2
4790809 2293215 2293215 plaintiff Leche John   627401 627401 Leche, John, of Chestrefeld 0
4791530 2293446 2293446 defendant Boure Thurstan (legal representative) 627401 627401 Boure, Thurstan, of Chestrefeld, gent, executors of 0
4791532 2293446 2293446 defendant Walkedon Richard chaplain 627401 627401 Walkedon, Richard, of Chestrefeld, chaplain 2
4791553 2293450 2293450 defendant Whitecroft Adam husbandman 627401 627401 Whitecroft, Adam, of Chestrefeld, husbandman 5
4796122 2294942 2294942 defendant Cutteler William cutler 627401 627401 Cutteler, William, of Chestrefeld, cutler 3
4801020 2296508 2296508 defendant Milner John miller 627401 627401 Milner, John, of Chestrefeld, miller 0
4820305 2302421 2302421 defendant Hanley John husbandman 627401 627401 Hanley, John, of Chestrefeld, husbandman 0
4868226 2317040 2317040 defendant Pote Robert cordwainer 627401 627401 Pote, Robert, of Chestrefeld, cordwainer 0
4882258 2321358 2321358 defendant Lovecok Thomas   627401 627401 Lovecok, Thomas, of Chestrefeld, scythe smith 0
4905297 2328251 2328251 defendant Hwegate or Howegate Thomas mercer 627401 627401 Hwegate or Howegate, Thomas, of Chestrefeld, mercer 0
4905298 2328251 2328251 defendant Taylour John tailor 627401 627401 Taylour, John, of Chestrefeld, tailor 1
4905299 2328251 2328251 defendant Goule or Gowele Thomas mercer 627401 627401 Goule or Gowele, Thomas, of Chestrefeld, mercer 2
4905300 2328251 2328251 defendant Schyrfote Robert yeoman 627401 627401 Schyrfote, Robert, of Chestrefeld, yeoman 3
4917165 2331875 2331875 defendant Grenelef John chapman 627401 627401 Grenelef, John, of Chestrefeld, chapman 1
4927570 2335058 2335058 defendant Calall or Odlall William husbandman 627401 627401 Calall or Odlall, William, of Chestrefeld, husbandman 6
4941671 2339417 2339417 defendant Grenelefe John chapman 627401 627401 Grenelefe, John, of Chestrefeld, chapman 0
4941672 2339417 2339417 defendant Lawecok Thomas   627401 627401 Lawecok, Thomas, of Chestrefeld, scythe smith 1
4945678 2340629 2340629 defendant Grenelef John merchant 627401 627401 Grenelef, John, of Chestrefeld, merchant 0
4949044 2341689 2341689 defendant Tydeswell Thomas panyerman 627401 627401 Tydeswell, Thomas, of Chestrefeld, panyerman 1
4949045 2341690 2341690 plaintiff Moldson John   627401 627401 Moldson, John, of Chestrefeld 0
4952776 2342788 2342788 defendant Gurry Walter yeoman 627401 627401 Gurry, Walter, of Chestrefeld, yeoman 0
4954503 2343312 2343312 defendant Rotour John cordwaineer 627401 627401 Rotour, John, of Chestrefeld, cordwaineer 3
4963511 2345999 2345999 plaintiff Carr Richard, senior   627401 627401 Carr, Richard, senior, of Chestrefeld 0
4965712 2346670 2346670 defendant Lynacre William gent 627401 627401 Lynacre, William, of Chestrefeld, gent 0
4973633 2349066 2349066 defendant Litster John dyer 627401 627401 Litster, John, of Chestrefeld, dyer 2
4990170 2353967 2353967 plaintiff Carre Richard, sen yeoman 627401 627401 Carre, Richard, sen, of Chestrefeld, yeoman 0
5005899 2358626 2358626 defendant Stanlowe Thomas baker 627401 627401 Stanlowe, Thomas, of Chestrefeld, baker 4
5005926 2358636 2358636 defendant Bolsore Richard laborer 627401 627401 Bolsore, Richard, of Chestrefeld, laborer 1
5005927 2358636 2358636 defendant Clerk Thomas   627401 627401 Clerk, Thomas, of Chestrefeld, rope maker 2
5019044 2362461 2362461 defendant Swalowe Thomas yeoman 627401 627401 Swalowe, Thomas, of Chestrefeld, yeoman 1

Next page

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);