names

89 rows where place_id = 590967

✎ 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
3602856 1868562 1868562 defendant Coke John husbandman 590967 590967 Coke, John, of Bilston, husbandman 3
3603041 1868619 1868619 defendant Ylly Thomas fuller 590967 590967 Ylly, Thomas, of Bilston, fuller 0
3603042 1868619 1868619 defendant Madok John laborer 590967 590967 Madok, John, of Bilston, laborer 1
3603233 1868680 1868680 defendant Nicols Robert weaver 590967 590967 Nicols, Robert, of Bilston, weaver 1
3603237 1868681 1868681 defendant Nicholl Robert weaver 590967 590967 Nicholl, Robert, of Bilston, weaver 2
3603398 1868735 1868735 defendant Cooke John clothmaker 590967 590967 Cooke, John, of Bilston, clothmaker 0
3623085 1874743 1874743 defendant Carter Alexander fisher 590967 590967 Carter, Alexander, of Bilston, fisher 1
3623943 1875018 1875018 defendant Stodard Roger clerk 590967 590967 Stodard, Roger, of Bilston, clerk 0
3623944 1875018 1875018 defendant Stern Richard tailor 590967 590967 Stern, Richard, of Bilston, tailor 1
3659420 1913207 1913207 defendant Blowgate John sheer man 590967 590967 Blowgate, John, of Bilston, sheer man 0
3670085 1916589 1916589 defendant Partyngton Richard husbandman 590967 590967 Partyngton, Richard, of Bilston, husbandman 0
4072352 2050414 2050414 plaintiff Osmonde Robert clerk 590967 590967 Osmonde, Robert, of Bilston, clerk 0
4111730 2064443 2064443 defendant Pirrie William husbandman 590967 590967 Pirrie, William, of Bilston, husbandman 0
4111731 2064443 2064443 defendant Baylie Robert husbandman 590967 590967 Baylie, Robert, of Bilston, husbandman 1
4139878 2074629 2074629 defendant Jannyng Robert husbandman 590967 590967 Jannyng, Robert, of Bilston, husbandman 1
4143243 2075804 2075804 defendant Ithell Hugh gent 590967 590967 Ithell, Hugh, of Bilston, gent 2
4143469 2075875 2075875 defendant Sharplyn Thomas weaver 590967 590967 Sharplyn, Thomas, of Bilston, weaver 2
4216455 2101249 2101249 defendant Gerye William, senior yeoman 590967 590967 Gerye, William, senior, of Bilston, yeoman 0
4216456 2101249 2101249 defendant Gerye Robert   590967 590967 Gerye, Robert, of Bilston, yeoman, his son 1
4216457 2101249 2101249 defendant Glenn Thomas husbandman 590967 590967 Glenn, Thomas, of Bilston, husbandman 2
4242065 2110340 2110340 defendant Nicholson Thomas sherman 590967 590967 Nicholson, Thomas, of Bilston, sherman 2
4245273 2111403 2111403 defendant Norden Robert yeoman 590967 590967 Norden, Robert, of Bilston, yeoman 0
4264326 2117716 2117716 defendant Foxall William gent 590967 590967 Foxall, William, of Bilston, gent 0
4277346 2122000 2122000 defendant Lamberde Bennett shoemaker 590967 590967 Lamberde, Bennett, of Bilston, shoemaker 3
4284401 2124469 2124469 defendant Foxall William gent 590967 590967 Foxall, William, of Bilston, gent 0
4307353 2132708 2132708 defendant Wade Robert clothier 590967 590967 Wade, Robert, of Bilston, clothier 2
4314456 2135168 2135168 defendant Foxall William gent 590967 590967 Foxall, William, of Bilston, gent 1
4358759 2150297 2150297 defendant Rayner Moses sherman 590967 590967 Rayner, Moses, of Bilston, sherman 3
4376721 2156740 2156740 defendant Corbold John butcher 590967 590967 Corbold, John, of Bilston, butcher 0
4403641 2165794 2165794 defendant Waters Nicholas brickmaker 590967 590967 Waters, Nicholas, of Bilston, brickmaker 2
4501748 2201144 2201144 defendant Benys John   590967 590967 Benys, John, of Bilston 2
4549342 2215736 2215736 plaintiff Cook Thomas   590967 590967 Cook, Thomas, of Bilston 0
4563061 2220015 2220015 plaintiff Randolf Walter   590967 590967 Randolf, Walter, of Bilston 0
4636872 2242349 2242349 defendant El_ Thomas   590967 590967 El_, Thomas, of Bilston 4
4701548 2265878 2265878 plaintiff Gervas John   590967 590967 Gervas, John, of Bilston 0
4725705 2273328 2273328 plaintiff Gerveys John   590967 590967 Gerveys, John, of Bilston 0
4735000 2276096 2276096 plaintiff Thendun John   590967 590967 Thendun, John, of Bilston, parson 3
4745506 2279197 2279197 plaintiff Gerveys John   590967 590967 Gerveys, John, of Bilston 0
4774540 2288023 2288023 defendant Bargh John yeoman 590967 590967 Bargh, John, of Bilston, yeoman 0
4777095 2288817 2288817 defendant Jerveys John   590967 590967 Jerveys, John, of Bilston 4
4777103 2288818 2288818 defendant Jerveys John   590967 590967 Jerveys, John, of Bilston 4
4800237 2296251 2296251 defendant Bargh John yeoman 590967 590967 Bargh, John, of Bilston, yeoman 0
4827206 2304558 2304558 defendant Freman John butcher 590967 590967 Freman, John, of Bilston, butcher 0
4828695 2305017 2305017 defendant Thinkys William husbandman 590967 590967 Thinkys, William, of Bilston, husbandman 1
4915132 2331240 2331240 defendant Strut John clothmaker 590967 590967 Strut, John, of Bilston, clothmaker 3
4934950 2337336 2337336 plaintiff Baroun John tailor 590967 590967 Baroun, John, of Bilston, tailor 0
4954479 2343307 2343307 plaintiff Stanesby Robert merchant 590967 590967 Stanesby, Robert, of Bilston, merchant 0
4960288 2345051 2345051 plaintiff Baron John tailor 590967 590967 Baron, John, of Bilston, tailor 0
4961736 2345473 2345473 defendant Balle Richard husbandman 590967 590967 Balle, Richard, of Bilston, husbandman 1
4961737 2345473 2345473 defendant Balle William husbandman 590967 590967 Balle, William, of Bilston, husbandman 2
4965029 2346460 2346460 plaintiff Cook John   590967 590967 Cook, John, of Bilston 0
5053096 2372521 2372521 defendant Thweyt Thomas dyer 590967 590967 Thweyt, Thomas, of Bilston, dyer 2
5053097 2372521 2372521 defendant Cukkowe Richard cooper 590967 590967 Cukkowe, Richard, of Bilston, cooper 3
5063560 2375631 2375631 defendant Whitop William yeoman 590967 590967 Whitop, William, of Bilston, yeoman 0
5072287 2378199 2378199 plaintiff Taillour Clement   590967 590967 Taillour, Clement, of Bilston 0
5086031 2382305 2382305 defendant Symond alias Mellere Richard husbandman 590967 590967 Symond alias Mellere, Richard, of Bilston, husbandman 1
5089592 2383331 2383331 defendant Taillour Clement tailor 590967 590967 Taillour, Clement, of Bilston, tailor 0
5094257 2384726 2384726 defendant Wyndyff John husbandman 590967 590967 Wyndyff, John, of Bilston,husbandman 1
5098055 2385864 2385864 defendant Newelond Richard weaver 590967 590967 Newelond, Richard, of Bilston, weaver 0
5101733 2386929 2386929 defendant Milner William yeoman 590967 590967 Milner, William, of Bilston, yeoman 2
5101737 2386930 2386930 defendant Mylner William yeoman 590967 590967 Mylner, William, of Bilston, yeoman 2
5101779 2386945 2386945 plaintiff Baron John   590967 590967 Baron, John, of Bilston 0
5112915 2390170 2390170 defendant Heyward Thomas fuller 590967 590967 Heyward, Thomas, of Bilston, fuller 1
5121193 2392627 2392627 defendant Fennyng John, senior weaver 590967 590967 Fennyng, John, senior, of Bilston,weaver 3
5152447 2401849 2401849 plaintiff Herry Robert   590967 590967 Herry, Robert, of Bilston 0
5152450 2401849 2401849 defendant Rolf John carpenter 590967 590967 Rolf, John, of Bilston, carpenter 2
5173715 2408008 2408008 defendant Hopkys William butcher 590967 590967 Hopkys, William, of Bilston, butcher 0
5193821 2413914 2413914 defendant Hopkys William butcher 590967 590967 Hopkys, William, of Bilston, butcher 0
5225941 2423257 2423257 defendant Rauff Walter laborer 590967 590967 Rauff, Walter, of Bilston, laborer 2
5231393 2424768 2424768 defendant Blower Thomas pedder 590967 590967 Blower, Thomas, of Bilston, pedder 0
5239840 2427227 2427227 defendant Skrevener William weaver 590967 590967 Skrevener, William, of Bilston, weaver 2
5245216 2428756 2428756 defendant Symond Richard miller 590967 590967 Symond, Richard, of Bilston, miller 0
5265728 2435032 2435032 defendant Pury John husbandman 590967 590967 Pury, John, of Bilston, husbandman 1
5403195 2475997 2475997 defendant Clement John carpenter 590967 590967 Clement, John, of Bilston, carpenter 9
5423431 2481968 2481968 defendant Parker Augustine husbandman 590967 590967 Parker, Augustine, of Bilston, husbandman 0
5442095 2487554 2487554 defendant Roberd John weaver 590967 590967 Roberd, John, of Bilston, weaver 3
5442738 2487741 2487741 defendant Parker Augustine husbandman 590967 590967 Parker, Augustine, of Bilston, husbandman 0
5449894 2489856 2489856 defendant Bright Robert clothmaker 590967 590967 Bright, Robert, of Bilston, clothmaker 0
5455432 2491538 2491538 defendant Paprker Augustine husbandman 590967 590967 Paprker, Augustine, of Bilston, husbandman 0
5455440 2491539 2491539 defendant Parker Augustine husbandman 590967 590967 Parker, Augustine, of Bilston, husbandman 0
5455447 2491540 2491540 defendant Parker Augustine husbandman 590967 590967 Parker, Augustine, of Bilston, husbandman 0
5456953 2491982 2491982 defendant Carter Alexancer   590967 590967 Carter, Alexancer, of Bilston, pedlar 2
5468818 2495601 2495601 defendant Carter Alexander pedder 590967 590967 Carter, Alexander, of Bilston, pedder 2
5503798 2506104 2506104 defendant Cokuk alias Coper Thomas draper 590967 590967 Cokuk alias Coper, Thomas, of Bilston, draper 2
5538883 2516647 2516647 defendant Barker John yeoman 590967 590967 Barker, John, of Bilston, yeoman 1
5557873 2522255 2522255 defendant Coke John clothmaker 590967 590967 Coke, John, of Bilston, clothmaker 1
5557874 2522255 2522255 defendant Kennynghale alias Barker John clothmaker 590967 590967 Kennynghale alias Barker, John, of Bilston, clothmaker 2
5578937 2528481 2528481 defendant Taylour Robert weaver 590967 590967 Taylour, Robert, of Bilston, weaver 0
5636077 2555241 2555241 defendant Sherman John sherman 590967 590967 Sherman, John, of Bilston, sherman 3

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