names

82 rows where place_id = 588382

✎ 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
3594310 1865853 1865853 defendant Westby Henry gent 588382 588382 Westby, Henry, of Frysby, gent 2
3739011 1938406 1938406 defendant Hadson John husbandman 588382 588382 Hadson, John, of Frysby, husbandman 0
3834707 1968790 1968790 defendant Bake John husbandman 588382 588382 Bake, John, of Frysby, husbandman 0
3849072 1973306 1973306 defendant Warde John husbandman 588382 588382 Warde, John, of Frysby, husbandman 1
3849074 1973307 1973307 defendant Warde John husbandman 588382 588382 Warde, John, of Frysby, husbandman 0
3854880 1975171 1975171 plaintiff Warde John husbandman 588382 588382 Warde, John, of Frysby, husbandman 2
3864225 1978227 1978227 defendant Warde John husbandman 588382 588382 Warde, John, of Frysby, husbandman 0
3919986 1997023 1997023 defendant Bysshopp Margaret widow 588382 588382 Bysshopp, Margaret, of Frysby, widow 1
4605729 2232909 2232909 plaintiff Asshowe Thomas   588382 588382 Asshowe, Thomas, of Frysby 0
4613513 2235245 2235245 defendant Bailly Ralph   588382 588382 Bailly, Ralph, of Frysby 0
4641523 2243620 2243620 plaintiff Frisby Roger   588382 588382 Frisby, Roger, of Frysby 0
4641908 2243741 2243741 defendant Bailly Ralph   588382 588382 Bailly, Ralph, of Frysby 0
4667324 2255508 2255508 defendant atte Carre William husbandman 588382 588382 atte Carre, William, of Frysby, husbandman 2
4669373 2256129 2256129 defendant Tynton William husbandman 588382 588382 Tynton, William, of Frysby, husbandman 0
4685883 2261176 2261176 plaintiff Schery Simon   588382 588382 Schery, Simon, of Frysby 0
4711837 2269031 2269031 plaintiff Schery Simon   588382 588382 Schery, Simon, of Frysby 0
4713247 2269468 2269468 defendant Cheveney Mary de widow 588382 588382 (Cheveney, Mary de, of Frysby, widow 1
4713248 2269468 2269468 defendant Cheveney Robert husbandman 588382 588382 Cheveney, Robert, of Frysby, husbandman 2
4721719 2272130 2272130 plaintiff Chery Simon   588382 588382 Chery, Simon, of Frysby 0
4728922 2274284 2274284 defendant Westyby Joan   588382 588382 Westyby, Joan, of Frysby, widow, formerly wife of John 0
4734498 2275957 2275957 defendant Brokesby Bartholomew esq 588382 588382 Brokesby, Bartholomew, of Frysby, esq 0
4734502 2275957 2275957 defendant Wryght Robert yeoman 588382 588382 Wryght, Robert, of Frysby, yeoman 4
4749040 2280202 2280202 defendant Smyth Gilbert husbandman 588382 588382 Smyth, Gilbert, of Frysby, husbandman 0
4760691 2283687 2283687 defendant atte Hall Thomas husbandman 588382 588382 atte Hall, Thomas, of Frysby, husbandman 0
4779841 2289692 2289692 plaintiff Brokesby Bartholomew esq 588382 588382 Brokesby, Bartholomew, of Frysby, esq 0
4779842 2289692 2289692 defendant Decun Richard husbandman 588382 588382 Decun, Richard, of Frysby, husbandman 0
4779843 2289692 2289692 defendant Roggerson Talph husbandman 588382 588382 Roggerson, Talph, of Frysby, husbandman 1
4779844 2289692 2289692 defendant Raulynson John husbandman 588382 588382 Raulynson, John, of Frysby, husbandman 2
4805225 2297834 2297834 plaintiff Brokesby Bartholomew esq 588382 588382 Brokesby, Bartholomew, of Frysby, Leicester, esq 0
4847027 2310574 2310574 defendant Bailly Reginald husbandman 588382 588382 Bailly, Reginald, of Frysby, husbandman 0
4874773 2319053 2319053 defendant Bailly Ralph husbandman 588382 588382 Bailly, Ralph, of Frysby, husbandman 1
4878114 2320108 2320108 defendant Bailly Ralph husbandman 588382 588382 Bailly, Ralph, of Frysby, husbandman 0
4888256 2323134 2323134 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
4924462 2334088 2334088 defendant Dekyn Richard husbandman 588382 588382 Dekyn, Richard, of Frysby, husbandman 1
4926874 2334835 2334835 defendant Bailly Ralph husbandman 588382 588382 Bailly, Ralph, of Frysby, husbandman 1
4987163 2353108 2353108 defendant Burton Thomas husbandman 588382 588382 Burton, Thomas, of Frysby, husbandman 6
4987164 2353108 2353108 defendant Sawer Thomas husbandman 588382 588382 Sawer, Thomas, of Frysby, husbandman 7
5014823 2361211 2361211 defendant Bailly John yeoman 588382 588382 Bailly, John, of Frysby, yeoman 2
5035743 2367310 2367310 defendant Webbe William husbandman 588382 588382 Webbe, William, of Frysby, husbandman 1
5037777 2367926 2367926 plaintiff Wryght John   588382 588382 Wryght, John, of Frysby 0
5051946 2372195 2372195 defendant Tansley William husbandman 588382 588382 Tansley, William, of Frysby, husbandman 0
5081231 2380891 2380891 defendant Lincolne Roger husbandman 588382 588382 Lincolne, Roger, of Frysby, husbandman 3
5081654 2381020 2381020 defendant Brese Thomas husbandman 588382 588382 Brese, Thomas, of Frysby, husbandman 0
5083201 2381473 2381473 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
5123704 2393391 2393391 defendant Brees John husbandman 588382 588382 Brees, John, of Frysby, husbandman 0
5124007 2393476 2393476 plaintiff Etton Robert   588382 588382 (Etton, Robert, of Frysby 1
5145381 2399795 2399795 plaintiff Brese John husbandman 588382 588382 Brese, John, of Frysby, husbandman 0
5149834 2401086 2401086 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
5149837 2401087 2401087 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
5165844 2405754 2405754 plaintiff Brese John husbandman 588382 588382 Brese, John, of Frysby, husbandman 0
5168620 2406542 2406542 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
5168625 2406543 2406543 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
5180406 2410011 2410011 plaintiff Brese John husbandman 588382 588382 Brese, John, of Frysby, husbandman 0
5180409 2410012 2410012 plaintiff Brese John husbandman 588382 588382 Brese, John, of Frysby, husbandman 0
5184643 2411254 2411254 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 0
5229194 2424147 2424147 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 1
5229200 2424148 2424148 plaintiff Etton Robert   588382 588382 Etton, Robert, of Frysby 1
5238104 2426731 2426731 defendant Bayly John husbandman 588382 588382 Bayly, John, of Frysby, husbandman 0
5268888 2436014 2436014 defendant Raulyns Thomas husbandman 588382 588382 Raulyns, Thomas, of Frysby, husbandman 4
5283435 2440211 2440211 plaintiff Etton Robert (legal representative) 588382 588382 Etton, Robert, of Frysby, executors of 0
5331163 2454395 2454395 defendant Webbe Thomas yeoman 588382 588382 Webbe, Thomas, of Frysby, yeoman 0
5331164 2454395 2454395 defendant Raulyng John husbandman 588382 588382 Raulyng, John, of Frysby, husbandman 1
5362499 2463923 2463923 plaintiff Brese John   588382 588382 Brese, John, of Frysby 2
5362526 2463930 2463930 plaintiff Brese John   588382 588382 Brese, John, of Frysby 2
5384820 2470734 2470734 plaintiff Brees John (legal representative) 588382 588382 Brees, John, of Frysby, executors of 0
5392815 2473015 2473015 defendant Blake William yeoman 588382 588382 Blake, William, of Frysby, yeoman 0
5396838 2474181 2474181 plaintiff Brees John (legal representative) 588382 588382 Brees, John, of Frysby, executors of 0
5413223 2478880 2478880 defendant Knyght John yeoman 588382 588382 Knyght, John, of Frysby, yeoman 1
5427694 2483240 2483240 defendant Neve Thomas husbandman 588382 588382 Neve, Thomas, of Frysby, husbandman 0
5427696 2483241 2483241 defendant Neve Thomas husbandman 588382 588382 Neve, Thomas, of Frysby, husbandman 0
5428363 2483408 2483408 defendant Knyght John yeoman 588382 588382 Knyght, John, of Frysby, yeoman 1
5428364 2483408 2483408 defendant Knyght Richard yeoman 588382 588382 Knyght, Richard, of Frysby, yeoman 2
5429144 2483644 2483644 defendant Brokesby Bartholomew esq 588382 588382 Brokesby, Bartholomew, of Frysby, gent, son & heir of John Brokesby of Frysby upon Wreke, esq 0
5445744 2488614 2488614 defendant Kynght John yeoman 588382 588382 Kynght, John, of Frysby, yeoman 1
5445745 2488614 2488614 defendant Knight Richard yeoman 588382 588382 together with Knight, Richard, of Frysby, yeoman 2
5451661 2490369 2490369 defendant Blak William yeoman 588382 588382 Blak, William, of Frysby, yeoman 0
5451663 2490370 2490370 defendant Blak William yeoman 588382 588382 Blak, William, of Frysby, yeoman 0
5547264 2519212 2519212 defendant Etton John esq 588382 588382 Etton, John, of Frysby, esq 0
5548445 2519580 2519580 defendant Brokesby Bartholomew esq 588382 588382 Brokesby, Bartholomew, of Frysby, esq 0
5562967 2523764 2523764 defendant Brokesby Bartholomew esq 588382 588382 Brokesby, Bartholomew, of Frysby, esq 0
5575252 2527352 2527352 defendant Etton John (legal representative) 588382 588382 Etton, John, of Frysby, esq, executor of 0
5575253 2527352 2527352 defendant Etton John gent 588382 588382 Etton, John, of Frysby, gent 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);