names

81 rows where place_id = 586513

✎ 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
3588925 1864187 1864187 defendant Benet William husbandman 586513 586513 Benet, William, of Newebury, Berks, husbandman 0
3588927 1864188 1864188 defendant Benet William husbandman 586513 586513 Benet, William, of Newebury, Berks, husbandman 0
3604053 1868936 1868936 plaintiff Frere Nicholas clothier 586513 586513 Frere, Nicholas, of Newebury, Berks, clothier 0
3608266 1870241 1870241 defendant Frye John yeoman of the crown 586513 586513 Frye, John, of Newebury, Berks, gent, yeoman of the crown 0
3608268 1870242 1870242 defendant Frye John yeoman of the crown 586513 586513 Frye, John, of Newebury, Berks, gent, yeoman of the crown 0
3671657 1917123 1917123 defendant Byrche William chapman 586513 586513 Byrche, William, of Newebury, Berks, chapman 0
4606235 2233060 2233060 defendant Motthe John dyer 586513 586513 Motthe, John, of Newebury, Berks, dyer 0
4670832 2256557 2256557 defendant Champ John esq 586513 586513 Champ, John, of Newebury, Berks, esq 0
4670840 2256558 2256558 defendant Champ John esq 586513 586513 Champ, John, of Newebury, Berks, esq 0
4671233 2256658 2256658 defendant Walyngforde Thomas dyer 586513 586513 Walyngforde, Thomas, of Newebury, Berks, dyer 0
4695907 2264205 2264205 defendant Champ John esq 586513 586513 Champ, John, of Newebury, Berks, esq 0
4723353 2272613 2272613 defendant Hull Henry husbandman 586513 586513 Hull, Henry, of Newebury, Berks, husbandman 1
4761418 2283915 2283915 defendant May Robert weaver 586513 586513 May, Robert, of Newebury, Berks, weaver 0
4784781 2291247 2291247 defendant May Robert weaver 586513 586513 May, Robert, of Newebury, Berks, weaver 0
4788540 2292477 2292477 defendant Hille Henry chapman 586513 586513 Hille, Henry, of Newebury, Berks, chapman 1
4798889 2295827 2295827 plaintiff Tapenere John   586513 586513 Tapenere, John, of Newebury, Berks 0
4808546 2298840 2298840 defendant Mathu John fellmonger 586513 586513 Mathu, John, of Newebury, Berks, fellmonger 1
4814485 2300638 2300638 defendant Parker John butcher 586513 586513 Parker, John, of Newebury, Berks, butcher 1
4860480 2314640 2314640 defendant Fryth Robert hosier 586513 586513 Fryth, Robert, of Newebury, Berks, hosier 0
4864923 2316004 2316004 defendant Smyth Thomas smith 586513 586513 Smyth, Thomas, of Newebury, Berks, smith 0
4886372 2322598 2322598 defendant Makus John chapman 586513 586513 Makus, John, of Newebury, Berks, chapman 0
4888991 2323347 2323347 defendant Mounford William dyer 586513 586513 Mounford, William, of Newebury, Berks, dyer 0
4891240 2323993 2323993 defendant Clerk Thomas smith 586513 586513 Clerk, Thomas, of Newebury, Berks, smith 4
4924715 2334167 2334167 defendant Max John chapman 586513 586513 Max, John, of Newebury, Berks, chapman 1
4924962 2334237 2334237 defendant May John chapman 586513 586513 May, John, of Newebury, Berks, chapman 1
4931763 2336322 2336322 defendant Halle William skinner 586513 586513 Halle, William, of Newebury, Berks, skinner 0
4952885 2342821 2342821 defendant Holnest John husbandman 586513 586513 Holnest, John, of Newebury, Berks, husbandman 1
4981685 2351437 2351437 defendant Godard Thomas hosteler 586513 586513 Godard, Thomas, of Newebury, Berks, hosteler 0
4993628 2354968 2354968 defendant Pescode William husbandman 586513 586513 Pescode, William, of Newebury, Berks, husbandman 0
4994710 2355274 2355274 defendant Ex John chapman 586513 586513 Ex, John, of Newebury, Berks, chapman 0
4994714 2355275 2355275 defendant Ex John chapman 586513 586513 Ex, John, of Newebury, Berks, chapman 0
5023801 2363869 2363869 defendant Hafylde Roger butcher 586513 586513 Hafylde, Roger, of Newebury, Berks, butcher 0
5048281 2371120 2371120 defendant Croke John tanner 586513 586513 with Croke, John, of Newebury, Berks, tanner 2
5048286 2371121 2371121 defendant Croke John tanner 586513 586513 (Croke, John, of Newebury, Berks, tanner 1
5065452 2376201 2376201 defendant Cateloyne Robert ostler 586513 586513 Cateloyne, Robert, of Newebury, Berks, ostler 0
5105149 2387944 2387944 defendant Underwode Richard chapman 586513 586513 Underwode, Richard, of Newebury, Berks, chapman 2
5107931 2388759 2388759 defendant Smyth William yeoman 586513 586513 Smyth, William, of Newebury, Berks, yeoman 3
5112227 2389957 2389957 defendant Doget John draper 586513 586513 together with Doget, John, of Newebury, Berks, draper 2
5112229 2389958 2389958 defendant Doket John draper 586513 586513 Doket, John, of Newebury, Berks, draper 0
5123621 2393367 2393367 defendant Godard Thomas husbandman 586513 586513 Godard, Thomas, of Newebury, Berks, husbandman 2
5133371 2396251 2396251 defendant Smyth John yeoman 586513 586513 Smyth, John, of Newebury, Berks, yeoman 0
5147308 2400355 2400355 defendant Love John chapman 586513 586513 Love, John, of Newebury, Berks, chapman 0
5147312 2400356 2400356 defendant Lole John chapman 586513 586513 Lole, John, of Newebury, Berks, chapman 1
5214002 2419825 2419825 defendant Boteley John yeoman 586513 586513 Boteley, John, of Newebury, Berks, yeoman 4
5216449 2420541 2420541 defendant Bedford John   586513 586513 Bedford, John, of Newebury, Berks, kersey man 0
5227849 2423760 2423760 defendant Smyth William yeoman 586513 586513 Smyth, William, of Newebury, Berks, yeoman 1
5230020 2424393 2424393 defendant Frye Thomas husbandman 586513 586513 Frye, Thomas, of Newebury, Berks, husbandman 1
5239449 2427119 2427119 defendant Hoskyn Thomas yeoman 586513 586513 Hoskyn, Thomas, of Newebury, Berks, yeoman 1
5244559 2428590 2428590 defendant Whitwey John chapman 586513 586513 Whitwey, John, of Newebury, Berks, chapman 0
5251424 2430544 2430544 defendant Kyng John dyer 586513 586513 Kyng, John, of Newebury, Berks, dyer 0
5251433 2430547 2430547 defendant Kyng John dyer 586513 586513 Kyng, John, of Newebury, Berks, dyer 0
5261465 2433697 2433697 defendant Polshave Henry weaver 586513 586513 Polshave, Henry, of Newebury, Berks, weaver 0
5275976 2438049 2438049 defendant Mayhowe William chapman 586513 586513 Mayhowe, William, of Newebury, Berks, chapman 2
5276035 2438064 2438064 defendant Harford Richard yeoman 586513 586513 Harford, Richard, of Newebury, Berks, yeoman 4
5278329 2438765 2438765 defendant Love or Lone Thomas clothmaker 586513 586513 Love or Lone, Thomas, of Newebury, Berks, clothmaker 0
5278331 2438766 2438766 defendant Love or Lone Thomas clothmaker 586513 586513 Love or Lone, Thomas, of Newebury, Berks, clothmaker 0
5279833 2439183 2439183 defendant Mayhue William chapman 586513 586513 Mayhue, William, of Newebury, Berks, chapman 2
5279839 2439184 2439184 defendant Mayhue William chapman 586513 586513 Mayhue, William, of Newebury, Berks, chapman 2
5292357 2442765 2442765 defendant Kyng John dyer 586513 586513 Kyng, John, of Newebury, Berks, dyer 2
5292361 2442766 2442766 defendant Kyng John dyer 586513 586513 Kyng, John, of Newebury, Berks, dyer 2
5293528 2443075 2443075 defendant Marmyn William chapman 586513 586513 Marmyn, William, of Newebury, Berks, chapman 3
5294325 2443314 2443314 defendant Polyngton Richard yeoman 586513 586513 Polyngton, Richard, of Newebury, Berks, yeoman 0
5301544 2445415 2445415 defendant Holcote George ostler 586513 586513 Holcote, George, of Newebury, Berks, ostler 3
5322632 2451849 2451849 defendant Robyns Richard chandler 586513 586513 Robyns, Richard, of Newebury, Berks, chandler 1
5322688 2451862 2451862 defendant Robyns Richard chapman 586513 586513 Robyns, Richard, of Newebury, Berks, chapman 1
5351113 2460454 2460454 defendant A Parke Nicholas fuller 586513 586513 A Parke, Nicholas, of Newebury, Berks, fuller 0
5361783 2463715 2463715 defendant Polhampton William haberdasher 586513 586513 Polhampton, William, of Newebury, Berks, haberdasher 2
5439157 2486635 2486635 defendant Nevyll Alice widow 586513 586513 Nevyll, Alice, of Newebury, Berks, widow 3
5450398 2490006 2490006 defendant Friar Nicholas   586513 586513 Friar, Nicholas, of Newebury, Berks 1
5450399 2490006 2490006 defendant Howell William kerseyman 586513 586513 Howell, William, of Newebury, Berks, kerseyman 2
5462554 2493712 2493712 defendant Soper Thomas   586513 586513 Soper, Thomas, of Newebury, Berks, kersey man 0
5462555 2493712 2493712 defendant Howell William   586513 586513 Howell, William, of Newebury, Berks, kersey man 1
5464847 2494400 2494400 defendant Neweporte John weaver & clothier 586513 586513 Neweporte, John, of Newebury, Berks, weaver & clothier 2
5464852 2494401 2494401 defendant Neweporte John weaver & clothier 586513 586513 Neweporte, John, of Newebury, Berks, weaver & clothier 3
5465182 2494491 2494491 defendant Soper Thomas clothman 586513 586513 Soper, Thomas, of Newebury, Berks, clothman 0
5487873 2501259 2501259 defendant Neweport John weaver and clothier 586513 586513 Neweport, John, of Newebury, Berks, weaver and clothier 2
5560233 2522956 2522956 plaintiff Smyth Henry clothier 586513 586513 Smyth, Henry, of Newebury, Berks, clothier 0
5580795 2529072 2529072 defendant Barle John capper 586513 586513 Barle, John, of Newebury, Berks, capper 0
5600318 2534987 2534987 defendant Sare Thomas chapman 586513 586513 Sare, Thomas, of Newebury, Berks, chapman 1
5624441 2551588 2551588 defendant Motche John dyer 586513 586513 Motche, John, of Newebury, Berks, dyer 0
5636979 2555511 2555511 defendant Beamond Nicholas mercer 586513 586513 Beamond, Nicholas, of Newebury, Berks, mercer 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);