names

95 rows where place_id = 592745

✎ 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
3608735 1870395 1870395 defendant Wightman Richard yeoman 592745 592745 Wightman, Richard, of Hynkeley, yeoman 1
3608753 1870401 1870401 defendant Wodland Richard yeoman 592745 592745 Wodland, Richard, of Hynkeley, yeoman 1
3692323 1923767 1923767 defendant Whithman John husbandman 592745 592745 Whithman, John, of Hynkeley, husbandman 1
4474107 2192555 2192555 plaintiff del Hyl Roger   592745 592745 del Hyl, Roger, of Hynkeley 0
4474108 2192555 2192555 defendant Maynard Michael   592745 592745 Maynard, Michael, of Hynkeley 0
4547516 2215154 2215154 defendant Wybitoft William chaplain 592745 592745 Wybitoft, William, of Hynkeley, chaplain 0
4555520 2217657 2217657 defendant Greystok Richard   592745 592745 Greystok, Richard, of Hynkeley 0
4559775 2219011 2219011 defendant Bette Ralph   592745 592745 Bette, Ralph, of Hynkeley 0
4559779 2219013 2219013 defendant Bette Ralph   592745 592745 Bette, Ralph, of Hynkeley 0
4597826 2230574 2230574 defendant Hull Roger   592745 592745 Hull, Roger, of Hynkeley 1
4597989 2230627 2230627 plaintiff Smyth William   592745 592745 Smyth, William, of Hynkeley 0
4612111 2234856 2234856 plaintiff Cook William   592745 592745 Cook, William, of Hynkeley 0
4612113 2234856 2234856 defendant Payn Nicholas   592745 592745 Payn, Nicholas, of Hynkeley 0
4612114 2234856 2234856 defendant Adam Roger   592745 592745 Adam, Roger, of Hynkeley 1
4625317 2238886 2238886 defendant Ablot John   592745 592745 Ablot, John, of Hynkeley 1
4625318 2238886 2238886 defendant Carter John   592745 592745 Carter, John, of Hynkeley 2
4637885 2242619 2242619 defendant Hilles Roger othe   592745 592745 Hilles, Roger othe, of Hynkeley 0
4667177 2255468 2255468 defendant Cok William draper 592745 592745 Cok, William, of Hynkeley, draper 0
4667178 2255468 2255468 defendant Defford Thomas draper 592745 592745 Defford, Thomas, of Hynkeley, draper 1
4667179 2255468 2255468 defendant Payne Nicholas fisher 592745 592745 Payne, Nicholas, of Hynkeley, fisher 2
4667180 2255468 2255468 defendant Hyde William tailor 592745 592745 Hyde, William, of Hynkeley, tailor 3
4667181 2255468 2255468 defendant Pope John sheerman 592745 592745 Pope, John, of Hynkeley, sheerman 4
4667182 2255468 2255468 defendant Haket John husbandman 592745 592745 Haket, John, of Hynkeley, mercer Chapman, Robert, of Hynkeley, husbandman 5
4667183 2255468 2255468 defendant Person Simon shoemaker 592745 592745 Person, Simon, of Hynkeley, shoemaker 6
4667184 2255468 2255468 defendant Laurence John husbandman 592745 592745 Laurence, John, of Hynkeley, husbandman 7
4691252 2262784 2262784 defendant Abbot Henry draper 592745 592745 Abbot, Henry, of Hynkeley, draper 1
4722071 2272233 2272233 defendant Byrcheley Richard husbandman 592745 592745 Byrcheley, Richard, of Hynkeley, husbandman 0
4755627 2282142 2282142 defendant Wardale John husbandman 592745 592745 Wardale, John, of Hynkeley, husbandman 0
4755628 2282142 2282142 defendant Haget John chapman 592745 592745 Haget, John, of Hynkeley, chapman 1
4755629 2282142 2282142 defendant Haget Robert   592745 592745 Haget, Robert, of Hynkeley, servant 2
4755630 2282142 2282142 defendant Coke William husbandman 592745 592745 Coke, William, of Hynkeley, husbandman 3
4758123 2282914 2282914 defendant Jaye John husbandman 592745 592745 Jaye, John, of Hynkeley, husbandman 0
4758124 2282914 2282914 defendant Hychecok John husbandman 592745 592745 Hychecok, John, of Hynkeley, husbandman 1
4760929 2283759 2283759 defendant Hille_ Roger husbandman 592745 592745 Hille_, Roger, of Hynkeley, husbandman 0
4761037 2283801 2283801 defendant Bygg John husbandman 592745 592745 Bygg, John, of Hynkeley, husbandman 0
4761818 2284040 2284040 defendant Smyth John (legal representative) 592745 592745 Smyth, John, of Hynkeley, executors of 0
4768573 2286150 2286150 defendant Othe Hill Roger husbandman 592745 592745 Othe Hill, Roger, of Hynkeley, husbandman 0
4781034 2290076 2290076 defendant Ofthekechyn William husbandman 592745 592745 Ofthekechyn, William, of Hynkeley, husbandman 0
4784360 2291109 2291109 defendant Brygg John husbandman 592745 592745 Brygg, John, of Hynkeley, husbandman 0
4786329 2291767 2291767 defendant atte Hill Roger   592745 592745 atte Hill, Roger, of Hynkeley, bailiff 0
4786332 2291768 2291768 defendant Robyns John, junior smith 592745 592745 Robyns, John, junior, of Hynkeley, smith 0
4795459 2294731 2294731 defendant Kechyn William yeoman 592745 592745 Kechyn, William, of Hynkeley, yeoman 4
4814536 2300655 2300655 defendant Chapman Thomas husbandman 592745 592745 Chapman, Thomas, of Hynkeley, husbandman 0
4814733 2300725 2300725 defendant Peyntour John painter 592745 592745 Peyntour, John, of Hynkeley, painter 0
4853800 2312600 2312600 defendant Rampton William colosmaker 592745 592745 Rampton, William, of Hynkeley, colosmaker 1
4856852 2313520 2313520 defendant Byrcheley Richard husbandman 592745 592745 Byrcheley, Richard, of Hynkeley, husbandman 0
4859141 2314236 2314236 defendant Kychyn William husbandman 592745 592745 Kychyn, William, of Hynkeley, husbandman 0
4859142 2314236 2314236 defendant Justyce Thomas smith 592745 592745 Justyce, Thomas, of Hynkeley, smith 1
4918080 2332171 2332171 defendant Kyng John husbandman 592745 592745 Kyng, John, of Hynkeley, husbandman 0
4926850 2334828 2334828 defendant Cok Willam draper 592745 592745 Cok, Willam, of Hynkeley, draper 0
4960487 2345104 2345104 defendant Lany or Lavy Robert laborer 592745 592745 Lany or Lavy, Robert, of Hynkeley, laborer 0
4963645 2346039 2346039 defendant Jeke John husbandman 592745 592745 Jeke, John, of Hynkeley, husbandman 1
4963646 2346039 2346039 defendant Mon John husbandman 592745 592745 Mon, John, of Hynkeley, husbandman 2
4963647 2346039 2346039 defendant Symond John laborer 592745 592745 Symond, John, of Hynkeley, laborer 3
4963650 2346040 2346040 defendant Jeke John husbandman 592745 592745 Jeke, John, of Hynkeley, husbandman 1
4963651 2346040 2346040 defendant Mon John husbandman 592745 592745 Mon, John, of Hynkeley, husbandman 2
4963652 2346040 2346040 defendant Symond John husbandman 592745 592745 Symond, John, of Hynkeley, husbandman 3
4963655 2346041 2346041 defendant Jeke John husbandman 592745 592745 Jeke, John, of Hynkeley, husbandman 1
4963656 2346041 2346041 defendant Mon John husbandman 592745 592745 Mon, John, of Hynkeley, husbandman 2
4963657 2346041 2346041 defendant Symond John husbandman 592745 592745 Symond, John, of Hynkeley, husbandman 3
4975302 2349569 2349569 defendant Peyntour John yeoman 592745 592745 Peyntour, John, of Hynkeley, yeoman 1
4975303 2349569 2349569 defendant May John yeoman 592745 592745 May, John, of Hynkeley, yeoman 2
4975304 2349569 2349569 defendant Walton William gent 592745 592745 Walton, William, of Hynkeley, gent 3
5016573 2361742 2361742 defendant May John yeoman 592745 592745 May, John, of Hynkeley, yeoman 1
5037240 2367761 2367761 defendant Burbage William butcher 592745 592745 Burbage, William, of Hynkeley, butcher 2
5106659 2388376 2388376 defendant Peyntour William painter 592745 592745 Peyntour, William, of Hynkeley, painter 2
5112820 2390144 2390144 defendant Walker John walker 592745 592745 Walker, John, of Hynkeley, walker 1
5112825 2390145 2390145 defendant Walker John walker 592745 592745 Walker, John, of Hynkeley, walker 1
5157263 2403265 2403265 plaintiff Page John   592745 592745 Page, John, of Hynkeley 0
5173240 2407887 2407887 plaintiff Page John   592745 592745 Page, John, of Hynkeley 0
5190987 2413109 2413109 defendant Totlowe William   592745 592745 Totlowe, William, of Hynkeley, horse dealer 1
5239315 2427085 2427085 defendant Doreward John butcher 592745 592745 Doreward, John, of Hynkeley, butcher 0
5247608 2429458 2429458 defendant Jeke Heny yeoman 592745 592745 Jeke, Heny, of Hynkeley, yeoman 1
5247609 2429458 2429458 defendant Chamberleyn William husbandman 592745 592745 Chamberleyn, William, of Hynkeley, husbandman 2
5285875 2440887 2440887 defendant Page John, junior gent 592745 592745 Page, John, junior, of Hynkeley, gent 4
5328481 2453593 2453593 defendant Wodland John, junior butcher 592745 592745 Wodland, John, junior, of Hynkeley, butcher 0
5330933 2454318 2454318 defendant Wodlond John butcher 592745 592745 Wodlond, John, of Hynkeley, butcher 0
5330934 2454318 2454318 defendant Wodlond John, junior husbandman 592745 592745 Wodlond, John, junior, of Hynkeley, husbandman 1
5330935 2454318 2454318 defendant Jakes Thomas husbandman 592745 592745 Jakes, Thomas, of Hynkeley, husbandman 2
5330936 2454318 2454318 defendant Hyll John husbandman 592745 592745 Hyll, John, of Hynkeley, husbandman 3
5330937 2454318 2454318 defendant Max John tailor 592745 592745 Max, John, of Hynkeley, tailor 4
5330938 2454318 2454318 defendant Wodlond Robert husbandman 592745 592745 Wodlond, Robert, of Hynkeley, husbandman 5
5330939 2454318 2454318 defendant Wodlond Henry husbandman 592745 592745 Wodlond, Henry, of Hynkeley, husbandman 6
5330940 2454318 2454318 defendant Baudewyn William husbandman 592745 592745 Baudewyn, William, of Hynkeley, husbandman 7
5330941 2454318 2454318 defendant Tanwell Richard busbandman 592745 592745 Tanwell, Richard, of Hynkeley, busbandman 8
5330942 2454318 2454318 defendant Reson John husbandman 592745 592745 Reson, John, of Hynkeley, husbandman 9
5330943 2454318 2454318 defendant Wylson John mercer 592745 592745 Wylson, John, of Hynkeley, mercer 10
5330944 2454318 2454318 defendant Barley John weaver 592745 592745 Barley, John, of Hynkeley, weaver 11
5373332 2467257 2467257 defendant Man Roger husbandman 592745 592745 Man, Roger, of Hynkeley, husbandman 1
5399301 2474872 2474872 defendant Wodlond John husbandman 592745 592745 Wodlond, John, of Hynkeley, husbandman 2
5444912 2488362 2488362 defendant Wodlond John husbandman 592745 592745 Wodlond, John, of Hynkeley, husbandman 2
5540072 2517019 2517019 defendant Cottysford Roger yeoman 592745 592745 Cottysford, Roger, of Hynkeley, yeoman 0
5540073 2517019 2517019 defendant Heth Joan spinster 592745 592745 Heth, Joan, of Hynkeley, spinster 1
5627103 2552445 2552445 defendant del Hill Roger husbandman 592745 592745 del Hill, Roger, of Hynkeley, husbandman 0
5627104 2552445 2552445 defendant Bette Ralph husbandman 592745 592745 Bette, Ralph, of Hynkeley, husbandman 1

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