names

79 rows where place_id = 586505

✎ 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
3588901 1864176 1864176 plaintiff Bradwey William yeoman 586505 586505 Bradwey, William, of Brokford, yeoman 0
3588903 1864177 1864177 plaintiff Bradwey William yeoman 586505 586505 Bradwey, William, of Brokford, yeoman 0
3645078 1908869 1908869 defendant Benet Henry husbandman 586505 586505 Benet, Henry, of Brokford, husbandman 1
3740245 1938806 1938806 plaintiff Revett John   586505 586505 Revett, John, of Brokford 0
3852461 1974377 1974377 defendant Peke Richard yeoman 586505 586505 Peke, Richard, of Brokford, yeoman 0
3852462 1974377 1974377 defendant Man Thomas yeoman 586505 586505 Man, Thomas, of Brokford, yeoman 1
3880840 1983860 1983860 defendant Peke Richard yeoman 586505 586505 Peke, Richard, of Brokford, yeoman 0
3880843 1983862 1983862 plaintiff Revet Christine widow 586505 586505 Revet, Christine, of Brokford, widow 0
4524761 2208083 2208083 defendant Noreys Walter   586505 586505 Noreys, Walter, of Brokford 0
4541801 2213325 2213325 defendant Pruerme Denis   586505 586505 Pruerme, Denis, of Brokford 3
4573471 2223231 2223231 plaintiff Baron Robert   586505 586505 Baron, Robert, of Brokford 0
4637318 2242468 2242468 defendant Baron Robert   586505 586505 Baron, Robert, of Brokford 0
4645225 2244675 2244675 defendant Baron Robert   586505 586505 Baron, Robert, of Brokford 1
4645640 2244789 2244789 defendant Baron Robert   586505 586505 Baron, Robert, of Brokford 3
4650202 2246081 2246081 defendant Baron Richard   586505 586505 Baron, Richard, of Brokford 0
4658490 2248534 2248534 defendant Spycer Robert yeoman 586505 586505 Spycer, Robert, of Brokford, yeoman 2
4662614 2249774 2249774 defendant Baron Robert hosteler 586505 586505 Baron, Robert, of Brokford, hosteler 1
4665074 2250555 2250555 defendant Baron Robert woolman 586505 586505 Baron, Robert, of Brokford, woolman 1
4673076 2257223 2257223 defendant Spycer Robert yeoman 586505 586505 Spycer, Robert, of Brokford, yeoman 1
4679658 2259253 2259253 defendant Bernam Robert husbandman 586505 586505 Bernam, Robert, of Brokford, husbandman 0
4679659 2259253 2259253 defendant Bernam Robert   586505 586505 Bernam, Robert, of Brokford, gent, his son 1
4682060 2260007 2260007 defendant Baroun Robert husbandman 586505 586505 Baroun, Robert, of Brokford, husbandman 0
4698943 2265147 2265147 defendant Norys Walter yeoman 586505 586505 Norys, Walter, of Brokford, yeoman 3
4704936 2266920 2266920 defendant Baron Robert husbandman 586505 586505 Baron, Robert, of Brokford,husbandman 0
4729326 2274389 2274389 defendant Kyng Henry weaver 586505 586505 Kyng, Henry, of Brokford, weaver 0
4742227 2278216 2278216 defendant Noreys Walter yeoman 586505 586505 Noreys, Walter, of Brokford, yeoman 0
4751246 2280840 2280840 defendant Motrego John yeoman 586505 586505 Motrego, John, of Brokford, yeoman 2
4762890 2284375 2284375 defendant Wright John husbandman 586505 586505 Wright, John, of Brokford, husbandman 0
4801965 2296798 2296798 defendant Sturmyn Richard yeoman 586505 586505 Sturmyn, Richard, of Brokford, yeoman 0
4844931 2309933 2309933 defendant Grympryst Walter yeoman 586505 586505 Grympryst, Walter, of Brokford, yeoman 1
4862716 2315323 2315323 defendant Whethereld W- smith 586505 586505 Whethereld, W-, of Brokford, smith 3
4872472 2318349 2318349 defendant Gr- Walter yeoman 586505 586505 Gr-, Walter, of Brokford, yeoman 1
4894959 2325087 2325087 defendant Grymprest Walter yeoman 586505 586505 Grymprest, Walter, of Brokford, yeoman 0
4896815 2325661 2325661 defendant Whethereld William smith 586505 586505 Whethereld, William, of Brokford, smith 2
4902295 2327328 2327328 plaintiff Kewe John   586505 586505 Kewe, John, of Brokford 1
4902310 2327331 2327331 defendant Grympryst Walter husbandman 586505 586505 Grympryst, Walter, of Brokford, husbandman 2
4914571 2331078 2331078 defendant Undirwode John yeoman 586505 586505 Undirwode, John, of Brokford, yeoman 0
4956372 2343870 2343870 defendant Cutteler Roger yeoman 586505 586505 Cutteler, Roger, of Brokford, yeoman 1
4957673 2344267 2344267 defendant Proum John sherman 586505 586505 Proum, John, of Brokford, sherman 0
4957674 2344267 2344267 defendant Doke Robert husbandman 586505 586505 Doke, Robert, of Brokford, husbandman 1
4959026 2344666 2344666 defendant Rede Robert tailor 586505 586505 Rede, Robert, of Brokford, tailor 1
4978128 2350423 2350423 defendant Doke William fuller 586505 586505 Doke, William, of Brokford, fuller 1
5006646 2358844 2358844 defendant Whitereld William smith 586505 586505 Whitereld, William, of Brokford, smith 0
5012833 2360586 2360586 defendant Whethereld William husbandman 586505 586505 Whethereld, William, of Brokford, husbandman 0
5016904 2361835 2361835 defendant Doke William fuller 586505 586505 Doke, William, of Brokford, fuller 1
5018436 2362275 2362275 defendant Dook William husbandman 586505 586505 Dook, William, of Brokford, husbandman 0
5023657 2363826 2363826 defendant D- William fuller 586505 586505 D-, William, of Brokford, fuller 3
5023662 2363827 2363827 defendant Deke William fuller 586505 586505 Deke, William, of Brokford, fuller 3
5033061 2366552 2366552 defendant Whythereld William smith 586505 586505 Whythereld, William, of Brokford, smith 0
5033065 2366553 2366553 defendant Whythereld William smith 586505 586505 Whythereld, William, of Brokford, smith 0
5044429 2369962 2369962 defendant Doke William fuller 586505 586505 Doke, William, of Brokford, fuller 3
5056404 2373489 2373489 defendant Wodeward John husbandman 586505 586505 Wodeward, John, of Brokford, husbandman 0
5062227 2375261 2375261 defendant Doke William fuller 586505 586505 Doke, William, of Brokford, fuller 3
5064374 2375892 2375892 defendant Witherald William yeoman 586505 586505 Witherald, William, of Brokford, yeoman 3
5075469 2379157 2379157 defendant Whethereld William husbandman 586505 586505 Whethereld, William, of Brokford, husbandman 3
5078433 2380048 2380048 defendant Whethereld William husbandman 586505 586505 Whethereld, William, of Brokford, husbandman 0
5099012 2386142 2386142 defendant Rede Robert tailor 586505 586505 Rede, Robert, of Brokford, tailor 0
5099388 2386250 2386250 defendant Wodeward John husbandman 586505 586505 Wodeward, John, of Brokford, husbandman 1
5100801 2386653 2386653 defendant Whethereld William (legal representative) 586505 586505 Whethereld, William, of Brokford, husbandman, administratrix of 1
5100802 2386653 2386653 defendant Whethereld Margaret widow 586505 586505 Whethereld, Margaret, of Brokford, widow 2
5123843 2393430 2393430 defendant Capel Edmund smith 586505 586505 Capel, Edmund, of Brokford, smith 2
5130721 2395475 2395475 plaintiff Fethyan Robert   586505 586505 Fethyan, Robert, of Brokford, 0
5183562 2410928 2410928 defendant Same Robert yeoman 586505 586505 Same, Robert, of Brokford, yeoman 2
5234391 2425648 2425648 defendant Launde Nicholas gent 586505 586505 Launde, Nicholas, of Brokford, gent 0
5268756 2435981 2435981 plaintiff Bradewey Robert yeoman 586505 586505 Bradewey, Robert, of Brokford, yeoman 0
5287206 2441278 2441278 defendant Man John, senior husbandman 586505 586505 Man, John, senior, of Brokford, husbandman 0
5296203 2443880 2443880 defendant Bradwey Robert husbandman 586505 586505 Bradwey, Robert, of Brokford, husbandman 0
5296207 2443881 2443881 defendant Bradwey Robert husbandman 586505 586505 Bradwey, Robert, of Brokford, husbandman 0
5310761 2448256 2448256 defendant Bradwey Robert husbandman 586505 586505 Bradwey, Robert, of Brokford, husbandman 0
5349171 2459868 2459868 defendant Bradewey Robert yeoman 586505 586505 Bradewey, Robert, of Brokford, yeoman 2
5397464 2474357 2474357 defendant Bradewey Robert yeoman 586505 586505 Bradewey, Robert, of Brokford, yeoman 5
5408533 2477516 2477516 defendant Bradewey William yeoman 586505 586505 Bradewey, William, of Brokford, yeoman 1
5421704 2481428 2481428 defendant Bradewey William yeoman 586505 586505 Bradewey, William, of Brokford, yeoman 1
5424637 2482336 2482336 defendant Crewley Robert yeoman 586505 586505 Crewley, Robert, of Brokford, yeoman 5
5441573 2487398 2487398 defendant Badwey William yeoman 586505 586505 Badwey, William, of Brokford, yeoman 1
5454124 2491133 2491133 defendant Bradewey Robert   586505 586505 Bradewey, Robert, of Brokford 5
5473279 2496972 2496972 defendant Seman Nicholas husbandman 586505 586505 Seman, Nicholas, of Brokford, husbandman 2
5479487 2498877 2498877 defendant Noreys William yeoman 586505 586505 Noreys, William, of Brokford, yeoman 0
5504198 2506228 2506228 defendant Bradewey William yeoman 586505 586505 Bradewey, William, of Brokford, yeoman 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);