names

47 rows where place_id = 729321

✎ 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
4281941 2123586 2123586 defendant Russell John yeoman 729321 729321 Russell, John, of Horstede, yeoman 0
4439679 2181679 2181679 defendant Stanynghale Robert de   729321 729321 Stanynghale, Robert de, of Horstede 0
4442680 2182659 2182659 defendant Lyoun John chandler 729321 729321 Lyoun, John, of Horstede, chandler 2
4542736 2213615 2213615 defendant Randolf Henry   729321 729321 Randolf, Henry, of Horstede, parson 0
4580789 2225473 2225473 defendant Wallere John   729321 729321 Wallere, John, of Horstede 0
4588954 2227919 2227919 plaintiff Larwode Thomas   729321 729321 Larwode, Thomas, of Horstede 0
4588956 2227920 2227920 plaintiff Larwode Thomas   729321 729321 Larwode, Thomas, of Horstede 0
4653234 2246950 2246950 defendant Larwode Thomas yeoman 729321 729321 Larwode, Thomas, of Horstede, yeoman 0
4653238 2246951 2246951 defendant Larwode Thomas yeoman 729321 729321 Larwode, Thomas, of Horstede, yeoman 0
4668897 2255974 2255974 defendant Croxton John husbandman 729321 729321 Croxton, John, of Horstede, husbandman 0
4710599 2268670 2268670 defendant Umfrey Richard laborer 729321 729321 Umfrey, Richard, of Horstede, laborer 3
4733435 2275633 2275633 defendant Newman John yeoman 729321 729321 Newman, John, of Horstede, yeoman 3
4735299 2276188 2276188 plaintiff Reve Robert   729321 729321 Reve, Robert, of Horstede 2
4755271 2282036 2282036 defendant Reve John husbandman 729321 729321 Reve, John, of Horstede, husbandman 0
4755272 2282036 2282036 defendant Symond John laborer 729321 729321 Symond, John, of Horstede, laborer 1
4755767 2282185 2282185 defendant Theweyt William yeoman 729321 729321 Theweyt, William, of Horstede, yeoman 0
4770445 2286728 2286728 defendant Thewyt William yeoman 729321 729321 Thewyt, William, of Horstede, yeoman 0
4814203 2300547 2300547 defendant Bate William yeoman 729321 729321 Bate, William, of Horstede, yeoman 3
4841114 2308754 2308754 defendant Bere John yeoman 729321 729321 Bere, John, of Horstede, yeoman 2
4856965 2313558 2313558 plaintiff Berd William   729321 729321 Berd, William, of Horstede 0
4884289 2321993 2321993 defendant Bere William yeoman 729321 729321 Bere, William, of Horstede, yeoman 1
4888488 2323196 2323196 defendant Charles John husbandman 729321 729321 Charles, John, of Horstede, husbandman 0
4888489 2323196 2323196 defendant Smyth John husbandman 729321 729321 Smyth, John, of Horstede, husbandman 1
4960164 2345012 2345012 defendant Smyth John husbandman 729321 729321 Smyth, John, of Horstede, husbandman 0
4967551 2347237 2347237 defendant Berte John husbandman 729321 729321 Berte, John, of Horstede, husbandman 2
4970357 2348082 2348082 defendant Smyth John laborer 729321 729321 Smyth, John, of Horstede, laborer 3
4997847 2356215 2356215 defendant Reve John husbandman 729321 729321 Reve, John, of Horstede, husbandman 1
4997848 2356215 2356215 defendant Cay John husbandman 729321 729321 Cay, John, of Horstede, husbandman 2
4997849 2356215 2356215 defendant Broun John husbandman 729321 729321 Broun, John, of Horstede, husbandman 3
5002983 2357775 2357775 defendant Reve John weaver 729321 729321 Reve, John, of Horstede, weaver 0
5035146 2367143 2367143 defendant Deye Robert   729321 729321 Deye, Robert, of Horstede, shepherd 2
5039348 2368414 2368414 defendant Tubbyng John (legal representative) 729321 729321 Tubbyng, John, of Horstede, tailor, executors of 0
5072414 2378238 2378238 defendant Deye Robert   729321 729321 Deye, Robert, of Horstede, shepherd 1
5093565 2384518 2384518 defendant Kay John husbandman 729321 729321 Kay, John, of Horstede, husbandman 0
5100260 2386519 2386519 defendant Clerk Peter yeoman 729321 729321 Clerk, Peter, of Horstede, yeoman 3
5101659 2386908 2386908 defendant Smyth Simon husbandman 729321 729321 Smyth, Simon, of Horstede, husbandman 4
5109024 2389058 2389058 defendant Lesse William laborer 729321 729321 Lesse, William, of Horstede, laborer 0
5109171 2389105 2389105 defendant Noble William husbandman 729321 729321 Noble, William, of Horstede, husbandman 0
5122097 2392882 2392882 defendant Godehewe John husbandman 729321 729321 Godehewe, John, of Horstede, husbandman 0
5138019 2397627 2397627 plaintiff Randolf John   729321 729321 Randolf, John, of Horstede 0
5138020 2397627 2397627 defendant Wode William husbandman 729321 729321 Wode, William, of Horstede, husbandman 0
5150562 2401306 2401306 defendant Kay John husbandman 729321 729321 Kay, John, of Horstede, husbandman 0
5158711 2403668 2403668 defendant Wode William husbandman 729321 729321 Wode, William, of Horstede, husbandman 0
5237367 2426514 2426514 defendant Spark Richard husbandman 729321 729321 Spark, Richard, of Horstede, husbandman 0
5241155 2427615 2427615 defendant Smyth Simon husbandman 729321 729321 Smyth, Simon, of Horstede, husbandman 2
5512966 2508907 2508907 defendant Howchones Peter yeoman 729321 729321 Howchones, Peter, of Horstede, yeoman 0
5555549 2521619 2521619 defendant Bonn William clerk 729321 729321 Bonn, William, of Horstede, clerk 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);