names

64 rows where place_id = 592621

✎ 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
3608275 1870245 1870245 defendant Herneby John husbandman 592621 592621 Herneby, John, of Haryngworth, husbandman 0
3619690 1873728 1873728 defendant Williams William yeoman 592621 592621 Williams, William, of Haryngworth, yeoman 0
3635277 1905824 1905824 defendant Hornby John butcher 592621 592621 Hornby, John, of Haryngworth, butcher 0
3722596 1933327 1933327 defendant Newman Richard tanner 592621 592621 Newman, Richard, of Haryngworth, tanner 3
3834140 1968620 1968620 defendant Clerk Richard yeoman 592621 592621 Clerk, Richard, of Haryngworth, yeoman 0
3868451 1979686 1979686 defendant Stevenson John yeoman 592621 592621 Stevenson, John, of Haryngworth, yeoman 5
3872990 1981182 1981182 defendant Aynsworth Francis gent 592621 592621 Aynsworth, Francis, of Haryngworth, gent 0
3904254 1991668 1991668 defendant Broune John oiler or oil maker 592621 592621 Broune, John, of Haryngworth, oiler or oil maker 0
4452981 2185940 2185940 plaintiff la Zouche William   592621 592621 la Zouche, William, of Haryngworth, knight 0
4452983 2185941 2185941 plaintiff la Zouche William   592621 592621 la Zouche, William, of Haryngworth, knight 0
4452985 2185942 2185942 plaintiff la Zouche William   592621 592621 la Zouche, William, of Haryngworth, knight 0
4452987 2185943 2185943 plaintiff la Zouche William   592621 592621 la Zouche, William, of Haryngworth, knight 0
4453622 2186144 2186144 defendant Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4459117 2187896 2187896 defendant Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4459119 2187897 2187897 defendant Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4459121 2187898 2187898 defendant Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4459123 2187899 2187899 defendant la Zouche William   592621 592621 la Zouche, William, of Haryngworth, knight 0
4459125 2187900 2187900 defendant Zouche William le   592621 592621 Zouche, William le, of Haryngworth, knight 0
4459127 2187901 2187901 defendant Zouche William le   592621 592621 Zouche, William le, of Haryngworth, knight 0
4462161 2188861 2188861 defendant Baker Reginald   592621 592621 Baker, Reginald, of Haryngworth 0
4466298 2190120 2190120 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4466302 2190121 2190121 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4483097 2195410 2195410 defendant la Zouche William   592621 592621 la Zouche, William, of Haryngworth 0
4483167 2195432 2195432 defendant la Zouche William   592621 592621 la Zouche, William, of Haryngworth 0
4489541 2197449 2197449 plaintiff Toly John   592621 592621 Toly, John, of Haryngworth 0
4489543 2197450 2197450 plaintiff Toly John   592621 592621 Toly, John, of Haryngworth, parson of the free chapel of the manor, on his own account 0
4505725 2202299 2202299 defendant Souche Elizabeth le   592621 592621 Souche, Elizabeth le, of Haryngworth, formerly wife of William la Souche 0
4536551 2211709 2211709 defendant Souche Elizabeth la   592621 592621 Souche, Elizabeth la, of Haryngworth, formerly wife of William la Souche 0
4542423 2213520 2213520 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4542426 2213521 2213521 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4542429 2213522 2213522 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4542445 2213523 2213523 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4570179 2222242 2222242 defendant Snutt Richard   592621 592621 Snutt, Richard, of Haryngworth 0
4571263 2222584 2222584 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth 0
4598587 2230797 2230797 defendant Toly John chaplain 592621 592621 Toly, John, of Haryngworth, chaplain 2
4680255 2259437 2259437 defendant Spencer John   592621 592621 Spencer, John, of Haryngworth, minstrel 0
4680532 2259523 2259523 defendant Overton John yeoman 592621 592621 Overton, John, of Haryngworth, yeoman 1
4680628 2259553 2259553 defendant Overton John yeoman 592621 592621 Overton, John, of Haryngworth, yeoman 1
4717753 2270891 2270891 defendant Wodward William tiler 592621 592621 Wodward, William, of Haryngworth, tiler 1
4749525 2280341 2280341 defendant Plukrose William husbandman 592621 592621 Plukrose, William, of Haryngworth, husbandman 0
4888814 2323293 2323293 defendant Cousyn John clerk 592621 592621 Cousyn, John, of Haryngworth, clerk 1
4888815 2323293 2323293 defendant Parker William yeoman 592621 592621 Parker, William, of Haryngworth, yeoman 2
4890005 2323657 2323657 defendant Cousyn John clerk 592621 592621 Cousyn, John, of Haryngworth, clerk 1
4890006 2323657 2323657 defendant Parker William yeoman 592621 592621 Parker, William, of Haryngworth, yeoman 2
4930554 2335960 2335960 defendant Parker John butcher 592621 592621 Parker, John, of Haryngworth, butcher 0
4958796 2344602 2344602 plaintiff Zoweche or Soweche John esq 592621 592621 Zoweche or Soweche, John, of Haryngworth, esq 0
5079041 2380218 2380218 defendant Lyngen William esq 592621 592621 Lyngen, William, of Haryngworth, esq 0
5118561 2391859 2391859 defendant Zouche William esq 592621 592621 Zouche, William, of Haryngworth, esq 3
5134515 2396589 2396589 defendant Stanley Robert   592621 592621 Stanley, Robert, of Haryngworth 0
5189974 2412808 2412808 defendant Stanley Robert husbandman 592621 592621 Stanley, Robert, of Haryngworth, husbandman 0
5240250 2427355 2427355 defendant Myles Thomas yeoman 592621 592621 Myles, Thomas, of Haryngworth, yeoman 1
5294471 2443361 2443361 defendant Messanger Robert yeoman 592621 592621 Messanger, Robert, of Haryngworth, yeoman 2
5314857 2449491 2449491 defendant Scott John bytcher 592621 592621 Scott, John, of Haryngworth, bytcher 0
5382362 2470014 2470014 defendant Messanger John chapman 592621 592621 Messanger, John, of Haryngworth, chapman 0
5382363 2470014 2470014 defendant Bey John weaver 592621 592621 Bey, John, of Haryngworth, weaver 1
5382364 2470014 2470014 defendant Bey John husbandman 592621 592621 Bey, John, of Haryngworth, husbandman 2
5484473 2500273 2500273 defendant Edlyn Thomas husbandman 592621 592621 Edlyn, Thomas, of Haryngworth, husbandman 3
5484612 2500322 2500322 defendant Edlyn Thomas husbandman 592621 592621 Edlyn, Thomas, of Haryngworth, husbandman 3
5527726 2513252 2513252 defendant Waterton John gent 592621 592621 Waterton, John, of Haryngworth, gent 0
5532354 2514661 2514661 defendant Abarton or Avarton John yeoman 592621 592621 Abarton or Avarton, John, of Haryngworth, yeoman 0
5532355 2514661 2514661 defendant Abarton Simon mercer 592621 592621 Abarton, Simon, of Haryngworth, mercer 1
5576802 2527789 2527789 defendant Slye Henry baker 592621 592621 Slye, Henry, of Haryngworth, baker 0
5608246 2537479 2537479 defendant Messenger John chapman 592621 592621 Messenger, John, of Haryngworth, chapman 0
5608248 2537479 2537479 defendant B-- John husbandman 592621 592621 B--, John, of Haryngworth, husbandman 2

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