names

58 rows where place_id = 604987

✎ 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
3659960 1913374 1913374 defendant Champeneys Ambrose gent 604987 604987 Champeneys, Ambrose, of Colleshull, gent 0
4208011 2098363 2098363 defendant Feeld Humphrey tanner 604987 604987 Feeld, Humphrey, of Colleshull, tanner 0
4208012 2098363 2098363 defendant Feeld William tanner 604987 604987 Feeld, William, of Colleshull, tanner 1
4373954 2155754 2155754 defendant Lynne John butcher 604987 604987 Lynne, John, of Colleshull, butcher 0
4397822 2163850 2163850 defendant Bellers John gent 604987 604987 Bellers, John, of Colleshull, gent 0
4413083 2168964 2168964 defendant Lauweston John   604987 604987 Lauweston, John, of Colleshull 0
4413327 2169045 2169045 plaintiff Barre John   604987 604987 Barre, John, of Colleshull 0
4416011 2169897 2169897 defendant Deystere Hugh   604987 604987 Deystere, Hugh, of Colleshull 0
4419026 2170817 2170817 defendant Wydynton Adam de   604987 604987 Wydynton, Adam de, of Colleshull 0
4419027 2170817 2170817 defendant Copel Stephen   604987 604987 together with Copel, Stephen, of Colleshull 1
4419031 2170817 2170817 defendant Treublod William   604987 604987 Treublod, William, of Colleshull 5
4419032 2170817 2170817 defendant Martyn William butcher 604987 604987 Martyn, William, of Colleshull, son of William, butcher 6
4424745 2172576 2172576 defendant Deystere Hugh le   604987 604987 Deystere, Hugh le, of Colleshull 0
4426855 2173219 2173219 plaintiff Porter John le   604987 604987 Porter, John le, of Colleshull 0
4440498 2181938 2181938 defendant Coventre William de   604987 604987 Coventre, William de, of Colleshull 0
4444634 2183299 2183299 defendant Martyn William   604987 604987 Martyn, William, of Colleshull 0
4450747 2185196 2185196 defendant Martyn William   604987 604987 Martyn, William, of Colleshull 0
4459395 2187990 2187990 defendant Martyn William   604987 604987 Martyn, William, of Colleshull 0
4464375 2189527 2189527 defendant Baillif Nicholas   604987 604987 Baillif, Nicholas, of Colleshull 1
4464408 2189540 2189540 defendant Martyn William   604987 604987 Martyn, William, of Colleshull 0
4527037 2208737 2208737 plaintiff Lench Robert de   604987 604987 Lench, Robert de, of Colleshull 0
4527038 2208737 2208737 defendant Aleyn John draper 604987 604987 Aleyn, John, of Colleshull, draper 0
4572300 2222878 2222878 plaintiff Asshebroke Richard   604987 604987 Asshebroke, Richard, of Colleshull 0
4572302 2222879 2222879 plaintiff Asshebroke Richard   604987 604987 Asshebroke, Richard, of Colleshull 0
4580357 2225338 2225338 plaintiff Das John de   604987 604987 Das, John de, of Colleshull 0
4585626 2226931 2226931 defendant Aleyn John   604987 604987 Aleyn, John, of Colleshull 0
4605737 2232911 2232911 defendant Aleyn John draper 604987 604987 Aleyn, John, of Colleshull, draper 0
4605738 2232911 2232911 defendant Colyer Roger   604987 604987 Colyer, Roger, of Colleshull 1
4611459 2234646 2234646 defendant del More John   604987 604987 del More, John, of Colleshull 0
4612935 2235106 2235106 defendant Baxstere William   604987 604987 Baxstere, William, of Colleshull 0
4631213 2240660 2240660 defendant Hayward Walter   604987 604987 Hayward, Walter, of Colleshull 5
4700150 2265469 2265469 defendant Aleyn John draper 604987 604987 Aleyn, John, of Colleshull, draper 0
4700151 2265469 2265469 defendant Herman John yeoman 604987 604987 Herman, John, of Colleshull, yeoman 1
4700152 2265469 2265469 defendant Sharp William tailor 604987 604987 Sharp, William, of Colleshull, tailor 2
5134342 2396540 2396540 defendant Burton Thomas   604987 604987 Burton, Thomas, of Colleshull 0
5153788 2402268 2402268 plaintiff Kippyng William (legal representative) 604987 604987 Kippyng, William, of Colleshull, executrix of 0
5154549 2402483 2402483 defendant Burton Thomas yeoman 604987 604987 Burton, Thomas, of Colleshull, yeoman 0
5221583 2422007 2422007 defendant Everdon Richard yeoman 604987 604987 Everdon, Richard, of Colleshull, yeoman 4
5224352 2422797 2422797 defendant Tanner William baker 604987 604987 Tanner, William, of Colleshull, baker 0
5301719 2445470 2445470 defendant Baker Henry gent 604987 604987 Baker, Henry, of Colleshull, gent 2
5307908 2447381 2447381 defendant Baker Henry gent 604987 604987 Baker, Henry, of Colleshull, gent 3
5321282 2451461 2451461 defendant Choyce Richar barker 604987 604987 Choyce, Richar, of Colleshull, barker 0
5321284 2451461 2451461 defendant Glover Richard glover 604987 604987 Glover, Richard, of Colleshull, glover 2
5321285 2451461 2451461 defendant Canynges Richard husbandman 604987 604987 Canynges, Richard, of Colleshull, husbandman 3
5341685 2457593 2457593 defendant Baker Henry yeoman 604987 604987 Baker, Henry, of Colleshull, yeoman 0
5356224 2462026 2462026 defendant Choyce Richard barker 604987 604987 Choyce, Richard, of Colleshull, barker 0
5356228 2462027 2462027 defendant Grene John cordwainer 604987 604987 Grene, John, of Colleshull, cordwainer 0
5356237 2462028 2462028 defendant Wylkynson Peter smith 604987 604987 Wylkynson, Peter, of Colleshull, smith 3
5356238 2462028 2462028 defendant Harrys John baker 604987 604987 Harrys, John, of Colleshull, baker 4
5356239 2462028 2462028 defendant Tanner William baker 604987 604987 Tanner, William, of Colleshull, baker 5
5361923 2463755 2463755 plaintiff Taillour Thomas   604987 604987 Taillour, Thomas, of Colleshull 0
5579652 2528719 2528719 defendant Brown Agnes   604987 604987 (Brown, Agnes, of colleshull, widow, his former wife 2
5579653 2528719 2528719 defendant Badeley John yeoman 604987 604987 Badeley, John, of Colleshull, yeoman 3
5587084 2530989 2530989 defendant Badeley Henry (legal representative) 604987 604987 Badeley, Henry, of Colleshull, yeoman, executrix of 0
5587085 2530989 2530989 defendant Badeley Agnes widow 604987 604987 Badeley, Agnes, of Colleshull, widow 1
5599068 2534590 2534590 defendant Shilton Richard cordwainer 604987 604987 Shilton, Richard, of Colleshull, cordwainer 0
5610483 2546995 2546995 plaintiff Bakere Thomas drover 604987 604987 Bakere, Thomas, of Colleshull, drover 0
5611885 2547453 2547453 defendant Birshop William   604987 604987 Birshop, William, of Colleshull 0

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