names

100 rows where place_id = 759963

✎ 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
4465902 2190003 2190003 defendant Clerk John   759963 759963 Clerk, John, of Lodne 0
4477519 2193637 2193637 defendant Brundale Isabel   759963 759963 Brundale, Isabel, of Lodne, formerly wife of John 3
4495601 2199306 2199306 defendant Peper John   759963 759963 Peper, John, of Lodne 0
4499609 2200519 2200519 defendant Bygat Richard   759963 759963 Bygat, Richard, of Lodne 2
4502660 2201414 2201414 defendant Peper John   759963 759963 Peper, John, of Lodne 0
4513526 2204655 2204655 defendant Vyncent Thomas   759963 759963 Vyncent, Thomas, of Lodne 0
4513527 2204655 2204655 defendant Vynns Robert   759963 759963 Vynns, Robert, of Lodne 1
4523884 2207803 2207803 defendant Pepir John   759963 759963 Pepir, John, of Lodne 0
4545753 2214598 2214598 defendant Pope Robert   759963 759963 Pope, Robert, of Lodne 0
4547836 2215260 2215260 defendant Vyncent Thomas   759963 759963 Vyncent, Thomas, of Lodne 5
4555644 2217693 2217693 defendant Pepir John   759963 759963 Pepir, John, of Lodne 0
4555646 2217694 2217694 defendant Pepir john   759963 759963 Pepir, john, of Lodne 0
4569914 2222159 2222159 defendant Skeet John baker 759963 759963 Skeet, John, of Lodne, baker 0
4570795 2222437 2222437 defendant Pepyr John   759963 759963 Pepyr, John, of Lodne 0
4573475 2223231 2223231 defendant Hosyere Henry   759963 759963 Hosyere, Henry, of Lodne 3
4575275 2223783 2223783 defendant Bygot Richard   759963 759963 Bygot, Richard, of Lodne 0
4587157 2227388 2227388 plaintiff Hosyere Henry   759963 759963 Hosyere, Henry, of Lodne 0
4587688 2227555 2227555 defendant Bygot Richard   759963 759963 Bygot, Richard, of Lodne 0
4587689 2227555 2227555 defendant Vynne Ralph   759963 759963 Vynne, Ralph, of Lodne 1
4608717 2233831 2233831 defendant Kippyng Thomas   759963 759963 Kippyng, Thomas, of Lodne 3
4609279 2234004 2234004 defendant Cokefeelde Thomas   759963 759963 Cokefeelde, Thomas, of Lodne 3
4617895 2236598 2236598 defendant Dyn Hernem   759963 759963 Dyn, Hernem, of Lodne 2
4618979 2236929 2236929 defendant Multon Robert miller 759963 759963 Multon, Robert, of Lodne, miller 0
4624725 2238714 2238714 defendant Brid William   759963 759963 Brid, William, of Lodne 3
4639125 2242960 2242960 defendant Cokefeld Thomas   759963 759963 Cokefeld, Thomas, of Lodne 0
4644241 2244411 2244411 defendant Skeet John   759963 759963 Skeet, John, of Lodne 2
4644244 2244411 2244411 defendant Ederych John   759963 759963 Ederych, John, of Lodne 5
4657614 2248274 2248274 defendant Adames John husbandman 759963 759963 Adames, John, of Lodne, husbandman 0
4672230 2256962 2256962 defendant But Mathew tailor 759963 759963 But, Mathew, of Lodne, tailor 1
4687828 2261761 2261761 defendant Peyntour John yeoman 759963 759963 Peyntour, John, of Lodne, yeoman 3
4691777 2262960 2262960 defendant Yorke Thomas fuller 759963 759963 Yorke, Thomas, of Lodne, fuller 0
4691778 2262960 2262960 defendant Bolitoute John baker 759963 759963 Bolitoute, John, of Lodne, baker 1
4696725 2264452 2264452 defendant Barker Reginald husbandman 759963 759963 Barker, Reginald, of Lodne, husbandman 0
4696726 2264452 2264452 defendant Skeet John (legal representative) 759963 759963 Skeet, John, of Lodne, executrix of 1
4708885 2268145 2268145 defendant Hosyere Henry husbandman 759963 759963 Hosyere, Henry, of Lodne, husbandman 0
4718301 2271062 2271062 plaintiff Bacon John   759963 759963 Bacon, John, of Lodne 0
4720478 2271741 2271741 defendant Vynne Robert yeoman 759963 759963 Vynne, Robert, of Lodne, yeoman 0
4720479 2271741 2271741 defendant Vynne John yeoman 759963 759963 Vynne, John, of Lodne, yeoman 1
4720922 2271877 2271877 defendant Aleyn John husbandman 759963 759963 Aleyn, John, of Lodne, husbandman 0
4721355 2272010 2272010 defendant Cokefeld Thomas husbandman 759963 759963 Cokefeld, Thomas, of Lodne, husbandman 2
4721955 2272197 2272197 defendant Bolitent Rose widow 759963 759963 Bolitent, Rose, of Lodne, widow 2
4722467 2272345 2272345 defendant Peyntoure John butcher 759963 759963 Peyntoure, John, of Lodne, butcher 5
4723037 2272515 2272515 defendant Peyntour John butcher 759963 759963 Peyntour, John, of Lodne, butcher 1
4726133 2273461 2273461 defendant Wolgate John husbandman 759963 759963 Wolgate, John, of Lodne, husbandman 0
4726294 2273507 2273507 defendant Cokefeld Thomas yeoman 759963 759963 Cokefeld, Thomas, of Lodne, yeoman 3
4727925 2273976 2273976 defendant Wodcok Oliver husbandman 759963 759963 Wodcok, Oliver, of Lodne, husbandman 1
4737667 2276889 2276889 defendant But Richard yeoman 759963 759963 But, Richard, of Lodne, yeoman 0
4737669 2276889 2276889 defendant Vynne Ralph butcher 759963 759963 Vynne, Ralph, of Lodne, butcher 2
4737671 2276889 2276889 defendant Lyster William   759963 759963 Lyster, William, of Lodne, shoe maker 4
4737672 2276889 2276889 defendant Trental Henry husbandman 759963 759963 Trental, Henry, of Lodne, husbandman 5
4738770 2277215 2277215 defendant Aleyn John yeoman 759963 759963 Aleyn, John, of Lodne, yeoman 0
4749282 2280270 2280270 defendant Fistolf John   759963 759963 Fistolf, John, of Lodne, bailiff 0
4758348 2282983 2282983 defendant Cokefeld Thomas husbandman 759963 759963 Cokefeld, Thomas, of Lodne, husbandman 4
4759781 2283395 2283395 defendant Fistolf John   759963 759963 Fistolf, John, of Lodne, bailiff 1
4759937 2283445 2283445 plaintiff Cokefeld Thomas   759963 759963 Cokefeld, Thomas, of Lodne 0
4761033 2283799 2283799 defendant Yorke Robert husbandman 759963 759963 Yorke, Robert, of Lodne, husbandman 0
4775921 2288472 2288472 defendant Honyng John husbandman 759963 759963 Honyng, John, of Lodne, husbandman 1
4782187 2290428 2290428 plaintiff Cokefeld Thomas   759963 759963 Cokefeld, Thomas, of Lodne 0
4782640 2290584 2290584 defendant Honyng John husbandman 759963 759963 Honyng, John, of Lodne, husbandman 2
4782641 2290584 2290584 defendant Wrighte Thomas husbandman 759963 759963 Wrighte, Thomas, of Lodne, husbandman 3
4785824 2291599 2291599 defendant Fystolf John   759963 759963 Fystolf, John, of Lodne, bailiff 4
4809785 2299223 2299223 defendant Vynne Alice widow 759963 759963 Vynne, Alice, of Lodne, widow 4
4809787 2299224 2299224 defendant Poyntour John yeoman 759963 759963 Poyntour, John, of Lodne, yeoman 0
4823837 2303537 2303537 defendant But Richard yeoman 759963 759963 But, Richard, of Lodne, yeoman 0
4823838 2303537 2303537 defendant Peyntour John butcher 759963 759963 Peyntour, John, of Lodne, butcher 1
4823839 2303537 2303537 defendant Vynna Ralph (legal representative) 759963 759963 Vynna, Ralph, of Lodne, executors of 2
4823840 2303537 2303537 defendant Dobbes John yeoman 759963 759963 (Dobbes, John, of Lodne, yeoman 3
4825770 2304096 2304096 plaintiff Vyncent Thomas   759963 759963 Vyncent, Thomas, of Lodne 0
4847415 2310695 2310695 defendant Dokkys John yeoman 759963 759963 Dokkys, John, of Lodne, yeoman 1
4868897 2317248 2317248 defendant Bettys Roger husbandman 759963 759963 Bettys, Roger, of Lodne, husbandman 0
4869534 2317438 2317438 defendant Vyncent Thomas yeoman 759963 759963 Vyncent, Thomas, of Lodne, yeoman 1
4873281 2318596 2318596 defendant Peyntour John butcher 759963 759963 Peyntour, John, of Lodne, butcher 1
4879752 2320589 2320589 plaintiff Vynne Ralph (legal representative) 759963 759963 Vynne, Ralph, of Lodne, executors of 0
4879986 2320654 2320654 defendant But Richard yeoman 759963 759963 But, Richard, of Lodne, yeoman 0
4888458 2323188 2323188 defendant Honyng John yeoman 759963 759963 Honyng, John, of Lodne, yeoman 3
4903646 2327756 2327756 defendant But Richard yeoman 759963 759963 But, Richard, of Lodne, yeoman 0
4905039 2328184 2328184 defendant Welgate John yeoman 759963 759963 Welgate, John, of Lodne, yeoman 0
4929501 2335643 2335643 defendant Snowe John   759963 759963 Snowe, John, of Lodne, wright 0
4982761 2351755 2351755 defendant Vynne Robert butcher 759963 759963 Vynne, Robert, of Lodne, butcher 2
4996889 2355926 2355926 defendant Baron John baker 759963 759963 Baron, John, of Lodne, baker 10
5002464 2357633 2357633 defendant Vynne John yeoman 759963 759963 Vynne, John, of Lodne, yeoman 3
5016606 2361750 2361750 defendant Foode John husbandman 759963 759963 Foode, John, of Lodne, husbandman 1
5040573 2368788 2368788 defendant Vynne John yeoman 759963 759963 Vynne, John, of Lodne, yeoman 6
5075619 2379206 2379206 defendant Barker John laborer 759963 759963 Barker, John, of Lodne, laborer 2
5085968 2382289 2382289 defendant Mossy William yeoman 759963 759963 Mossy, William, of Lodne, yeoman 0
5104231 2387660 2387660 defendant Mossy William yeoman 759963 759963 Mossy, William, of Lodne, yeoman 0
5160363 2404124 2404124 defendant Sowere John   759963 759963 Sowere, John, of Lodne, mason 0
5201514 2416201 2416201 defendant Hoppe Richard butcher 759963 759963 Hoppe, Richard, of Lodne, butcher 0
5214511 2419974 2419974 defendant Greystok John yeoman 759963 759963 Greystok, John, of Lodne, yeoman 0
5237740 2426624 2426624 defendant Mossy William husbandman 759963 759963 Mossy, William, of Lodne, husbandman 0
5254331 2431484 2431484 defendant Mossy William yeoman 759963 759963 Mossy, William, of Lodne, yeoman 0
5268124 2435800 2435800 defendant Mossy William husbandman 759963 759963 Mossy, William, of Lodne, husbandman 0
5275661 2437946 2437946 defendant Swete William husbandman 759963 759963 Swete, William, of Lodne, husbandman 3
5329760 2453975 2453975 defendant Goche John yeoman 759963 759963 Goche, John, of Lodne, yeoman 0
5329761 2453975 2453975 defendant Holme Reginald husbandman 759963 759963 Holme, Reginald, of Lodne, husbandman 1
5624019 2551458 2551458 defendant Bygot Richard husbandman 759963 759963 (Bygot, Richard, of Lodne, husbandman 5
5627417 2552546 2552546 defendant Cokefeld Thomas husbandman 759963 759963 Cokefeld, Thomas, of Lodne, husbandman 0
5627418 2552546 2552546 defendant Bygot Richard husbandman 759963 759963 Bygot, Richard, of Lodne, husbandman 1
5633531 2554484 2554484 defendant Bryd William yeoman 759963 759963 Bryd, William, of Lodne, yeoman 0
5634853 2554895 2554895 defendant Skeet John yeoman 759963 759963 Skeet, John, of Lodne, 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);